mariabd数据库密码更改远程连接授权
2018-06-16 本文已影响0人
三不小青年
密码修改
更改数据库mysql: update user set password=password("密码") where user="root";
远程连接权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
flush privileges;
更改数据库mysql: update user set password=password("密码") where user="root";
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
flush privileges;