mariadb 10使用账户密码登录并配置远程访问

1.配置使用账号密码登录

use mysql;

update user set authentication_string=password('password'),plugin='mysql_native_password' where user='root';

2.配置远程登录
注释掉 bind-address
然后

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

评论

暂无评论