#卸载mysql
/etc/init.d/mysqld stop &> /dev/null
killall mysqld &> /dev/null
sudo rm -rf /mengdi/server/mysql &> /dev/null
sudo rm -rf /mengdi/server/mysql-* &> /dev/null
sudo rm -rf /mengdi/log/mysql &> /dev/null
sudo rm -rf /etc/my.cnf
sudo rm -f /etc/init.d/mysqld
更改环境变量
准备工作1，创建环境统一目录
sudo mkdir /mengdi
cd /mengdi
sudo mkdir server
sudo mkdir -p log/mysql
准备工作2，创建mysql用户及组
groupadd mysql
useradd -g mysql -s /sbin/nologin mysql
准备工作3，安装依赖
apt-get -y update
apt-get -y autoremove mysql-server
apt-get -y install unzip build-essential libncurses5-dev libfreetype6-dev libxml2-dev libssl-dev libcurl4-openssl-dev libjpeg62-dev libpng12-dev libfreetype6-dev libsasl2-dev libpcre3-dev autoconf libperl-dev libtool libaio*
着手干
cd /usr/src
下载 mysql-5.6. 通用二进制文件 sudo wget http://zy-res.oss-cn-hangzhou.aliyuncs.com/mysql/mysql-5.6.21-linux-glibc2.5-x86_64.tar.gz
也可 sudo wget -P /usr/src http://zy-res.oss-cn-hangzhou.aliyuncs.com/mysql/mysql-5.6.21-linux-glibc2.5-x86_64.tar.gz
cd /usr/src
sudo -xzf mysql-5.6.-linux-glibc2.-x86_64.tar.gz #解压
cd /mengdi/server
sudo cp -r /usr/src/mysql-5.6.-linux-glibc2.-x86_64 ./ #拷贝文件
sudo ln -s /mengdi/server/mysql-5.6.-linux-glibc2.-x86_64/ /mengdi/server/mysql
sudo /mengdi/server/mysql/scripts/mysql_install_db --datadir=/mengdi/server/mysql/data/ --basedir=/mengdi/server/mysql --user=mysql #安装
chown -R mysql:mysql /alidata/server/mysql/ #更改权限
chown -R mysql:mysql /alidata/server/mysql/data/ #更改权限
chown -R mysql:mysql /alidata/log/mysql/ #更改权限
sudo cp -f /mengdi/server/mysql/support-files/mysql.server /etc/init.d/mysqld #拷贝启动文件
sudo sed -i 's/^basedir=$/basedir=\/mengdi\/server\/mysql/' /etc/init.d/mysqld #替换路径
sudo sed -i 's/^datadir=$/datadir=\/mengdi\/server\/mysql\/data/' /etc/init.d/mysqld #替换路径
sudo vim /etc/my.cnf #启动时，未指定配置文件时，会用此文件
[client]
port=
socket=/tmp/mysql.sock
[mysqld]
port=
socket=/tmp/mysql.sock
skip-external-locking
log-error=/mengdi/log/mysql/error.log
key_buffer_size=16M
max_allowed_packet=1M
table_open_cache=
sort_buffer_size=512K
net_buffer_length=8K
read_buffer_size=256K
read_rnd_buffer_size=512K
myisam_sort_buffer_size=8M
log-bin=mysql-bin
binlog_format=mixed
server-id=
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size=20M
sort_buffer_size=20M
read_buffer=2M
write_buffer=2M
[mysqlhotcopy]
interactive-timeout
expire_logs_days=
max_binlog_size=1000M
sudo chmod /etc/init.d/mysqld
sudo /etc/init.d/mysqld start #{start|stop|restart|reload|force-reload|status}
ps -ef |grep mysqld
export PATH=$PATH:/mengdi/server/mysql/bin
