How to configure Internet access for mysql in ubuntu

1. use apt-getmysql-servermysql-client to install mysql and correctly configure the mysql User Password. you can access it locally through phpmyadmin, but it cannot be accessed within the LAN, the modified mysql configuration file is as follows: there are only a few lines of mysql real configuration files under ubuntu in...

1. use apt-get mysql-server mysql-client to install mysql and correctly configure the mysql User Password. you can access it locally through phpmyadmin, but it cannot be accessed within the LAN, the modified mysql configuration file contains the following lines:

Where is the real configuration file of mysql in ubuntu?

Reply content:

1. use apt-get mysql-server mysql-client to install mysql and correctly configure the mysql User Password. you can access it locally through phpmyadmin, but it cannot be accessed within the LAN, the modified mysql configuration file contains the following lines:

Where is the real configuration file of mysql in ubuntu?

By defaultmysqlThe configuration file is located in/etc/mysql/mysql.conf.d/And installed by defaultmysqlUserootThe account can only log on to the local machine

To remotely log on to mysql, you need to authorize the account in mysql. modifying the mysql configuration file cannot implement this function.
The specific command is:
GRANT ALL PRIVILEGES ON.TO 'username' @ '%' identified by 'password'; Grant remote logon permission

Grant all privileges on database. * TO 'username' @ '%' identified by 'password'; GRANT remote logon TO access only a database)

Flush privileges; effective immediately

The location is/etc/mysql. conf. d/mysqld. cnf.
The real configuration file is

Modify the configuration of a listener. [Mysqld]
Bind-address = Set to the IP address to be connected. Comment out the ip address if you do not know it.