1狗准、先檢查系統(tǒng)是否裝有mysql
[root@localhost ~]# rpm -qa | grep mysql
[root@localhost ~]#(返回空值哥蔚,說明沒有安裝)
2、下載mysql的repo源
[root@localhost ~]# wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
3鸯绿、安裝mysql-community-release-el7-5.noarch.rpm包
[root@localhost ~]# sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
安裝這個包后锉罐,會獲得兩個mysql的yum repo源:
/etc/yum.repos.d/mysql-community.repo,
/etc/yum.repos.d/mysql-community-source.repo病涨。
可以輸入命令查看:
[root@localhost ~]# cd /etc/yum.repos.d/
[root@localhost yum.repos.d]# ls
mysql-community-source.repo? mysql-community.repo
4、安裝mysql
[root@localhost yum.repos.d]# sudo yum install mysql-server
Is this ok [y/d/N]: y(遇到選項輸入y)
安裝完成后璧坟,沒有密碼既穆,需要重置密碼
安裝后再次查看mysql
[root@localhost yum.repos.d]# rpm -qa | grep mysql
mysql-community-client-5.6.41-2.el7.x86_64
mysql-community-common-5.6.41-2.el7.x86_64
mysql-community-release-el7-5.noarch
mysql-community-libs-5.6.41-2.el7.x86_64
mysql-community-server-5.6.41-2.el7.x86_64
5、重置密碼
重置密碼前雀鹃,首先要登錄
[root@localhost yum.repos.d]# mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
出現(xiàn)此錯誤:原因是/var/lib/mysql的訪問權限問題幻工。
下面的命令把/var/lib/mysql的擁有者改為當前用戶:
[root@localhost /]# sudo chown -R openscanner:openscanner /var/lib/mysql
chown: 無效的用戶: "openscanner:openscanner"
更換命令,并用 ll 查看目錄權限列表
[root@localhost /]# chown root /var/lib/mysql/
重啟服務
[root@localhost /]# service mysqld restart
登錄重置密碼
[root@localhost /]# mysql -u root
mysql> use mysql;
mysql> update user set password=password('root') where user='root';
mysql> exit;
重啟mysql服務器才生效:
[root@localhost /]# service mysqld restart
加入以下命令行黎茎,為root添加遠程連接的能力囊颅。鏈接密碼為 root
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";
6、開放3306端口號(centos7)
[root@localhost /]# firewall-cmd --zone=public --add-port=3306/tcp --permanent
[root@localhost /]# firewall-cmd --reload