[email protected]’%’ identified by ‘eee’; Create user lee password eee CREATE USER ‘lee’@’%’ IDENTIFIED BY ‘eee’; modify user ...">

当前位置：网站首页>A solution for adding new MySQL users that cannot be authorized

A solution for adding new MySQL users that cannot be authorized

2022-07-22 03:48:00 【arthur. dy.lee】

grant all privileges on lee.* to [email protected]’%’ identified by ‘eee’;
Create user lee password eee

CREATE USER ‘lee’@’%’ IDENTIFIED BY ‘eee’;
modify user Registered users in the table lee

update user set host=’%’ where user=‘lee’;
to grant authorization : This time it was a failure , It's OK to do it again

Grant all privileges on . to ‘lee’@’%’;
Re authorize : This time ok 了

Grant all privileges on . to ‘lee’@’%’;

版权声明
本文为[arthur. dy.lee]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/07/202207211113040341.html

边栏推荐

猜你喜欢