Skip to content

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; 📚 Related Articles →…

Sohaib Khan1 min read
How can I setup a remote connection to MySQL? — editorial illustration
PLAINTEXT1 line
mysql

or:

PLAINTEXT1 line
/usr/local/mysql/bin/mysql

Your shell prompt should now look like this:

PLAINTEXT1 line
mysql>

Run this command:

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

PLAINTEXT1 line
FLUSH PRIVILEGES;

Was this worth your time?

Continue reading

Full archive