1.服務(wù)器環(huán)境

CentOS 7.2

2.移除 mariadb

操作之如果有默認(rèn)數(shù)據(jù)庫馬瑞 DB 前先移除 mariadb

yum -y remove mari*

rm -rf /var/lib/mysql/*

3.下載tar包

mysql5.7 的 tar 包：

下載地址：

https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz

4.使用 ftp 工具把 tar 包傳輸?shù)?usr/local/目錄下

推薦工具 Xftp 下載地址

4.1解壓 tar 包

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

4.2更改文件名稱

mv mysql-5.7.28-linux-glibc2.12-x86_64 mysql

5.創(chuàng)建用戶和用戶組并賦予權(quán)限

groupadd mysql

useradd -r -g mysql mysql

chown -R mysql:mysql mysql/

6.安裝和初始化數(shù)據(jù)庫

cd mysql

./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --lc_messages_dir=/usr/local/mysql/share --lc_messages=en_US

如果無錯(cuò)誤繼續(xù),出現(xiàn)如下錯(cuò)誤的

報(bào)錯(cuò)信息：bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

解決辦法:

yum update

yum install -y libaio

**

7.獲取初始登錄密碼

執(zhí)行上一步操作后會(huì)在命令行輸出 root@localhost: gFamcspKm2+u localhost: 后面的這一串便是你首次登陸 mysql 需要的初始密碼

如下圖：

配置 my.cnf

vim /etc/my.cnf

下面的粘貼進(jìn)去

[mysqld]

character_set_server=utf8

init_connect='SET NAMES utf8'

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

socket=/tmp/mysql.sock

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

8.啟動(dòng)服務(wù)

cd /usr/local/mysql/bin/

./mysqld_safe --user=mysql &

9.設(shè)置開機(jī)啟動(dòng)

進(jìn)入 /usr/local/mysql 文件夾

cd /usr/local/mysql/support-files

cp mysql.server /etc/init.d/mysql

10.使用 service mysqld 命令啟動(dòng)/停止服務(wù)

service mysql start/stop/restart

實(shí)在不行，用這個(gè)：

sudo ./support-files/mysql.server start

注意，5.7 版本往上修改密碼：

mysql -uroot -p你的密碼

use mysql

update mysql.user set authentication_string=password('123456') where user='root'

全局使用 mysql

ln -s /usr/local/mysql-5.7.22/bin/mysql /usr/bin

新建用戶遠(yuǎn)程連接 mysql 數(shù)據(jù)庫

grant all on *.* to admin@'%' identified by '123456' with grant option;

flush privileges;

允許任何ip地址(%表示允許任何ip地址)的電腦用admin帳戶和密碼(123456)來訪問這個(gè)mysql server。

注意admin賬戶不一定要存在。

支持 root 用戶允許遠(yuǎn)程連接 mysql 數(shù)據(jù)庫

grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;

flush privileges;

11.異常

11.1解決“ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (111)”

rm -rf /tmp/mysql.sock

cd /usr/local/mysql

sudo ./support-files/mysql.server start

mkdir /var/run/mysqld/

chown -R mysql.mysql /var/run/mysqld/

mysql> use mysql

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

SET PASSWORD = PASSWORD('123456');

Query OK, 0 rows affected, 1 warning (0.00 sec)

啟動(dòng)異常[“ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)”]

解決辦法：mysql 服務(wù)未啟動(dòng),啟動(dòng)就好了.

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

alter user user() identified by "123456";

-[x]服務(wù)器重啟后連接 mysql 出現(xiàn) ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/data/mydata/mysql.sock’ (111)類似

[mysqld]

character_set_server=utf8

init_connect='SET NAMES utf8'

basedir=/usr/local/mysql-5.7.22

datadir=/usr/local/mysql-5.7.22/data

socket=/tmp/mysql.sock

log-error=/var/log/mysqld.log

pid-file=/data/mydata/mysqld.pid

bind-address=0.0.0.0

socket = /data/mydata/mysql.sock

[client]

socket = /data/mydata/mysql.sock

把 mysqld.pid 的文件換個(gè)其他文件夾就行了

11.2 異常

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

在初始化安裝時(shí)增加

--explicit_defaults_for_timestamp=1

————————————————

版權(quán)聲明：本文為CSDN博主「公眾號(hào)：Java Pro」的原創(chuàng)文章，遵循CC 4.0 BY-SA版權(quán)協(xié)議，轉(zhuǎn)載請(qǐng)附上原文出處鏈接及本聲明。

原文鏈接：https://blog.csdn.net/fine_cui/article/details/111397398