mysql常见问题

数据库客户端安装,解决本机无法连接远程数据库问题

yum install mysql -y   客户端安装

mysql -h192.168.43.119 -uroot -p1234  数据库连接

https://blog.csdn.net/weixin_34302798/article/details/92392496 

 

mysql8.0时报错:错误号码2058

https://jingyan.baidu.com/article/7908e85cda0de1af481ad22c.html

 

查看mysql的安装路径

https://blog.csdn.net/qq_33326449/article/details/80247208

 

远程授权

普通用户

create user ‘wangxy‘@‘%‘ identified by ‘wangxy‘;
grant all privileges on *.* to wangxy@‘%‘ with grant option;
ALTER USER ‘wangxy‘@‘%‘ IDENTIFIED WITH mysql_native_password BY ‘wangxy‘;

root用户

create user ‘root‘@‘%‘ identified by ‘wangxy‘;
grant all privileges on *.* to root@‘%‘ with grant option;
ALTER USER ‘root‘@‘%‘ IDENTIFIED WITH mysql_native_password BY ‘wangxy‘;
flush privileges;

mysql常见问题

上一篇:[adb devices]后,只显示 [List of devices attached],搜索不到设备信息,怎么办?


下一篇:mongodb如何新建用户