CentOS-7MySQL 5.7.26安装

我用的非root账户 在 /usr/local目录下安装 卸载系统自带的 mariadb 否则影响 mysql 的安装 查找是否有：rpm -qa|grep mariadb 卸载：sudo rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64 创建 mysql 用户组： sudo groupadd mysql 创建 mysql 用户(禁止登录)： sudo useradd -r -g mysql -s /bin/false mysql 切换至 mysql 安装目录： cd /usr/local

[qgn@localhost ~]$ rpm -qa|grep mariadb mariadb-libs-5.5.60-1.el7_5.x86_64 [qgn@localhost ~]$ sudo rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64 [qgn@localhost ~]$ sudo groupadd mysql [qgn@localhost ~]$ sudo useradd -r -g mysql -s /bin/false mysql [qgn@localhost ~]$ cd /usr/local [qgn@localhost local]$

下载 MySQL 下载地址：https://dev.mysql.com/downloads/mysql/5.7.html#downloads 点击 DownLoad 不登录下载即可

或者直接在linux 上下载 sudo wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz 解压 sudo tar zxf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz 修改文件夹名字为 mysql：sudo mv mysql-5.7.26-linux-glibc2.12-x86_64 mysql 在 mysql 创建 data 文件夹：sudo mkdir mysql/data 更改文件所属用户和组：sudo chown -R mysql:mysql ./mysql

[qgn@localhost local]$ sudo mv ~/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz ./ [qgn@localhost local]$ sudo tar zxf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz [qgn@localhost local]$ sudo mv mysql-5.7.26-linux-glibc2.12-x86_64 mysql [qgn@localhost local]$ sudo mkdir mysql/data [qgn@localhost local]$ sudo chown -R mysql:mysql ./mysql [qgn@localhost local]$ ll 总用量 629756 drwxr-xr-x. 2 root root 6 4月 11 2018 bin drwxr-xr-x. 2 root root 6 4月 11 2018 etc drwxr-xr-x. 2 root root 6 4月 11 2018 games drwxr-xr-x. 2 root root 6 4月 11 2018 include drwxr-xr-x. 2 root root 6 4月 11 2018 lib drwxr-xr-x. 3 root root 26 5月 22 20:41 lib64 drwxr-xr-x. 2 root root 6 4月 11 2018 libexec drwxr-xr-x. 10 mysql mysql 141 5月 25 11:18 mysql -rw-rw-r--. 1 qgn qgn 644869837 5月 25 11:12 mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz drwxr-xr-x. 2 root root 6 4月 11 2018 sbin drwxr-xr-x. 5 root root 49 5月 23 04:09 share drwxr-xr-x. 2 root root 6 4月 11 2018 src [qgn@localhost local]$

进入 mysql 目录：cd mysql 初始化： ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

如果遇到下面错误。则是权限不够，更改 data 文件夹的权限：sudo chmod 777 data 然后再初始化，完成之后，绿色方框里面 root@localhost 后面为初始密码，记下来，一会登录用 将 support-files下面的mysql.server 文件复制到 /etc/init.d/mysql sudo cp support-files/mysql.server /etc/init.d/mysql 修改 /etc/init.d/mysql 文件如下： sudo vim /etc/init.d/mysql 更改 /etc/init.d/mysql 文件执行权限： sudo chmod a+x /etc/init.d/mysql 直接启动：/etc/init.d/mysql start 或者 service mysql start

[qgn@localhost mysql]$ sudo cp support-files/mysql.server /etc/init.d/mysql [qgn@localhost mysql]$ sudo vim /etc/init.d/mysql [qgn@localhost mysql]$ sudo chmod a+x /etc/init.d/mysql [qgn@localhost mysql]$ /etc/init.d/mysql start Starting MySQL. SUCCESS! [qgn@localhost mysql]$

成功开启 mysql 服务 查看 mysql 服务 ps -ef | grep mysql

[qgn@localhost mysql]$ ps -ef | grep mysql qgn 78467 1 0 17:14 pts/0 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/localhost.localdomain.pid qgn 78558 78467 0 17:14 pts/0 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --log-error=localhost.localdomain.err --pid-file=/usr/local/mysql/data/localhost.localdomain.pid qgn 79018 20835 0 17:15 pts/0 00:00:00 grep --color=auto mysql [qgn@localhost mysql]$

开启时遇到下面错误 Starting MySQL./usr/local/mysql/bin/mysqld_safe:行647: /var/log/mariadb/mariadb.log: 没有那个文件或目录 2019-05-22T15:51:02.864835Z mysqld_safe error: log-error set to ‘/var/log/mariadb/mariadb.log’, however file don’t exists. Create writable for user ‘mysql’. /usr/local/mysql/bin/mysqld_safe:行144: /var/log/mariadb/mariadb.log: 没有那个文件或目录 ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid). 解决办法： 创建文件夹 创建文件 sudo mkdir /var/log/mariadb sudo touch /var/log/mariadb/mariadb.log 更改文件权限 sudo chown mysql:mysql mariadb.log sudo chmod 666 mariadb.log

登陆 mysql bin/mysql -uroot -p 输入初始化时记下的密码 进入mysql进行操作则会提示更改密码， 将密码更改为 mysql mysql> set password=password('mysql'); 查看用户以及权限 mysql> use mysql; mysql> select host,user from user; 更改权限表，使 mysql 可以远程连接 mysql> update user set host = '%' where user ='root'; 重新加载权限表 mysql> flush privileges;

[qgn@localhost mysql]$ bin/mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.26 Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. mysql> set password=password('mysql'); Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.01 sec) mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select host,user from user; +-----------+---------------+ | host | user | +-----------+---------------+ | localhost | mysql.session | | localhost | mysql.sys | | localhost | root | +-----------+---------------+ 3 rows in set (0.00 sec) mysql> update user set host = '%' where user ='root'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) mysql> quit; Bye