mysql安裝-CentOS6下解壓安裝mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz

標籤：問題：   bin   var   chgrp   axel   comm   bnu   最新版   ble   

刪除已經安裝版本yum list installed mysql[[email protected] ~]# yum list installed mysqlLoaded plugins: fastestmirror, refresh-packagekit, securityLoading mirror speeds from cached hostfile* base: mirrors.cn99.com* extras: mirrors.cn99.com* updates: mirrors.cn99.comInstalled Packagesmysql.x86_64 yum remove mysql.x86_64 1.下載安裝wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz(axel多線程下載: axel -n 10 https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz ) tar -xvzf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz mv mysql-5.7.20-linux-glibc2.12-x86_64 /usr/local/mysql 添加使用者及使用者分組、目錄許可權groupadd mysqluseradd mysql -g mysqlcd mysqlchown -R mysql .chgrp -R mysql . 安裝依賴庫yum install libaioyum install -y libnuma.so.1 安裝資料庫（資料庫初始化）cd /usr/local/mysqlmkdir datacd /usr/local/mysql/bin./mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data -------注意,資料存放區目錄，因為/目錄空間很小不夠使用，所以我把資料存放區到 /data/mysql57下了,即mkdir /data/mysql57chown -R mysql /data/mysql57chgrp -R mysql /data/mysql57cd /usr/local/mysql/bin ./mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql57 這裡可能會遇到的問題：Installing MySQL system tables..../bin/mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory 原因：是用yum 安裝的libnuma.so.1，安裝時預設安裝的是32的，但db需要的是64位的 解決辦法：1.如果已經安裝了libnuma.so.1，先yum remove libnuma.so.1；安裝 yum -y install numactl.x86_64  2.啟動登陸cd /usr/local/mysql/support-files./mysql.server start  登入mysql，此版本最新版不許空密碼登入，實際上有個初始化密碼儲存在/root/.mysql_secret這個檔案裡面，用這個密碼第一次登入後，再修改密碼。因此先cat查看下初始化密碼（隨機的，每次安裝看到的密碼都不一樣）：[[email protected] ~]# cat /root/.mysql_secret cd /usr/local/mysql/bin./mysql -uroot -pI+0tKc3(kDS/   改mysql的root密碼，新密碼在此為‘leizm‘mysql> set password=password(‘12root‘);Query OK, 0 rows affected, 1 warning (0.00 sec)  GRANT ALL PRIVILEGES ON *.* TO [email protected]‘%‘ identified by ‘123456a‘;flush privileges;  3. 添加系統服務shell> cp support-files/mysql.server /etc/init.d/mysqldshell> service mysqld start  http://blog.51cto.com/pengjc/1861088如果啟動過程或mysql用戶端串連有問題配置 my.cnfvi /etc/my.cnf  [mysqld]bind-address=0.0.0.0#mysql安裝根目錄basedir = /usr/local/mysql#datadir=/var/lib/mysqldatadir=/data/mysql57#socket=/var/lib/mysql/mysql.socksocket=/data/mysql57/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0 #Port number to use for connections.port=15024 #innodb_buffer_pool_size=256Mmax_allowed_packet = 32M#query_cache_size = 128M max_connections=300 log-bin=mysql-binserver-id=10632 [client]socket =/data/mysql57/mysql.sock   [mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid MySql5.7 設定檔 my.cnf 設定http://www.voidcn.com/article/p-zrikccdi-hr.html

mysql安裝-CentOS6下解壓安裝mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz