mysql二進位安裝

標籤：修改使用者名稱   pad   刪掉   自動   rect   explicit   logging   命令   機器   

檢查是否已經安裝mysql

rpm -qa| grep mysql

[[email protected] /]# rpm -qa | grep mysql 
mysql-libs-5.1.71-1.el6.x86_64

卸載mysql

rpm -e mysql-libs –nodeps

在電腦中尋找有關mysql的檔案儘可能刪掉，如果有的話 
比如/etc/my.cc或者/etc/mysql

下載及解壓安裝包 
官方為：http://dev.mysql.com/downloads/mysql/ 
Linux - Generic 
(mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz)

我的安裝目錄是: /home/mysql

#安裝libaio庫yum search libaio  yum install libaio #移動mysql更目錄到需要安裝的地方cd /home/setup/cleartar -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gzmv /home/setup/mysql-5.7.17-linux-glibc2.5-x86_64 /home/mysql#複製設定檔cp /home/mysql/support-files/my-default.cnf /etc/my.cnf#修改設定檔 修改內容如下vi /etc/my.cnf basedir = /home/mysql/datadir = /home/mysql/dataport = 3306socket = /home/mysql/tmp/mysql.sock#建立data,tmp目錄cd /home/mysqlmkdir datamkdir tmp#建立不可登陸使用者及組groupadd  mysqluseradd -r -g mysql -s /bin/false mysql #增加目錄許可權cd /home/mysqlchown -R mysql .chgrp -R mysql .#複製mysqldcp /home/mysql/support-files/mysql.server /etc/init.d/mysqldchmod 755 /etc/init.d/mysqld#初始化資料庫cd /home/mysql/bin./mysqld --user=mysql --basedir=/home/mysql --datadir=/home/mysql/data --initialize[Note] A temporary password is generated for [email protected]: b,prkho.N8Sm#需要注意關於timestamp的設定--explicit_defaults_for_timestamp#啟動service mysqld start#如果報如下錯誤：則需要轉到NEXT1[[email protected] bin]# service mysqld startStarting MySQL.Logging to ‘/home/mysql/data/test.myhome.m.hzwh.com.err‘.2017-05-02T00:20:15.262870Z mysqld_safe The file /usr/local/mysql/bin/mysqlddoes not exist or is not executable. Please cd to the mysql installationdirectory and restart this script from there as follows:./bin/mysqld_safe&See http://dev.mysql.com/doc/mysql/en/mysqld-safe.html for more information ERROR! The server quit without updating PID file (/home/mysql/data/test.myhome.m.hzwh.com.pid).#NEXT1#建立/usr/local/mysql/bin目錄cd /usr/localmkdir mysqlcd mysqlmkdir bin#建立連結ln -s /home/mysql/bin/mysqld /usr/local/mysql/bin/mysqld#啟動mysqldservice mysqld start#用戶端串連cd /home/mysql/bin./mysql -u root -p Enter password:這個也就是剛才的那個密碼：b,prkho.N8Sm如果報如下錯誤則轉到NEXT2[root@test bin]# ./mysql -u root -pEnter password: ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)#NEXT2ln -s /home/mysql/tmp/mysql.sock /tmp/mysql.sock./mysql -u root -p#登陸成功#修改root密碼為123456mysql>set password=password(‘123456‘);#建立使用者mysql>CREATE USER ‘fswh‘@‘localhost‘ IDENTIFIED BY ‘Fswh888$‘;#建立資料庫test_dbmysql> CREATE DATABASE IF NOT EXISTS `fswh_vipsys` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`;#使用者授權資料庫#只容許本地訪問mysql> GRANT ALL PRIVILEGES ON  fswh_vipsys.*  TO fswh@‘localhost‘;mysql> flush privileges;#開啟遠端存取,在Linux下為了安全，預設是不允許mysql本機以外的機器訪問mysql資料庫服務，因此需要重新授權使用者。mysql> GRANT ALL PRIVILEGES ON  fswh_vipsys.*  TO [email protected]‘%‘ IDENTIFIED BY ‘Fswh888$‘;mysql> flush privileges;#mysql 修改使用者名稱密碼mysql> use mysql;mysql> UPDATE user SET password=password("test123") WHERE user=‘root‘;   mysql> flush privileges;mysql> exit;#設定開機啟動#檢查自啟動項列表中沒有mysqld這個，如果沒有就添加mysqldchkconfig --list mysqldchkconfig --add mysqld#設定MySQL在345等級自動啟動chkconfig --level 345 mysqld on#或用這個命令設定開機啟動chkconfig mysqld on#mysql服務的啟動/重啟/停止service mysqld startservice mysqld restartservice mysqld stop

mysql二進位安裝