Linux 安装mysql 5.6

mysql5.6 64位 下载地址：

https://dev.mysql.com/downloads/mysql/5.5.html#downloads

解压

[root@iZuf6e79p9plbkel7exl9kZ ~]# tar -zxvf mysql-5.6.44-linux-glibc2.12-x86_64.tar.gz

将文件拷贝到/usr/local/mysql，由于mysql文件夹还没有创建，我们先创建一下

[root@iZuf6e79p9plbkel7exl9kZ ~]# mkdir /usr/local/mysql
[root@iZuf6e79p9plbkel7exl9kZ ~]# cp mysql-5.6.44-linux-glibc2.12-x86_64/. /usr/local/mysql -r

添加系统mysql组和mysql用户

[root@iZuf6e79p9plbkel7exl9kZ ~]# groupadd mysql
[root@iZuf6e79p9plbkel7exl9kZ ~]# useradd -r -g mysql mysql

进入安装mysql软件目录

[root@iZuf6e79p9plbkel7exl9kZ ~]# cd /usr/local/mysql

修改当前目录拥有者为mysql用户

[root@iZuf6e79p9plbkel7exl9kZ mysql]# chown -R mysql:mysql ./

安装数据库

[root@iZuf6e79p9plbkel7exl9kZ mysql]# ./scripts/mysql_install_db --user=mysql

在执行上一步的时候要是出现如下异常的处理方法

FATAL ERROR: please install the following Perl modules before executing ./scripts/mysql_install_db:
Data::Dumper
[root@iZuf6e79p9plbkel7exl9kZ mysql]# yum install -y perl-Module-Install.noarch

在处理完上面异常后执行安装数据库可能会出现如下异常，解决此异常后即可正常安装数据库了：

[root@iZuf6e79p9plbkel7exl9kZ mysql]# ./scripts/mysql_install_db --user=mysql
Installing MySQL system tables..../bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
[root@iZuf6e79p9plbkel7exl9kZ mysql]# yum -y install libaio-devel

 

修改当前目录拥有者为root用户

[root@iZuf6e79p9plbkel7exl9kZ mysql]# chown -R root:root ./

修改当前data目录拥有者为mysql用户

[root@iZuf6e79p9plbkel7exl9kZ mysql]# chown -R mysql:mysql data

添加开机启动

[root@iZuf6e79p9plbkel7exl9kZ mysql]# cp support-files/mysql.server /etc/init.d/mysql

启动mysql服务

[root@iZuf6e79p9plbkel7exl9kZ mysql]# service mysql start

启动mysql服务出现如下异常解决方法：

Starting MySQL.190522 15:26:24 mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log', however file don't exists. Create writable for user 'mysql'.
The server quit without updating PID file (/var/lib/mysql/i[FAILED]9plbkel7exl9kZ.pid).

解决方法，创建文件，并赋予权限

[root@iZuf6e79p9plbkel7exl9kZ mysql]# mkdir /var/log/mariadb
[root@iZuf6e79p9plbkel7exl9kZ mysql]# touch /var/log/mariadb/mariadb.log
[root@iZuf6e79p9plbkel7exl9kZ mysql]# chown -R mysql:db /var/log/mariadb/
chown: invalid group: ‘mysql:db’
[root@iZuf6e79p9plbkel7exl9kZ mysql]# chown -R root:root /var/log/mariadb/

重新启动mysql 服务

[root@iZuf6e79p9plbkel7exl9kZ mysql]# service mysql start
Starting MySQL.                                            [  OK  ]

连接mysql出现如下异常：

[root@iZuf6e79p9plbkel7exl9kZ ~]# mysql -h127.0.0.1 -uroot -p
-bash: mysql: command not found

解决方法：

[root@iZuf6e79p9plbkel7exl9kZ bin]# ln -s /usr/local/mysql/bin/mysql /usr/bin

mysql5.6默认密码为空，所以不用输入密码，直接回车就可以了

 

设置root用户可以远程访问：

mysql> use mysql;
Database changed
mysql> grant all privileges on *.* to root@'%' identified by "root@123";
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;