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;