数据库客户端安装,解决本机无法连接远程数据库问题
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;