mysql linux下安装

卸载mariadb

rpm -qa | grep mariadb
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

安装mysql

rpm -ivh mysql-community-common-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.29-1.el7.x86_64.rpm

如果此步出现错误：libaio.so.1()(64bit) is needed by MySQL-server 执行命令安装：缺少：libaio、net-tools、perl、numactl包，yum install
安装就好了 yum install libaio yum install net-tools yum install perl yum install numactl

启动mysql

systemctl start mysqld
systemctl enable mysqld
systemctl daemon-reload

获取登录密码并登录

grep "password" /var/log/mysqld.log

mysql -uroot -p 

输入上面的密码

修改密码并授权可远程登录

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
set global validate_password_policy=0; 
set global validate_password_length=1;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH  PRIVILEGES;

设置SQL_MODEL

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
#设置大小写
lower_case_table_names=1

更改数据目录

chown -R mysql:mysql /home/mysql/data/mysql
chmod -R 755 /home/mysql/data/mysql

编辑/etc/selinux/config 文件，将其中的SELINUX禁用，SELINUX=disabled，重新启动系统。

1.vim /etc/selinux/config

SELINUX=disabled

2.vim /etc/my.cnf：

[mysqld]

datadir=/home/mysql/data/mysql
socket=/home/mysql/data/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
lower_case_table_names=1