linux 安裝mysql
基于CentOS7.4;mysql5.7
-
下載mysql源安裝包
wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
-
安裝mysql源
yum localinstall mysql57-community-release-el7-11.noarch.rpm
-
檢查mysql源是否安裝成功
yum repolist enabled | grep "mysql.*-community.*"
-
安裝MySQL
yum install mysql-community-server
- 1.啟動(dòng)MySQL服務(wù)
systemctl start mysqld
- 2.重啟MySQL服務(wù)
systemctl restart mysqld
- 3.查看MySQL的啟動(dòng)狀態(tài)
systemctl status mysqld
- 4.開機(jī)啟動(dòng)
systemctl enable mysqld systemctl daemon-reload
- 5.退出mysql
quit
- 1.啟動(dòng)MySQL服務(wù)
-
mysql安裝完成之后溯泣,在/var/log/mysqld.log文件中給root生成了一個(gè)默認(rèn)密碼拭宁。通過下面的方式找到root默認(rèn)密碼
grep 'temporary password' /var/log/mysqld.log
-
使用默認(rèn)密碼登錄
mysql -uroot -p
-
修改root默認(rèn)密碼(必須數(shù)字大小寫)
ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxxx';
-
默認(rèn)root帳戶只允許在本地登錄,如果要在其它機(jī)器上連接mysql,必須修改root允許遠(yuǎn)程連接桩引,或者添加一個(gè)允許遠(yuǎn)程連接的帳戶,為了安全起見诱担,我添加一個(gè)新的帳戶
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
-
配置默認(rèn)編碼為utf8,修改/etc/my.cnf配置文件鸡号,在[mysqld]下添加編碼配置,如下所示:
vi /etc/my.cnf [mysqld] character_set_server=utf8 init_connect='SET NAMES utf8' 重啟mysql服務(wù) systemctl restart mysqld
-
重啟mysql服務(wù)
systemctl restart mysqld
使用Navicat輸入ip在3306端口使用新建的遠(yuǎn)程用戶即可連接遠(yuǎn)程數(shù)據(jù)庫