(1)下載mysql二進制分發包到工作目錄
(2)創建mysql 用戶
shell> groupadd mysql
shell> useradd -g mysql mysql
(3)解壓縮
shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz
(4)將工作目錄鏈接到/usr/local/mysql
shell> cd /usr/localshell> ln -s full-path-to-mysql-VERSION-OS mysql
(5)安裝數據庫
shell> cd mysql
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root? .
shell> chown -R mysql data
shell> chgrp -R mysql .
*此時可以手動啟動數據庫:
shell> bin/mysqld_safe --user=mysql &
(6)設置mysql自動啟動
將/usr/local/mysql/support-files/mysql.server 復制到/etc/init.d/mysql
shell> cp mysql.server /etc/init.d/mysql
shell> chmod +x /etc/init.d/mysql
在ubuntu server中添加為系統服務:
sudo update-rc.d mysql defaults
如需刪除服務:
sudo update-rc.d mysql remove?
在RHEL4中:
shell> chkconfig --add?mysql
(7)配置mysql
添加my.cnf到/etc
啟動數據庫更改root密碼:
cd /usr/local/mysql/bin./mysql -u root -p
mysql>GRANT ALL PRIVILEGES ON *.* TO? root@ localhost IDENTIFIED BY "password";
或者啟動遠程訪問:
mysql>GRANT ALL PRIVILEGES ON *.* TO? root@ "%" IDENTIFIED BY "password";
(2)創建mysql 用戶
shell> groupadd mysql
shell> useradd -g mysql mysql
(3)解壓縮
shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz
(4)將工作目錄鏈接到/usr/local/mysql
shell> cd /usr/localshell> ln -s full-path-to-mysql-VERSION-OS mysql
(5)安裝數據庫
shell> cd mysql
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root? .
shell> chown -R mysql data
shell> chgrp -R mysql .
*此時可以手動啟動數據庫:
shell> bin/mysqld_safe --user=mysql &
(6)設置mysql自動啟動
將/usr/local/mysql/support-files/mysql.server 復制到/etc/init.d/mysql
shell> cp mysql.server /etc/init.d/mysql
shell> chmod +x /etc/init.d/mysql
在ubuntu server中添加為系統服務:
sudo update-rc.d mysql defaults
如需刪除服務:
sudo update-rc.d mysql remove?
在RHEL4中:
shell> chkconfig --add?mysql
(7)配置mysql
添加my.cnf到/etc
啟動數據庫更改root密碼:
cd /usr/local/mysql/bin./mysql -u root -p
mysql>GRANT ALL PRIVILEGES ON *.* TO? root@ localhost IDENTIFIED BY "password";
或者啟動遠程訪問:
mysql>GRANT ALL PRIVILEGES ON *.* TO? root@ "%" IDENTIFIED BY "password";