- 登入Mysql:
mysql -u root -p
grant all privileges on *.* to root@'%' identified by 'qwer';
//给予所有数据库访问权限,若要指定固定IP,替换%即可
grant all privileges on test.* to 'root'@'%' identified by 'qwer';
//给予指定数据库访问权限;
Mysql 访问权限
最新推荐文章于 2022-09-19 21:11:59 发布
mysql -u root -p
grant all privileges on *.* to root@'%' identified by 'qwer';
//给予所有数据库访问权限,若要指定固定IP,替换%即可 grant all privileges on test.* to 'root'@'%' identified by 'qwer';
//给予指定数据库访问权限;