解析mysql的安裝與使用（收藏）

#1?先去https://repo.mysql.com/?下載最新的repo源 $?wget?https://repo.mysql.com/mysql80-community-release-sles12-2.noarch.rpm  #2?安裝mysql80-community-release-sles12-2.noarch.rpm包 $?sudo?rpm?-ivh?mysql80-community-release-sles12-2.noarch.rpm  #假如報錯提示沖突的話，?先查詢下是不是已經安裝過了 $?rpm?-qa?|?grep?mysql #有的話干掉他??--nodeps?強制卸載 $?rpm?-e?xxx?(--nodeps)?#xxx為沖突的rpm名稱

$?sudo?yum?install?mysql-community-server?#安裝 $?service?mysqld?start?#啟動 $?sudo?service?mysqld?status?#檢查MySQL服務狀態  $?sudo?grep?'temporary?password'?/var/log/mysqld.log?#查看初始密碼   $?mysqld?-V??#查看版本

$?mysql?-u?root?#需要輸入初始密碼  #修改root登錄密碼,注意要切換到mysql數據庫，使用use?mysql $?ALTER?USER?'root'@'localhost'?IDENTIFIED?BY?'密碼';

#?需要更改權限才能實現遠程連接MYSQL數據庫??  $?mysql?-h?localhost?-uroot?-p?#輸入密碼登錄 mysql>?use?mysql;???#此DB存放MySQL的各種配置信息 mysql>?select?host,user?from?user;?#查看用戶的權限情況 mysql>?select?host,?user,?password?from?user; mysql>?update?user?set?host?=?'%'?where?user?='root'; #?%表示是所有的外部機器，如果指定某一臺機，就將%改為相應的機器名；‘root’則是指要使用的用戶名  mysql>?flush?privileges;?#運行此句才生效，或者重啟MySQL

mysql?-u?root?-p??#輸入密碼登錄  #yourpassword?是你的數據庫賬戶密碼，root和host也是 ALTER?USER?'root'@'%'?IDENTIFIED?WITH?mysql_native_password?BY?'123456';  #大意是8.0.4開始mysql引入一個caching_sha2_password模塊作為默認身份驗證插件，數據庫連接時驗證身份的工作方式(handshake?process)會與以往不同。

mysql?-u?root?-p mysql>?use?mysql; mysql>?select?user,host?from?user;  +------------------+-----------+ |?user?????????????|?host??????| +------------------+-----------+ |?root?????????????|?%?????????| |?admin????????????|?localhost?| |?mysql.infoschema?|?localhost?| |?mysql.session????|?localhost?| |?mysql.sys????????|?localhost?| |?zhangj???????????|?localhost?| +------------------+-----------+  #注意root，host是'%',你可能執行的是: ALTER?USER?'root'@'localhost'?IDENTIFIED?WITH?mysql_native_password?BY?'123'; #?改成: ALTER?USER?'root'@'%'?IDENTIFIED?WITH?mysql_native_password?BY?'123';