当前位置:   article > 正文

linux安装mysql8.0.x_mysql-8.3.0-linux-glibc2.27-aarch64

mysql-8.3.0-linux-glibc2.27-aarch64
  1. tar -xvf 可以解压tar.xz后缀的压缩文件
  2. tar -zxvf 可以解压tar.gz后缀的压缩文件

(以下以mysql-8.0.32-linux-glibc2.17-aarch64.tar.gz为例)

  1. 1、解压:
  2. tar -zxvf mysql-8.0.32-linux-glibc2.17-aarch64.tar.gz
  3. 2、重命名
  4. mv mysql-8.0.32-linux-glibc2.17-aarch64 mysql-8.0.32
  5. 3、创建data文件夹 储存文件
  6. cd mysql-8.0.32
  7. mkdir data
  8. 4、创建用户组和用户
  9. groupadd mysql
  10. useradd -g mysql mysql
  11. 5、授权用户
  12. chown -R mysql.mysql /usr/local/soft/mysql-8.0.32
  13. 6、mysql初始化(注意这里会生成密码,记得保存)
  14. cd bin
  15. ./mysqld --user=mysql --basedir=/usr/local/mysql-8.0.32 --datadir=/usr/local/mysql-8.0.32/data/ --initialize
  16. (注:如果报错
  17. ./mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
  18. -bash: ./mysqld:: 没有那个文件或目录
  19. 则执行: yum install -y libaio
  20. 参考:https://blog.csdn.net/ycsdn10/article/details/121934412
  21. )
  22. 然后再执行一次初始化
  23. 7、编辑my.cnf
  24. vim /etc/my.cnf

=====================下面是修改后的====================

  1. [[mysqld]
  2. #datadir=/var/lib/mysql 【修改点】
  3. datadir=/usr/local/mysql-8.0.19/data
  4. #【修改点】
  5. basedir=/usr/local/mysql-8.0.19
  6. 【修改点】
  7. #socket=/var/lib/mysql/mysql.sock
  8. socket=/tmp/mysql.sock]()
  9. Disabling symbolic-links is recommended to prevent assorted security risks
  10. symbolic-links=0
  11. Settings user and group are ignored when systemd is used.
  12. If you need to run mysqld under a different user or group,
  13. customize your systemd unit file for mariadb according to the
  14. instructions in http://fedoraproject.org/wiki/Systemd
  15. 【修改点】
  16. #[mysqld_safe]
  17. 【修改点】
  18. #log-error=/var/log/mariadb/mariadb.log
  19. 【修改点】
  20. #pid-file=/var/run/mariadb/mariadb.pid
  21. #
  22. include all files from the config directory
  23. #
  24. !includedir /etc/my.cnf.d
  1. 8、添加mysqld服务
  2. 返回mysql-8.0目录下,添加mysqld服务到系统
  3. cp -a ./support-files/mysql.server /etc/init.d/mysql
  4. 9.授权以及添加服务
  5. chmod +x /etc/init.d/mysql
  6. chkconfig --add mysql
  7. 10.启动mysql
  8. service mysql start
  9. 11.查看启动状态
  10. service mysql status
  11. 12.将mysql命令添加到服务
  12. ln -s /usr/local/mysql-8.0/bin/mysql /usr/bin
  13. 13.登录
  14. mysql -uroot -p
  15. 14.修改root密码
  16. ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
  17. flush privileges;
  18. 15.修改远程连接并生效
  19. use mysql;
  20. update user set host='%' where user='root';
  21. flush privileges;
  22. 16.开放防火墙3306端口
  23. firewall-cmd --add-port=3306/tcp --permanent
  24. firewall-cmd --reload
  25. 查看防火墙端口开放状态(看3306是否开启了)
  26. firewall-cmd --list-all

本文内容由网友自发贡献,转载请注明出处:https://www.wpsshop.cn/w/2023面试高手/article/detail/582436
推荐阅读
相关标签
  

闽ICP备14008679号