mysql压缩包安装

下载一个社区版的安装一下吧https://dev.mysql.com/downloads/

懒人脚本

groupadd mysql
useradd -r -g mysql mysql
yum -y install libaio-devel


[mysqld]
character-set-server=utf8
#datadir=/var/lib/mysql
datadir=/home/data/mysql
#socket=/var/lib/mysql/mysql.sock
socket=/home/data/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

启动脚本
#!/bin/bash
/home/williams/apps/mysql-5.6.41-linux-glibc2.12-x86_64/bin/mysqld_safe --defaults-file=/home/williams/apps/mysql-5.6.41-linux-glibc2.12-x86_64/my.cnf --user=williams

登录
bin/mysql -S mysql/mysql.sock
密码修改
set password for root@localhost=password('123mysql456');
grant all privileges on *.* to 'root'@'%' identified by '123mysql456';
flush privileges;

./bin/mysql -uroot -S mysql/mysql.sock -p123mysql456