Ubuntu 安装 mysql

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
tar xvf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
mv mysql/ /usr/local/
useradd mysql
mkdir mydata
mkdir mydata/data
chown -R mysql mysql/
vim /etc/my.cnf

[client]
port = 3306
socket = /tmp/mysql.sock

[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'
basedir=/usr/local/mysql
datadir=/usr/local/mysql/mydata/data
socket=/tmp/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/usr/local/mysql/mysqld.pid
lower_case_table_names = 1
user=mysql

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
max_connections=1000

这里的内容尽量不要有改变，要不然会有不可预测问题

touch /var/log/mysqld.log
chmod 777 /var/log/mysqld.log
touch /var/run/mysqld/mysqld.pid
chmod 777 /var/run/mysqld

安装 libaio
apt-get install libaio-dev

/usr/local/mysql/bin/mysqld –initialize –user=mysql –basedir=/usr/local/mysql –datadir=/usr/local/mysql/mydata/data –lc_messages_dir=/usr/local/mysql/share –lc_messages=en_US

touch mysqld.pid
chmod 777 mysqld.pid
chown mysql.mysql mysqld.pid
support-files/mysql.server start

加入系统服务
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
Ubuntu
update-rc.d mysqld defaults
centOs
chkconfig –add mysqld
chkconfig –level 2345 mysqld on