之前記錄過一次安裝,今天新弄了個服務(wù)器結(jié)果按之前的教程又出問題了,僅僅可以參考了,最好還是去MYSQL官網(wǎng)按官方文檔步驟操作
Linux7 安裝 MYSQL
還有一篇設(shè)置root密碼的,現(xiàn)在也有問題了最好還是安裝下面的教程操作
Linux 安裝 MYSQL 5.7 設(shè)置root密碼
官網(wǎng)教程
查看章節(jié)
2.5.1 Installing MySQL on Linux Using the MySQL Yum Repository
可以安裝這個官方文檔去做,這是比較穩(wěn)妥的
首先下載一個很小的 ".rpm"文件
我下載的是 mysql57-community-release-el7-11.noarch.rpm
我上傳在了root文件夾下面,當(dāng)前就在root文件夾下操作的
1.Adding the MySQL Yum Repository
然后按教程上第一步是執(zhí)行命令
sudo yum localinstall mysql57-community-release-el6-{version-number}.noarch.rpm
我這自然是
sudo yum localinstall mysql57-community-release-el7-11.noarch.rpm
2.Selecting a Release Series
yum repolist all | grep mysql
3.Installing MySQL
sudo yum install mysql-community-server
終端輸出:
[root@VM_0_6_centos ~]# sudo yum install mysql-community-server
Loaded plugins: fastestmirror, langpacks
mysql-connectors-community | 2.5 kB 00:00:00
mysql-tools-community | 2.5 kB 00:00:00
mysql57-community | 2.5 kB 00:00:00
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.7.20-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.7.20-1.el7 for package: mysql-community-server-5.7.20-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.20-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.20-1.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.20-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.7.20-1.el7 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:5.7.20-1.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
==============================================================================================================================================================================
Package Arch Version Repository Size
==============================================================================================================================================================================
Installing:
mysql-community-server x86_64 5.7.20-1.el7 mysql57-community 164 M
Installing for dependencies:
mysql-community-client x86_64 5.7.20-1.el7 mysql57-community 24 M
mysql-community-common x86_64 5.7.20-1.el7 mysql57-community 272 k
mysql-community-libs x86_64 5.7.20-1.el7 mysql57-community 2.1 M
Transaction Summary
==============================================================================================================================================================================
Install 1 Package (+3 Dependent packages)
Total download size: 190 M
Installed size: 857 M
Is this ok [y/d/N]: y
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
(1/2): mysql-community-server-5.7.20-1.el7.x86_64.rpm | 164 MB 00:01:46
(2/2): mysql-community-client-5.7.20-1.el7.x86_64.rpm | 24 MB 00:06:31
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 490 kB/s | 188 MB 00:06:31
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : mysql-community-common-5.7.20-1.el7.x86_64 1/4
Installing : mysql-community-libs-5.7.20-1.el7.x86_64 2/4
Installing : mysql-community-client-5.7.20-1.el7.x86_64 3/4
Installing : mysql-community-server-5.7.20-1.el7.x86_64 4/4
Verifying : mysql-community-libs-5.7.20-1.el7.x86_64 1/4
Verifying : mysql-community-common-5.7.20-1.el7.x86_64 2/4
Verifying : mysql-community-client-5.7.20-1.el7.x86_64 3/4
Verifying : mysql-community-server-5.7.20-1.el7.x86_64 4/4
Installed:
mysql-community-server.x86_64 0:5.7.20-1.el7
Dependency Installed:
mysql-community-client.x86_64 0:5.7.20-1.el7 mysql-community-common.x86_64 0:5.7.20-1.el7 mysql-community-libs.x86_64 0:5.7.20-1.el7
Complete!
Starting the MySQL Server 啟動
sudo service mysqld start
查看mysql狀態(tài)
sudo service mysqld status
成功輸出:
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2017-11-15 11:39:47 CST; 57s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 32709 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
Process: 32620 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 32714 (mysqld)
CGroup: /system.slice/mysqld.service
└─32714 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
Nov 15 11:39:18 VM_0_6_centos systemd[1]: Starting MySQL Server...
Nov 15 11:39:47 VM_0_6_centos systemd[1]: Started MySQL Server.
修改初始密碼
首先查看初始密碼
初始密碼在 /var/log/mysqld.log log文件中
sudo grep 'temporary password' /var/log/mysqld.log
終端輸出了現(xiàn)在的初始密碼:
2017-11-15T03:39:29.784737Z 1 [Note] A temporary password is generated for root@localhost: nee6r9?.bZDg
后面的 "nee6r9?.bZDg"就是現(xiàn)在的初始密碼
修改root密碼
登錄
mysql -uroot -p
輸入剛才的密碼(復(fù)制粘貼即可)
修改密碼
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
這里注意密碼要求:大寫字母 小寫字母 數(shù)字 特殊符號 構(gòu)成哦
刷新系統(tǒng)列表
FLUSH PRIVILEGES;
退出
quit;
重啟mysql
sudo service mysqld restart
可以用新密碼試試了
設(shè)置MySQL遠程訪問
需求:需要在本地遠程登錄MySQL,采用的還是root用戶+密碼訪問
服務(wù)器確保3306端口是可以訪問的
配置服務(wù)器的安全組,入站規(guī)則中增加一條股則
0.0.0/0 TCP:3306 允許
將安全組配置在對應(yīng)服務(wù)器上.
mysql 配置更改
修改配置文件
編輯 /etc/my.cnf
vim /etc/my.cnf
增加一行
bind-address = 0.0.0.0
我這是這樣的:
[mysqld]
bind-address = 0.0.0.0
修改root用戶
登錄mysql
mysql -uroot -p
輸入密碼
mysql> use mysql;
mysql> select user,host from user;
+---------------+-----------+
| user | host |
+---------------+-----------+
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+---------------+-----------+
將root用戶host更新成 %:
update user set host = '%' where user = 'root';
再查詢看看:
mysql> select user,host from user;
+---------------+-----------+
| user | host |
+---------------+-----------+
| root | % |
| mysql.session | localhost |
| mysql.sys | localhost |
+---------------+-----------+
3 rows in set (0.00 sec)
重啟mysql
sudo service mysqld restart
搞定
