mysql 5.7.14 裝置設置裝備擺設代碼分享。本站提示廣大學習愛好者：（mysql 5.7.14 裝置設置裝備擺設代碼分享）文章只能為提供參考，不一定能成為您想要的結果。以下是mysql 5.7.14 裝置設置裝備擺設代碼分享正文
本文記載了mysql 5.7.14 裝置設置裝備擺設代碼，詳細內容以下
OS: CentOS 6.6
DB: Mysql 5.7.14
1. 下載mysql
cd /tools
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.14-linux-glibc2.5-x86_64.tar.gz
2.創立MySQL二進制解壓文件的目次
mkdir -p /opt/mysql [root@zw-test-db mysql]# cd /tools/ [root@zw-test-db tools]# ll -l mysql-5.7.14-linux-glibc2.5-x86_64.tar.gz -rw-r--r-- 1 root root 642694570 Aug 29 15:02 mysql-5.7.14-linux-glibc2.5-x86_64.tar.gz
3. 解壓到 /opt/mysql 目次下
[root@zw-test-db tools]# cd /opt/mysql/ [root@zw-test-db mysql]# tar -zxvf /tools/mysql-5.7.14-linux-glibc2.5-x86_64.tar.gz [root@zw-test-db mysql]# mv mysql-5.7.14-linux-glibc2.5-x86_64/ mysql-5.7.14 [root@zw-test-db mysql]# ll drwxr-xr-x 9 7161 31415 4096 Jul 12 21:03 mysql-5.7.14
4. 創立一個軟銜接到 /usr/local
[root@zw-test-db mysql]# cd /usr/local/ [root@zw-test-db local]# ls bin etc games include lib lib64 libexec redis-3.2.2 sbin share src [root@zw-test-db local]# ln -s /opt/mysql/mysql-5.7.14 /usr/local/mysql [root@zw-test-db local]# ll mysql lrwxrwxrwx 1 root root 23 Aug 31 17:36 mysql -> /opt/mysql/mysql-5.7.14 [root@zw-test-db local]#
5. 創立用戶
[root@zw-test-db /]# groupadd mysql [root@zw-test-db /]# useradd -M -g mysql -s /sbin/nologin -d /usr/local/mysql mysql
-s nologin 沒有shell 不克不及登錄的
6. 基於設置裝備擺設文件創立根本的目次
mkdir /data/mysql mkdir /data/mysql/mysql_3306 cd /data/mysql/mysql_3306/ mkdir data mkdir logs mkdir tmp chown -R mysql:mysql /data/mysql/mysql3306
7.創立/etc/my.cnf設置裝備擺設文件 (進程略)
8.初始化，5.7的初始化會加一個默許的暗碼
[root@zw-test-db mysql]# cd /usr/local/mysql/ [root@zw-test-db mysql]# ./bin/mysqld --initialize [root@zw-test-db data]# pwd /data/mysql/mysql_3306/data ### 上面是5.5， 5.6 初始化 /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql
9.檢查 error日記，看有無error
cd /data/mysql/mysql_3306/data [root@zw-test-db data]# vim error.log [root@zw-test-db data]# tail -f error.log 2016-08-31T09:44:32.394657Z 0 [Note] Giving 0 client threads a chance to die gracefully 2016-08-31T09:44:32.394680Z 0 [Note] Shutting down slave threads 2016-08-31T09:44:32.394686Z 0 [Note] Forcefully disconnecting 0 remaining clients 2016-08-31T09:44:32.415409Z 0 [Note] Binlog end 2016-08-31T09:44:32.434217Z 0 [Note] InnoDB: FTS optimize thread exiting. 2016-08-31T09:44:32.434293Z 0 [Note] InnoDB: Starting shutdown... 2016-08-31T09:44:32.534587Z 0 [Note] InnoDB: Dumping buffer pool(s) to /data/mysql/mysql_3306/data/ib_buffer_pool 2016-08-31T09:44:32.534741Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160831 17:44:32 2016-08-31T09:44:34.308784Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2525428 2016-08-31T09:44:34.308945Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
10.檢查初始化暗碼
[root@zw-test-db data]# grep password error.log
2016-08-31T09:44:21.172167Z 1 [Note] A temporary password is generated for root@localhost: 8aahkRkxfm%t
暗碼是： 8aahkRkxfm%t
11 創立一個啟動劇本
[root@zw-test-db data]# cd /usr/local/mysql/
[root@zw-test-db mysql]# cp support-files/mysql.server /etc/init.d/mysql
cp: overwrite `/etc/init.d/mysql'? y
12.啟動mysql的三種方法
方法一：
root@zw-test-db bin]# ./mysqld_safe --user=mysql & [1] 12455 [root@zw-test-db bin]# 160830 15:18:01 mysqld_safe Logging to '/usr/local/mysql/data/zw-test-db.err'. 160830 15:18:01 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
方法二：
[root@zw-test-db bin]# /etc/init.d/mysqld restart
Shutting down MySQL..160830 15:18:14 mysqld_safe mysqld from pid file /usr/local/mysql/data/zw-test-db.pid ended
[ OK ]
Starting MySQL. [ OK ]
[1]+ Done ./mysqld_safe --user=mysql
方法三：
[root@zw-test-db bin]# service mysqld restart Shutting down MySQL.. [ OK ] Starting MySQL. [ OK ] [root@zw-test-db bin]#
13. 添加情況變量
echo "export PATH=\$PATH:/usr/local/mysql/bin" >> /root/.bash_profile
source /root/.bash_profile
14. 上岸
[root@zw-test-db mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.7.14-log 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)]>show databases; --提醒要修正暗碼 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
15.修正暗碼
root@localhost [(none)]>alter user user() identified by '123456'; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) root@localhost [(none)]>show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.00 sec)
可以檢查數據庫了
16. 5.6版本之前須要帳號平安加固，5,7今後 test數據庫都沒有了
delete from mysql.user where user!='root' or host!='localhost'; --刪除非root用戶，上岸主機不是localhost的賬號 flush privileges; alter user user() identified by '123456'; drop database test; truncate mysql.db;
出色專題分享：mysql分歧版本裝置教程 mysql5.7各版本裝置教程
以上就是本文的全體內容，願望對年夜家的進修有所贊助，也願望年夜家多多支撐。
