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常见问题

原文：https://www.cnblogs.com/Dreamsoft/p/14177164.html