centos7 安装mysql

下载MYSQL-RPM包：http://downloads.mysql.com/archives/community/
移除mariadb lib

rpm -qa  | grep mariadb
sudo yum remove mariadb-lib.x86-64

在/home下新建文件夹：

sudo mkdir mysqldata
sudo mkdir mysqllog
sudo chown -R mysql:mysql mysqldata
sudo chown -R mysql:mysql mysqllog

进入下载目录解压rpm包：

tar -xvf MySQL-5.6.24-1.el7.x86_64.rpm-bundle.tar

产生以下文件：
MySQL-embedded-5.6.24-1.el7.x86_64.rpm 
MySQL-shared-compat-5.6.24-1.el7.x86_64.rpm
MySQL-client-5.6.24-1.el7.x86_64.rpm     
MySQL-server-5.6.24-1.el7.x86_64.rpm   
MySQL-test-5.6.24-1.el7.x86_64.rpm
MySQL-devel-5.6.24-1.el7.x86_64.rpm      
MySQL-shared-5.6.24-1.el7.x86_64.rpm
安装：

sudo rpm -ivh MySQL-server-5.6.24-1.el7.x86_64.rpm
sudo rpm -ivh MySQL-devel-5.6.24-1.el7.x86_64.rpm 
sudo rpm -ivh MySQL-embedded-5.6.24-1.el7.x86_64.rpm  
sudo rpm -ivh MySQL-shared-compat-5.6.24-1.el7.x86_64.rpm
sudo rpm -ivh MySQL-shared-5.6.24-1.el7.x86_64.rpm
sudo rpm -ivh MySQL-client-5.6.24-1.el7.x86_64.rpm 

 
编辑my.cnf文件：

sudo cp /usr/share/mysql/my-default.cnf /etc/my.cnf
sudo vim /etc/my.cnf

添加如下配置在mysqld下：

datadir = /home/mysqldata
log-error = /home/mysqllog/mysql_error.log

初始化数据库：

sudo /usr/bin/mysql_install_db

启动数据库：

sudo service mysql start

#查看root账号密码

sudo cat /root/.mysql_secret 

# The random password set for the root user at Tue Jul 26 10:20:23 2016 (local time): DZdxjSo4h_HB5DZp
访问mysql

[root@localhost ~]# mysql -uroot –pDZdxjSo4h_HB5DZp
mysql> SET PASSWORD = PASSWORD('123456');    #设置密码为123456
mysql> exit

新建用户

FLUSH PRIVILEGES;
CREATE USER 'donald'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'donald'@'%' IDENTIFIED BY '123456';
FLUSH PRIVILEGES;

开启mysql日志功能：

log-bin = mysql-bin
log-error = /home/mysqllog/mysql_error.log
general_log = ON
general_log_file = /home/mysqllog/mysql.log
slow_query_log = ON
long_query_time=2
slow_query_log_file = /home/mysqllog/slowquery.log

相关错误：
1.The server quit without updating PID file
解决方法：
1）.查看mysqldata与mysqllog的权限，mysql用户是否用户rwx权限，修改文件夹权限即可
2）.关闭SELINUX
SELINUX概念配置：
http://os.51cto.com/art/201105/265956.htm
http://bguncle.blog.51cto.com/3184079/957315/
sudo vim /etc/selinux/config
将SELINUX=enforcing改为SELINUX=disabled

2. Access denied for user 'root'@'localhost' (using password: YES)，有时候用/root/.mysql_secret中的密码访问mysql时会报错
解决方法：
启动mysql

sudo mysqladmin -u root flush-privileges password "123456"