Linux安装MySQL8.0

1、https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz 下载mysql安装包

  1. [root@rhel6lhr local]# cd -
  2. /data
  3. [root@rhel6lhr data]# ls
  4. apache-tomcat-7.0.79        mysql
  5. apache-tomcat-7.0.79.zip    mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz
  6. jdk1.8.0_291                mysql-8.0.25-1.el6.x86_64.rpm-bundle.tar
  7. jdk-8u291-linux-x64.tar.gz
  8. [root@rhel6lhr data]# tar -zxvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz
  9. [root@rhel6lhr data]# mv mysql-8.0.11-linux-glibc2.12-x86_64 mysql8.0
  10. [root@rhel6lhr data]# groupadd mysql
  11. [root@rhel6lhr data]# useradd -r -g mysql mysql
  12. [root@rhel6lhr data]# chown -R mysql:mysql mysql8.0/
  13. [root@rhel6lhr mysql8.0]# ./bin/mysqld --initialize --basedir=/data/mysql8.0 --datadir=/data/mysql8.0/data --user=mysql
  14. 2021-06-23T16:32:33.928437Z 0 [System] [MY-013169] [Server] /data/mysql8.0/bin/mysqld (mysqld 8.0.11) initializing of server in progress as process 22211
  15. 2021-06-23T16:32:36.076474Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Bkqzp:sri0lx
  16. 2021-06-23T16:32:36.896864Z 0 [System] [MY-013170] [Server] /data/mysql8.0/bin/mysqld (mysqld 8.0.11) initializing of server has completed
  19. [root@rhel6lhr mysql]# service mysql start
  20. Starting MySQL.[  OK  ]
  21. [root@rhel6lhr mysql]# service mysql status;
  22. MySQL running (23535)[  OK  ]
  23. [root@rhel6lhr mysql8.0]# pwd
  24. /data/mysql8.0
  25. [root@rhel6lhr mysql8.0]# ./bin/mysql  -uroot -p
  26. Enter password: 
  27. Welcome to the MySQL monitor.  Commands end with ; or \g.
  28. Your MySQL connection id is 8
  29. Server version: 8.0.11
  31. Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
  33. Oracle is a registered trademark of Oracle Corporation and/or its
  34. affiliates. Other names may be trademarks of their respective
  35. owners.
  37. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  39. mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
  40. Query OK, 0 rows affected (0.03 sec)
  41. mysql> use mysql;
  42. Reading table information for completion of table and column names
  43. You can turn off this feature to get a quicker startup with -A
  45. Database changed
  46. mysql> select 'host' from user where user='root';
  47. +------+
  48. | host |
  49. +------+
  50. | host |
  51. +------+
  52. 1 row in set (0.00 sec)
  54. mysql> update user set host = '%' where user ='root';
  55. Query OK, 1 row affected (0.04 sec)
  56. Rows matched: 1  Changed: 1  Warnings: 0
  58. mysql> flush privileges;
  59. Query OK, 0 rows affected (0.00 sec)
  61. mysql> select 'host'   from user where user='root';
  62. +------+
  63. | host |
  64. +------+
  65. | host |
  66. +------+
  67. 1 row in set (0.00 sec)
  69. mysql> exit