Latest Job

How to connect My SQL Database Remotely

To grant access to a database user:

Log in to the DB server.
Connect to the MySQL database from the root user.
Enter following command:

GRANT ALL ON .* TO @ IDENTIFIED BY ”;
For example,

GRANT ALL ON helpdb.* TO dbuser@192.0.2.50 IDENTIFIED BY ‘custom-password’;

mysql> FLUSH PRIVILEGES;

then

Verify database access


On your web node host, enter the following command to verify the connection works:

mysql -u -h -p

Comment here