1.mysql -uroot -p
2.输入密码:
3.update mysql.user set authentication_string=password(’123456’) where user=’oneuser’ and Host = ’%’;
![mysql创建新用户并授权访问操作该数据库 - 数据库](https://www.gzhxs.cn/wp-content/uploads/2023/01/49868.webp)
4.grant all privileges on onetable.* to oneuser@’%’ identified by ’123456’;
5.flush privileges;
然后外部连接数据库。
1.mysql -uroot -p
2.输入密码:
3.update mysql.user set authentication_string=password(’123456’) where user=’oneuser’ and Host = ’%’;
4.grant all privileges on onetable.* to oneuser@’%’ identified by ’123456’;
5.flush privileges;
然后外部连接数据库。