卸載寶塔面板:
1.wget http://download.bt.cn/install/bt-uninstall.sh
2.sh bt-uninstall.sh
命令:
cat /proc/version
Linux version 3.10.0-862.el7.x86_64 (builder@kbuilder.dev.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-28) (GCC) ) #1 SMP Fri Apr 20 16:44:24 UTC 2018
uname -a
Linux centos7-64-1 3.10.0-862.el7.x86_64 #1 SMP Fri Apr 20 16:44:24 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
uname -r
3.10.0-862.el7.x86_64
getconf LONG_BIT
64
cat /etc/redhat-release
CentOS Linux release 7.5.1804 (Core)
rpm -qa | grep mariadb
mariadb-libs-5.5.60-1.el7_5.x86_64
rpm -qa | grep mysql 無(wú)結(jié)果
正式進(jìn)入安裝 mysql 步驟
1.wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
目錄多個(gè)mysql-community-release-el7-5.noarch.rpm
執(zhí)行rpm -ivh mysql-community-release-el7-5.noarch.rpm
2.cd /etc/yum.repos.d/
多兩個(gè)文件 mysql-community.repo和mysql-community-source.repo
3.安裝 yum install mysql-server
4.啟動(dòng) service mysqld start
5.查看狀態(tài) systemctl status mysqld
或者 service mysqld status
顯示:Active: active (running) since 一 2019-07-22 09:33:13 CST; 1h 9min ago
卸載安裝的 mysql
在下載官網(wǎng)的mysql57-community-release-el7-10.noarch.rpm,執(zhí)行rpm -ivh的時(shí)候報(bào)依賴檢測(cè)失敗:
mysql-community-release 與 mysql57-community-release-el7-10.noarch 沖突察绷。
命令查看mysql安裝情況:rpm -qa | grep -i mysql
結(jié)果:
mysql-community-common-5.7.27-1.el7.x86_64
mysql-community-server-5.7.27-1.el7.x86_64
mysql-community-libs-5.7.27-1.el7.x86_64
mysql-community-release-el7-5.noarch
mysql-community-libs-compat-5.7.27-1.el7.x86_64
mysql-community-client-5.7.27-1.el7.x86_64
停止 mysql: service mysqld stop
刪除命令:rpm -e 文件名
再find / -name mysql
刪除查找到的結(jié)果牺丙。
再刪除配置文件 rm -rf /etc/my.cnf
mysql 初始密碼的設(shè)置:
先查看臨時(shí)密碼悠垛,使用命令 vi /var/log/mysqld.log 锈嫩,查找到A temporary password is generated for root@localhost: 8dR!2VlJTyaq胁附。
mysql -u root -p 得到結(jié)果 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
猜測(cè)應(yīng)該是沒(méi)有開(kāi)啟 mysql 的原因榴啸。啟動(dòng) mysql 后,使用臨時(shí)密碼登錄成功膳凝。
用該密碼登錄到服務(wù)端后碑隆,必須馬上修改密碼,不然會(huì)報(bào)如下錯(cuò)誤:
mysql>select@@log_error;
ERROR1820(HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql>
修改密碼
ALTER USER 'root'@'localhost' IDENTIFIED BY '***';
密碼的要求是大寫加小寫加數(shù)字且大于8位蹬音。
這樣密碼就修改成功了上煤。
授權(quán)其他機(jī)器登錄
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '***' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql>
然而其他機(jī)器登錄還是報(bào)錯(cuò):2003 - Can't connect to MySQL server on '192.168.1.79' (61 "Connection refused")
原因是因?yàn)榉阑饓](méi)有開(kāi)啟。
firewall-cmd --state
firewall-cmd --list-all
firewall-cmd --add-port=3306/tcp --permanent
firewall-cmd --reload