After Ububtu is installed with MySQL, it cannot be connected to the Internet by default, but many times we want to facilitate management over the Internet. Here, I will briefly describe my operations in the configuration process. The steps are as follows: log on to mysqlmysql-uroot-p as the root to create a user CREATEUS Ububtu that can log on to the Internet to install MySQL. by default, the Internet cannot be connected, however, many times we want to facilitate management of Internet access. Here, we will briefly describe your operations in the configuration process as follows:
Log on to mysql as root
Mysql-u root-p
Create an Internet-accessible user
Create user 'custom' @ '% .example.com' identified by 'user _ password ';
Authorize a user
Grant select, INSERT, UPDATE, DELETE, CREATE, drop on customer. * TO 'custom' @ '% ';
Check/etc/mysql/my. cnf and remove the bound ip address.
Restart service
Sudo service mysql restart