下载MYSQL-RPM包:[url]http://downloads.mysql.com/archives/community/[/url]
移除mariadb lib
在/home下新建文件夹:
进入下载目录解压rpm包:
产生以下文件:
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
安装:
编辑my.cnf文件:
添加如下配置在mysqld下:
datadir = /home/mysqldata
log-error = /home/mysqllog/mysql_error.log
初始化数据库:
启动数据库:
#查看root账号密码
# The random password set for the root user at Tue Jul 26 10:20:23 2016 (local time): DZdxjSo4h_HB5DZp
访问mysql
[code="java"]# mysql -uroot –pDZdxjSo4h_HB5DZp
mysql> SET PASSWORD = PASSWORD('123456'); #设置密码为123456
mysql> exit[/code]
新建用户
开启mysql日志功能:
相关错误:
1.[color=red]The server quit without updating PID file[/color]
解决方法:
1).查看mysqldata与mysqllog的权限,mysql用户是否用户rwx权限,修改文件夹权限即可
2).关闭SELINUX
SELINUX概念配置:
[url]http://os.51cto.com/art/201105/265956.htm[/url]
[url]http://bguncle.blog.51cto.com/3184079/957315/[/url]
sudo vim /etc/selinux/config
将SELINUX=enforcing改为SELINUX=disabled
2. [color=red]Access denied for user 'root'@'localhost' (using password: YES)[/color],有时候用/root/.mysql_secret中的密码访问mysql时会报错
解决方法:
启动mysql
移除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
[code="java"]# mysql -uroot –pDZdxjSo4h_HB5DZp
mysql> SET PASSWORD = PASSWORD('123456'); #设置密码为123456
mysql> exit[/code]
新建用户
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.[color=red]The server quit without updating PID file[/color]
解决方法:
1).查看mysqldata与mysqllog的权限,mysql用户是否用户rwx权限,修改文件夹权限即可
2).关闭SELINUX
SELINUX概念配置:
[url]http://os.51cto.com/art/201105/265956.htm[/url]
[url]http://bguncle.blog.51cto.com/3184079/957315/[/url]
sudo vim /etc/selinux/config
将SELINUX=enforcing改为SELINUX=disabled
2. [color=red]Access denied for user 'root'@'localhost' (using password: YES)[/color],有时候用/root/.mysql_secret中的密码访问mysql时会报错
解决方法:
启动mysql
sudo mysqladmin -u root flush-privileges password "123456"