创建 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;