mysql 添加远程用户

 CREATE USER 'user1'@'localhost' IDENTIFIED BY 'user1_password';

CREATE DATABASE IF NOT EXISTS `test_db`  CHARSET `utf8`;

GRANT ALL PRIVILEGES ON  test_db.*  TO user1@'localhost';

flush privileges;

GRANT ALL PRIVILEGES ON  test_db.*  TO user1@'%' IDENTIFIED BY 'user1_password';

flush privileges;

#bind-address           = 127.0.0.1

sodu service mysql restart

use mysql;

UPDATE user SET password=password("test123") WHERE user='root';
# mysql8.0

update user set authentication_string='test123' where user='root'
flush privileges;

exit;