最简版 麒麟 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