Search Our Database

Last updated on Feb 23,2020 |

under

by Louis

If your web server does not have phpMyAdmin installed, you may add remote host for your database by first accessing your web server via SSH.

Step 1 – Login into MySQL server.

Step 2 – If you wish to allow database user “ips1” to access database “myDatabase” at IP address “192.168.1.1“, execute the following command.

GRANT ALL PRIVILEGES ON myDatabase.* TO ips1@'192.168.1.1' IDENTIFIED BY 'ips1DbUserPassword' with grant option;
flush privileges;

Step 3 – If you wish to revoke database user “ips1” from accessing “myDatabase” at IP address “192.168.1.1“, execute the following command.

DELETE FROM mysql.user WHERE User = 'ips1' AND Host = '192.168.1.1';
flush privileges;