Shulou(Shulou.com)06/01 Report--

This article mainly introduces the solution to mysql ban external access solution analysis, hope to give you some knowledge to supplement and update, if there are other problems to understand, you can continue to pay attention to my update article in the industry information.

This article mainly describes when mysql prohibits external access to the solution, has a certain collection value, there is a need for friends to understand it.

1. ubuntu mysql 3306 allows remote access when the port is already open

vim /etc/mysql/mysql.conf.d/mysqld.cnf

Comment #bind-address = 127.0.0.1

2. Authorize users to allow remote access:

grant all privileges on *.* to root@"%" identified by "pwd" with grant option;

flush privileges;

Create and authorize user tests for certain permissions, performed in the user table of mysql database

1.mysql Create User:

CREATE USER 'taoshihan'@'localhost' IDENTIFIED BY '';

localhost is local only

% Yes Remote allowed

CREATE USER 'taoshihan115'@'%' IDENTIFIED BY 'TAOshihan1';

Delete user:

drop user 'taoshihan'@'localhost'

2. Authorized:

GRANT select ON *.* TO 'taishihan 115'@'%'; Authorization specified

GRANT all ON *.* TO 'taishihan 115'@'%'; Authorize all

The requested URL/var/log/mysql/was not found on this server.

If not, create a directory and change the owner of the directory chown mysql:mysql

To learn more about mysql tutorials, please pay attention to learn more mysql tutorials!

The above is the mysql ban external access solution details, more please pay attention to other related articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.