安装源
rpm -Uvh http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
安装
yum -y install mysql-community-server
开放3306端口
firewall-cmd --permanent --zone=public --add-port=3306/tcp
firewall-cmd --reload
启动
systemctl start mysqld
初始密码
grep "password" /var/log/mysqld.log
修改密码
mysql -uroot -p ALTER USER 'root'@'localhost' IDENTIFIED BY '*********';
添加远程访问用户
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '*******';
flush privileges;重载用户权限
创建文件夹
mkdir /home/server/mysql/
mkdir -p /home/data/mysql/data/
mkdir -p /home/data/mysql/log/
cp /etc/my.cnf /etc/my.cnf.bak
vi /etc/my.cnf
[client]
port = 3306
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
port = 3306
datadir = /home/data/mysql/data
innodb_log_group_home_dir = /home/data/mysql/log
port = 3306
socket = /var/lib/mysql/mysql.sock
character-set-server=utf8
max_connections=1024
key_buffer_size = 128M
max_allowed_packet = 32M
table_open_cache = 64
net_buffer_length = 8K
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 32M
thread_cache_size = 128
query_cache_size = 32M
wait_timeout = 120
user=mysql
[mysqld_safe]
log-error=/home/data/mysql/log/mysqld-error.log
pid-file=/var/run/mysqld/mysqld.pid
复制文件
cp -R /var/lib/mysql/* /home/data/mysql/data/
建立连接ln /etc/my.cnf /home/server/mysql/
chown -R mysql:mysql /home/data/mysql #修改文件所属用户为mysql，所属用户组为mysql
移动文件
mv /home/data/mysql/data/ib_logfile0 /home/data/mysql/log/
mv /home/data/mysql/data/ib_logfile1 /home/data/mysql/log/
mv /home/data/mysql/data/mysql.sock /var/lib/mysql/
更改文件权限
chmod -R 660 /home/data/mysql/data/ibdata1
关闭selinux.并重启
setenforce 0 service mysqld restart
修改配置文件关闭selinux
vi /etc/selinux/config SELINUX=disabled
