一、在官網下載mysql安裝包
下圖是mysql安裝包的介紹
二、安裝軟件包
1、安裝依賴
#?yum?-y?install?perl-Date-Dumper?perl-JSON?perl-Time-HiRes
2、解壓mysql安裝包
#?tar?-xvf?mysql-5.7.24.tar???????????????//解壓mysql包
3、卸載老版本的包
[root@localhost?~]#?rm?-rf?/etc/my.cnf
4、刪除數據
[root@localhost?~]#?rm?-rf?/var/lib/mysql/*
5、卸載軟件包(沒有會顯示未安裝軟件包)
[root@localhost?~]#?rpm?-e?--nodeps?mariadb-server?mariadb
警告:/var/log/mariadb/mariadb.log 已另存為/var/log/mariadb/mariadb.log.rpmsave
#yum?-y?remove?mariadb-libs.x86_64?1:5.5.52-1.el7
6、yum源安裝
#yum?-y?install?mysql-community-client?mysql-community-common?mysql-community-devel?mysql-community-embedded?mysql-community-embedded-compat?mysql-community-embedded-devel??mysql-community-libs?mysql-community-libs-compat?mysql-community-minimal-debuginfo?mysql-community-server?mysql-community-test
或者
#yum?-y?install?mysql-community-*.rpm
7、查看安裝了的mysql有關安裝包
#?rpm?-qa?|?grep?-y?mysql
8、啟動服務
#?systemctl?start?mysqld #?systemctl?enable?mysqld?//設置開機自啟 #?systemctl?status?mysqld [root@proxy?mysql]#?ss?-antulp?|?grep?mysqld?//查看服務啟動端口 #?ps?aux?|?grep?mysqld?//查進程
三、連接數據庫
1、查隨機生成的root密碼
#?grep?password?/var/log/mysqld.log #??grep?'temporary?password'?/var/log/mysqld.log?//隨機生成的管理密碼
初始密碼登陸mysql:
(!!!用隨機生成密碼登陸必須馬上修改密碼管理,不然會報錯)
2、客戶端命令mysql連接數據庫
#?mysql?-hlocalhost?-uroot?-p'pIhMu,i2OS#,'?//用初始密碼登錄 mysql>?h?//登錄成功后,查可用的快捷鍵
四、修改密碼
1、只能先修密碼
mysql>?alter?user?root@"localhost"?identified?by?"123qqq...A";
2、可以修改密碼限制長度
mysql>?show?variables?like?"%password%";??????????????//查詢密碼有關的變量 mysql>?set?global?validate_password_policy=0;???????//只驗證長度 mysql>?set?global?validate_password_length=6;??????//修改密碼長度為6位 mysql>?alter?user?root@"localhost"?identified?by?"123456";?????????????//修改root密碼為123456
推薦教程:mysql教程
? 版權聲明
文章版權歸作者所有,未經允許請勿轉載。
THE END
喜歡就支持一下吧
相關推薦