linux 下安装 mysql

下载mysql

https://cdn.mysql.com/archives/mysql-8.0/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz

参考官方资料

https://dev.mysql.com/doc/refman/8.0/en/binary-installation.html

1.这个版本的mysql 需要依赖libaio库，如果没下载可以用yum下载

shell> yum search libaio  
shell> yum install libaio 

2.创建mysql用户和组

shell> groupadd mysql
shell> useradd -r -g mysql -s /bin/false mysql

3.mysql.server默认读取/user/local/mysql,所以文件默认解压到/user/local下

shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz -C /usr/local
shell> mv /usr/local/mysql-VERSION-OS.tar.gz /usr/local/mysql   命令为mysql

mysql.server在/mysql/support-files/mysql.server中

4.配置

hell> mkdir mysql-files
shell> chown mysql:mysql mysql-files
shell> chmod 750 mysql-files
shell> bin/mysqld --initialize --user=mysql
shell> bin/mysql_ssl_rsa_setup
shell> bin/mysqld_safe --user=mysql &

注意：第五步bin/mysqld --initialize --user=mysql 会给出登录密码，记得记下来，不然到时候登录mysql不知道密码

5.启动解决一些常见问题

shell> /usr/local/mysql/support-files/mysql.server start

显示错误：
1./var/log/mariadb/mariadb.log 不存在，则需要创建该log文件
shell> mkdir /var/log/mariadb
shell> touch /var/log/mariadb/mariadb.log
shell> chown mysql:mysql /var/log/mariadb
shell> chown mysql:mysql /var/log/mariadb/mariadb.log

2.ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (13)
shell> ln -s /var/lib/mysql/mysql.socket  /tmp/mysql.socket

6.登录

shell> cp /usr/local/mysql/support-files/mysql.server  /etc/init.d/mysql.server
shell> /etc/init.d/mysql.server start
shell> mysql -u root -p 
Enter password: 

将之前给出的登录密码输入，第一次登录mysql会要求更改密码后进行操作，执行下面命令，将新密码改成root

mysql>alter user 'root'@'localhost' identified by 'root' expire never;

退出重新登录就可以了，expire never 是指密码永不过期

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)