Ubuntu14-04 MySQL-5.6.21通用二进制安装

#卸载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
巴特西

Ubuntu14-04 MySQL-5.6.21通用二进制安装

最新文章

热门文章
