Configure MySQL for Internet access in Ubuntu

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, we will briefly describe your operations in the configuration process as follows: log on to mysqlmysql-uroot-p as the root user to create a user that can log on to the Internet using CREATEUSER 'custom' @ '% .example.com' IDENTIFIEDBY 'user _ password ';

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, 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

For more information about Ubuntu, see Ubuntu special page http://www.linuxidc.com/topicnews.aspx? Tid = 2

This article permanently updates the link address: Http://www.linuxidc.com/Linux/2015-10/124091.htm