本地远程连接:
mysql -uroot -pDwksl_392304hJEKSX -h10.1.242.216 -P3306
创建用户:
CREATE USER ‘usercenter’@‘%’ IDENTIFIED BY ‘dahua_pwd’;
修改密码:
ALTER USER ‘myuser’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘newpassword’
授权:
GRANT ALL ON usercenter.* TO ‘usercenter’@‘%’;
error_eg:ERROR 1044 (42000): Access denied for user ‘root’@‘%’ to database ‘usercenter’
https://blog.csdn.net/weixin_42715225/article/details/108006107?spm=1001.2101.3001.6650.1&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7ERate-1-108006107-blog-52938751.235%5Ev38%5Epc_relevant_anti_vip_base&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7ERate-1-108006107-blog-52938751.235%5Ev38%5Epc_relevant_anti_vip_base&utm_relevant_index=2