創(chuàng)建MySQL所需目錄
mkdir /usr/local/mysql
mkdir /usr/local/mysql/etc
mkdir /usr/local/mysql/database
創(chuàng)建MySQL使用的用戶和組
useradd mysql
檢查編譯環(huán)境汤徽，在檢查完成后可通過(guò)“echo $?”命令檢查是否有錯(cuò)誤追迟，當(dāng)輸入結(jié)果為0是表示沒(méi)有錯(cuò)誤
cd mysql
./configure --prefix-/usr/local/mysql --sysconfdir=/usr/local/mysql/etc \
--localstatedir=/usr/local/mysql/database --with-character=utf8
編譯、安裝MySQL
make & make install
安裝mysql、test 和information_schema數(shù)據(jù)庫(kù)
cd /usr/local/mysql/
./bin/mysql_install_db --user=mysql
建立MySQL配置文件
cd /usr/local/mysql/
cp /usr/local/mysql/share/mysql/my-huge.cnf /etc/my.cnf
cp /usr/local/mysql/share/mysql.server /etc/rc.d/init.d/mysqld
chown -R mysql:mysql /usr/local/mysql/database/
chown -R mysql:mysql /usr/local/mysql/lib/
./bin/mysql_safe --user=mysql &
增加MySQL服務(wù)、啟動(dòng)服務(wù)并設(shè)置為下次啟動(dòng)自動(dòng)加載
chkconfig --add mysqld
service mysqld restart
chkconfig mysqld onn
將MySQL相關(guān)命令復(fù)制到/sbin目錄
cp /usr/local/mysql/bin/* /sbin
使用mysqladmin創(chuàng)建MySQL管理員及密碼
mysqladmin -u root password abc123
?
