MySQL 5.5 編譯與排錯

標籤：exist   iso   環境變數   creat   blackhole   file   載入本地   rc.local   OLE   

**************************************************************************************************
MySQL 5.5 編譯
**************************************************************************************************

1.安裝編譯環境

yum install -y gcc gcc-c++

2.安裝Ncurses

yum install -y ncurses-devel

tar -xzvf ncurses-6.1.tar.gz

cd ncurses-6.1/

./configure --with-shared \
--without-debug \
--without-ada \
--enable-overwrite

make && make install

3.安裝Cmake和Bison

yum install -y cmake bison

4.安裝MySQL

groupadd mysql

useradd mysql -s /sbin/nologin -M -g mysql

tar -xzvf mysql-5.5.59.tar.gz

cd mysql-5.5.59/

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.5 \
-DMYSQL_DATADIR=/usr/local/mysql-5.5/data \
-DMYSQL_UNIX_ADDR=/usr/local/mysql-5.5/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DENABLED_LOCAL_INFILE=ON \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITH_FAST_MUTEXES=1 \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3306 \
-DWITH_DEBUG=0

==============================================================================
上面↑語句的解釋

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql#安裝位置
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock#指定socket檔案位置
-DEXTRA_CHARSETS=all#擴充字元支援
-DDEFAULT_CHARSET=utf8 #預設字元集
-DDEFAULT_COLLATION=utf8_general_ci #預設字元校對
-DWITH_MYISAM_STORAGE_ENGINE=1 #安裝myisam儲存引擎
-DWITH_INNOBASE_STORAGE_ENGINE=1 #安裝innodb儲存引擎
-DWITH_MEMORY_STORAGE_ENGINE=1 #安裝memory儲存引擎
-DWITH_READLINE=1 #支援readline庫
-DENABLED_LOCAL_INFILE=1 #啟用載入本機資料
-DMYSQL_USER=mysql #指定mysql運行使用者
-DMYSQL_TCP_PORT=3306#指定mysql連接埠

==============================================================================

make && make install

==================================================
MySQL 5.5 配置
==================================================

1.MySQL目錄授權

chown -R mysql:mysql /usr/local/mysql-5.5/

2.拷貝MySQL設定檔

cp -a /usr/local/mysql-5.5/support-files/my-medium.cnf /etc/my.cnf
cp -a /usr/local/mysql-5.5/support-files/mysql.server /etc/init.d/mysqld

chmod +x /etc/init.d/mysqld

3.初始化MySQL

cd /usr/local/mysql-5.5/scripts/

/usr/local/mysql-5.5/scripts/mysql_install_db \
--basedir=/usr/local/mysql-5.5/ \
--datadir=/usr/local/mysql-5.5/data/ \
--user=mysql

4.啟動MySQL

/etc/init.d/mysqld start

/usr/local/mysql-5.5/bin/mysqld_safe --user=mysql &

5.配置環境變數

echo ‘export PATH=/usr/local/mysql-5.5/bin:$PATH‘ >> /etc/profile

source /etc/profile

6.設定登陸密碼

/usr/local/mysql-5.5/bin/mysql_secure_installation

7.設定MySQL開機啟動

chkconfig mysqld on

chkconfig --list mysqld

echo "/usr/local/mysql/bin/mysqld_safe --user=mysql &" >> /etc/rc.local

7.登陸MySQL測試

/usr/local/mysql-5.5/bin/mysql -uroot -p

**************************************************************************************************
MySQL-5.5排錯
**************************************************************************************************
[問題描述]

描述：MySQL 第一次初始化後無法啟動

錯誤碼：Starting MySQL..The server quit without updating PID file ([FAILED]al/mysql-5.5/data/www.pid).

錯誤碼：Starting MySQL.180421 12:24:46 mysqld_safe error: log-error set to ‘/usr/local/mysql-5.5/error.log‘, however file don‘t exists. Create writable for user ‘mysql‘.
The server quit without updating PID file (/usr/local/mysql[FAILED]a/www.pid).

[解決方案策略]

vim /etc/my.cnf

[mysqld]

log-error = /usr/local/mysql-5.5/error.log
datadir = /usr/local/mysql-5.5/data

chown -R mysql.mysql /usr/local/mysql-5.5

./usr/local/mysql-5.5/scripts/mysql_install_db

==============================================================================================

MySQL 5.5 編譯與排錯