1、确认是否已经安装了依赖包 [root@dbrac16 ~]# yum info libaio | grep -A 1 Installed This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register. Installed Packages Name : libaio
2、创建用户和组 [root@dbrac16 ~]# groupadd mysql [root@dbrac16 ~]# useradd -r -g mysql -s /bin/false mysql
3、解压安装包并修改权限 [root@dbrac16 ~]# cd /usr/local/ [root@dbrac16 local]# tar -xvzf /root/mysql-5.7.16-linux-glibc2.5-x86_64.tar.gz [root@dbrac16 local]# mv mysql-5.7.16-linux-glibc2.5-x86_64/ mysql [root@dbrac16 local]# cd mysql/ [root@dbrac16 mysql]# mkdir mysql-files data [root@dbrac16 mysql]# chown -R mysql:mysql .
5、初始化 [root@dbrac16 mysql]# bin/mysqld --initialize --user=mysql 100 200 300 400 500 100 200 300 400 500 2017-05-10T06:45:22.857917Z 0 [Warning] InnoDB: New log files created, LSN=45790 2017-05-10T06:45:22.979376Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-05-10T06:45:23.050120Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 3de828ce-354c-11e7-9f0b-0050568a4cf6. 2017-05-10T06:45:23.052326Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2017-05-10T06:45:23.055440Z 1 [Note] A temporary password is generated for root@localhost: i*JRv8dBo,dO 2017-05-10T06:45:24.359775Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. 2017-05-10T06:45:24.359823Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2017-05-10T06:45:24.359844Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2017-05-10T06:45:24.359861Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. 2017-05-10T06:45:24.360360Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
[root@dbrac16 mysql]# bin/mysql_ssl_rsa_setup Generating a 2048 bit RSA private key ...................+++ ................................+++ writing new private key to 'ca-key.pem' ----- Generating a 2048 bit RSA private key ................................................................................................................................................+++ ..............................+++ writing new private key to 'server-key.pem' ----- Generating a 2048 bit RSA private key .........+++ ..........................+++ writing new private key to 'client-key.pem' -----
7、修改密码 [root@dbrac16 mysql]# mysql -u root -p Enter password: i*JRv8dBo,dO Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.16
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
(root@localhost)[(none)] use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Database changed (root@localhost)[mysql] update user set host = '%' where user = 'root'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0
