MySQL5.7.21安裝與密碼圖文配置教程

更新時間：2018年02月05日 13:37:05 作者：21_睶

這篇文章主要為大家詳細(xì)介紹了MySQL5.7.21安裝與密碼圖文配置教程，具有一定的參考價值，感興趣的小伙伴們可以參考一下

MySQL5.7.21安裝與密碼設(shè)置教程，具體如下

官方參考手冊

1.解壓MySQL 5.7.20安裝包，如X:\MySQL\mysql-5.7.21-winx64。（是沒有data和my.ini的）

2.配置mysql的環(huán)境變量，創(chuàng)建MYSQL_HOME，并且在Path添加上%MYSQL_HOME%\bin;

3，配置my.ini. 并把my.ini放到bin目錄下（1.如果放在mysql-5.7.21-winx64 目錄下，在下面執(zhí)行net start mysql時可能無法啟動MYSQL服務(wù)、2.不會自動生成data）

[client]
 
default-character-set=utf8
 [mysqld]
#解壓目錄 如：D:\MySQL\mysql-5.7.21-winx64
 basedir = %MYSQL_HOME% 
#解壓目錄 如：D:\MySQL\mysql-5.7.21-winx64\data
 datadir = %MYSQL_HOME%\data 
 port = 3306 
 default-character-set=utf8

4. 以管理員身份進(jìn)入命令行（可在小娜搜索輸入cmd找到），并進(jìn)入X:\MySQL\mysql-5.7.21-winx64\bin目錄下輸入命令：mysqld --initialize-insecure (生成無密碼的root用戶) 后，在mysql-5.7.20-winx64 目錄下就會出現(xiàn)data文件

5.再輸入mysqld --install，如果出現(xiàn)Service successfully installed 說明注冊成功了。

注意：如果此操作報錯Install/Remove of the Service Denied!，建議使用管理員身份進(jìn)入命令提示符

6.啟動MySQL服務(wù)，命令：net start mysql

7.設(shè)置密碼 mysqladmin -u root password 密碼

8.修改密碼方法如下：接著輸入mysql -uroot -p 由于之前登陸過，直接輸入剛才設(shè)置密碼（登錄root第一次是免密碼的直接回車進(jìn)入到） MYSQL>

接著輸入：update mysql.user set authentication_string=password('你想輸入的密碼') where user='root' and Host ='localhost'; 然后接著再輸入： flush privileges;

9.輸入命令show databases; 查看數(shù)據(jù)表

MySQL常用的命令如下

List of all MySQL commands: 
Note that all text commands must be first on line and end with ';'（要以“;”結(jié)尾） 
?  (\?) Synonym for `help'. 
clear (\c) Clear the current input statement. 
connect (\r) Reconnect to the server. Optional arguments are db and host. 
delimiter (\d) Set statement delimiter. 
ego (\G) Send command to mysql server, display result vertically. 
exit (\q) Exit mysql. Same as quit. 
go (\g) Send command to mysql server. 
help (\h) Display this help. 
notee (\t) Don't write into outfile. 
print (\p) Print current command. 
prompt (\R) Change your mysql prompt. 


quit (\q) Quit mysql.

rehash (\#) Rebuild completion hash. 
source (\.) Execute an SQL script file. Takes a file name as an argument. 
status (\s) Get status information from the server. 
tee (\T) Set outfile [to_outfile]. Append everything into given outfile. 
use (\u) Use another database. Takes database name as argument. 
charset (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets. 
warnings (\W) Show warnings after every statement. 
nowarning (\w) Don't show warnings after every statement. 
resetconnection(\x) Clean session context.

10.輸入 \q; 退出MySQL

11.關(guān)閉MySQL服務(wù),命令：net stop mysql