mysql 添加远程用户

mysql 添加远程用户

1. 添加用户

创建 mysql 用户

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

创建数据库：test_db

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';

#mysql 8.0

ALTER USER ‘zheng’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘zhengzongwei’;

flush privileges;

并开启mysql允许远程访问配置，在 my.cnf 47行， bind-address 前增加 # 号，注释掉 bind-address = 127.0.0.1
sudo vi /etc/mysql/my.cnf

#bind-address           = 127.0.0.1

重启 mysql

sodu service mysql restart

mysql 修改用户名密码

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;