linux mysql-5.7.26 安装全记录

买了个阿里云，自己折腾一下。

时间：2019年7月17日13:40:18

1、下载

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz

2、解压

tar -zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz 

3、移动文件到 usr/local/mysql目录下

mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql
发现写错了，移到上层目录
cd /usr/local/mysql/
cd mysql-5.7.26-linux-glibc2.12-x86_64/
cd ..
mv mysql-5.7.26-linux-glibc2.12-x86_64/* ./
rm -rf mysql-5.7.26-linux-glibc2.12-x86_64/

4、增加用户组

groupadd mysql

useradd -r -g mysql mysql

5、修改当前目录拥有者为mysql用户：执行命令 

chown -R mysql:mysql ./

6、安装

cd /usr/local/mysql/bin/
./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
./mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
报错了
rpm -qa|grep libaio
yum install  libaio-devel.x86_64
安装一个这玩意
./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data 
再执行，有warn 没error了

2019-07-17T05:51:34.038056Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-07-17T05:51:35.100511Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-07-17T05:51:35.223640Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-07-17T05:51:35.287407Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: efa727f9-a856-11e9-96d2-00163e063119.
2019-07-17T05:51:35.289478Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-07-17T05:51:35.289924Z 1 [Note] A temporary password is generated for root@localhost: gpPkXgqLT1=S   这个是随机密码

初始化完毕后在命令行最后会提供生成好的随机密码，先拷贝下来

7、修改权限

然后修改下权限，把除了data外的所有mysql文件的权限都设置为root
chown -R root:root ./
chown -R mysql:mysql data

8、启动mysql服务和添加开机启动mysql服务

添加开机启动：执行命令cp support-files/mysql.server /etc/init.d/mysql，把启动脚本放到开机初始化目录
启动mysql服务：执行命令 service mysql start

Starting MySQL.2019-07-17T05:59:19.660315Z 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]gohhgjiy8uy2gZ.pid).
pwd
/usr/local/mysql
报错，权限问题还是文件夹没有。。

建一个

mkdir /var/log/mariadb
touch /var/log/mariadb/mariadb.log
chown -R mysql:mysql /var/log/mariadb/
service mysql start
Starting MySQL.2019-07-17T06:02:23.769297Z mysqld_safe Directory '/var/lib/mysql' for UNIX socket file don't exists.
The server quit without updating PID file (/var/lib/mysql/i[FAILED]gohhgjiy8uy2gZ.pid).

又少了啥

mkdir   /var/lib/mysql

chmod 777  /var/lib/mysql

service mysql start

Starting MySQL....The server quit without updating PID file[FAILED]ib/mysql/iZ2ze967kgohhgjiy8uy2gZ.pid).

日了。。

去/etc/下看看 my.cnf

vim /etc/my.cnf

发现datadir 不是咱指定的那个

改一下

datadir = /usr/local/mysql/data

保存，再启动。

service mysql start
Starting MySQL. [ OK ]

没错，绿色是我自己改的！！

搞定了

9、改密码

mysql -u root -p
登录，密码就是上面标红的位置
会提示
ERROR 1862 (HY000): Your password has expired. To log in you must change it using a client that supports expired passwords.
意思就是密码要过期了。

./mysql -u root -p
再登录一遍
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 5
Server version: 5.7.26

mysql> set password = password('1111');
Query OK, 0 rows affected, 1 warning (0.00 sec)

完事！

10、备注一下，3306端口默认开放，如果用Navicat去连的话，阿里云服务器连不上，上阿里云控制台