二、安裝配置

1、新建目錄

sudo mkdir /usr/shopxx

sudo mkdir /usr/shopxx/soft


2、下載mysql-5.5.45-linux2.6-x86_64.tar.gz至/usr/shopxx/soft

sudo wget -P /usr/shopxx/soft http://storage.shopxx.net/file/mysql-5.5.45-linux2.6-x86_64.tar.gz


3、解壓/usr/shopxx/soft/mysql-5.5.45-linux2.6-x86_64.tar.gz至/usr/shopxx

sudo tar -zxvf /usr/shopxx/soft/mysql-5.5.45-linux2.6-x86_64.tar.gz -C /usr/shopxx


4、重命名/usr/shopxx/mysql-5.5.45-linux2.6-x86_64為/usr/shopxx/mysql5.5

sudo mv /usr/shopxx/mysql-5.5.45-linux2.6-x86_64 /usr/shopxx/mysql5.5


5、創建用戶組mysql

sudo groupadd mysql


6、創建用戶mysql

sudo useradd -s /usr/sbin/nologin -r -g mysql mysql


7、修改/usr/shopxx/mysql5.5所有者為mysql

sudo chown -R mysql:mysql /usr/shopxx/mysql5.5


8、初始化授權表

cd /usr/shopxx/mysql5.5

sudo scripts/mysql_install_db --user=mysql


9、復制并重命名/usr/shopxx/mysql5.5/support-files/my-medium.cnf為/usr/shopxx/mysql5.5/my.cnf

sudo cp /usr/shopxx/mysql5.5/support-files/my-medium.cnf /usr/shopxx/mysql5.5/my.cnf


10、修改配置文件/usr/shopxx/mysql5.5/my.cnf,修改如下內容

[mysqld]

# 端口

port = 3306

# 字符集編碼

character-set-server = utf8


11、創建鏈接

sudo ln -s /usr/shopxx/mysql5.5 /usr/local/mysql

sudo ln -s /usr/shopxx/mysql5.5/support-files/mysql.server /etc/init.d/mysql


12、配置MySQL自動啟動

sudo update-rc.d mysql defaults


13、啟動MySQL

sudo /etc/init.d/mysql start


14、停止MySQL

sudo /etc/init.d/mysql stop


15、修改root密碼

sudo /usr/shopxx/mysql5.5/bin/mysqladmin -u root -p password 新密碼


16、連接MySQL

sudo /usr/shopxx/mysql5.5/bin/mysql -u root -p


17、創建數據庫shopxx

create database shopxx;


18、創建用戶并授權

grant all on shopxx.* to 用戶名@localhost identified by '密碼';


三、相關文件

mysql-5.5.45-linux2.6-x86_64.tar.gz??my.cnf


本文鏈接: http://www.093ee.com/news/detail/5d5fc3a208813b0001c3536c