請(qǐng)小伙伴們 ???????? 自行選擇linux 系統(tǒng)

一、ubuntu 系統(tǒng)

1)命令： apt-get -y install mysql-server-5.7

2) 修改/etc/mysql/mysql.conf.d/mysqld.cnf，注釋127.0.0.1

3) 啟動(dòng)mysql服務(wù),運(yùn)行service mysql start

4) 啟動(dòng)服務(wù)后直接用mysql命令進(jìn)入mysql client，然后運(yùn)行一下命令修改密碼

mysql -uroot -p密碼

use mysql;

update user set plugin="mysql_native_password" where user="root";

update user set authentication_string=password("123456") where user = "root";

update user set host="%" where user="root" and host="localhost";

Flush privileges;

exit;

二、centos 版本

1） 下載 mysql

wget 'https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm'

sudo rpm -Uvh mysql57-community-release-el7-11.noarch.rpm

sudo yum -y install mysql-community-server

2） 啟動(dòng)服務(wù)

service mysqld? start

3） 在log 中找到初始密碼后重置

在/var/log/mysqld.log中找到root用戶登錄mysql的密碼，grep "password" /var/log/mysqld.log

示例如下：

[root@ip-10-0-2-150 kyligence_cloud]# grep "password" /var/log/mysqld.log

2019-11-06T05:54:28.748212Z 1 [Note] A temporary password is generated for root@localhost: aUAwwgRhP2)p

4) 重新登錄mysql 并重置密碼

登錄mysql:

mysql? -P3306? -uroot? -p

修改密碼

set global validate_password_policy=0;

set global validate_password_length=1;

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

5）退出后重新登錄mysql一下，輸入一下命令即可以使得當(dāng)前機(jī)器ip可以登錄mysql

登錄mysql:

mysql? -P3306? -uroot? -p123456

use mysql;

update user set host="%" where user="root" and host="localhost";

Flush privileges;