允许远程连接:
登录数据库:mysql -u root -h localhost -p
选库: use mysql
更新用户权限: update user set host='%' where user='root' and host='localhost';
刷新权限:flush privileges;
关闭远程连接:
选库: use mysql
update user set host='localhost' where user='root';
flush privileges;
允许远程连接:
登录数据库:mysql -u root -h localhost -p
选库: use mysql
更新用户权限: update user set host='%' where user='root' and host='localhost';
刷新权限:flush privileges;
关闭远程连接:
选库: use mysql
update user set host='localhost' where user='root';
flush privileges;