服务器开发之—MariaDB(MySql)

安装

手动启动

连接数据库

执行命令:

退出

navicat for mac 完美破解版

解决远程连接

 

问题汇总

1.Host ‘xxx’ is not allowed to connect to this MySQL server.(1251 client does not support)
修改mysql库中user表User字段为root的Host为%;同时修改加密方式为:mysql_native_password,具体步骤:
1)打开CMD切到C:\Program Files\MySQL\MySQL Server 8.0\bin 目录依实际而定
2)mysql -u root -p
3)  输入密码
4)修改 host:  update host = ‘%’ from user where user = ‘root’
5)  修改加密方式:

#更改加密方式并更新一下用户的密码 
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘Root的密码’ PASSWORD EXPIRE NEVER;
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘Root的密码’;
#刷新权限
FLUSH PRIVILEGES;

待续…