最简版 麒麟 arm 安装mysql
参考:
https://www.cnblogs.com/indifferent/p/14628152.html
yum install -y net-tools libaio numactl-libs
# wget http://mirror.centos.org/altarch/7/os/aarch64/Packages/numactl-libs-2.0.12-5.el7.aarch64.rpm
# wget http://mirror.centos.org/altarch/7/os/aarch64/Packages/libaio-0.3.109-13.el7.aarch64.rpm
rpm -ivh mysql-community-common-8.0.22-1.el8.aarch64.rpm
rpm -ivh mysql-community-client-plugins-8.0.22-1.el8.aarch64.rpm
rpm -ivh mysql-community-libs-8.0.22-1.el8.aarch64.rpm
rpm -ivh mysql-community-client-8.0.22-1.el8.aarch64.rpm
rpm -ivh mysql-community-server-8.0.22-1.el8.aarch64.rpm
[ERROR] [MY-012271] [InnoDB] The innodb_system data file 'ibdata1' must be writable
chmod -R 777 /var/lib/mysql
要点:
/etc/my.cnf 里:
user=mysql
这应该放最后,否则之后的参数不生效
skip-grant-tables
要点:
如果宿主机端口占用,docker无法使用端口
要点:
登陆直接用 mysql -uroot -p -S
问题:
用navicat连接数据库报错:1130-host ... is not allowed to connect to this MySql server如何处理
参考:https://blog.csdn.net/zd147896325/article/details/82427107
问题:
Navicat 报错 "2059" Host '' is not allowed to connect to this MySQL server
参考:
https://blog.csdn.net/q258523454/article/details/84555847
中间的 ALTER user 'root'@'localhost' IDENTIFIED BY '123456'; 改成 https://blog.csdn.net/q258523454/article/details/84555847
来自:
https://blog.csdn.net/q258523454/article/details/84555847
Navicat 导出导入
来自:
https://blog.csdn.net/qq_21808961/article/details/80899928