Create a MySQL Remote Account in Ubuntu

1. Create a remote user in phpMyAdmin and grant the related database operation permissions.

2. I have to modify the MySQL configuration file in Ubuntu. this is not mentioned in many materials. I have also made many detours here, specifically:

File a/etc/MySQL/My. CNF, search for bind_address = 127.0.0.1, add # At the beginning of the line, that is, comment out

B. Restart MySQL,/etc/init. d/MySQL restart.

3. Telnet www.yourdomain.com 3306. If the connection is successful, you can connect remotely.