How can I setup a remote connection to MySQL?

mysql

or:

/usr/local/mysql/bin/mysql

Your shell prompt should now look like this:

mysql>

Run this command:

GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY "PASSWORD";

FLUSH PRIVILEGES;

 

Leave a Reply

Your email address will not be published. Required fields are marked *