一、系統(tǒng)環(huán)境

Ubuntu 14.04 64位

MySQL 5.5.45 64位

二、安裝配置

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、創(chuàng)建用戶組mysql

sudo groupadd mysql

6、創(chuàng)建用戶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、初始化授權(quán)表

cd /usr/shopxx/mysql5.5

sudo scripts/mysql_install_db --user=mysql

9、復(fù)制并重命名/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，修改如下內(nèi)容

[mysqld]

# 端口

port = 3306

# 字符集編碼

character-set-server = utf8

11、創(chuàng)建鏈接

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、創(chuàng)建數(shù)據(jù)庫shopxx

create database shopxx;

18、創(chuàng)建用戶并授權(quán)

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

三、相關(guān)文件

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