MySQL5.7.21安裝與密碼設置教程，具體如下
官方參考手冊
1.解壓MySQL 5.7.20安裝包，如X:/MySQL/mysql-5.7.21-winx64。（是沒有data和my.ini的）
2.配置mysql的環境變量，創建MYSQL_HOME，并且在Path添加上%MYSQL_HOME%/bin;
3，配置my.ini. 并把my.ini放到bin目錄下（1.如果放在mysql-5.7.21-winx64 目錄下，在下面執行net start mysql時可能無法啟動MYSQL服務、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. 以管理員身份進入命令行（可在小娜搜索輸入cmd找到），并進入X:/MySQL/mysql-5.7.21-winx64/bin目錄下輸入命令：mysqld --initialize-insecure (生成無密碼的root用戶) 后，在mysql-5.7.20-winx64 目錄下就會出現data文件
5.再輸入mysqld --install，如果出現Service successfully installed 說明注冊成功了。
注意：如果此操作報錯Install/Remove of the Service Denied!，建議使用管理員身份進入命令提示符
6.啟動MySQL服務，命令：net start mysql
7.設置密碼 mysqladmin -u root password 密碼
8.修改密碼方法如下 ：接著輸入mysql -uroot -p 由于之前登陸過，直接輸入剛才設置密碼（登錄root第一次是免密碼的直接回車進入到） MYSQL>
接著輸入：update mysql.user set authentication_string=password('你想輸入的密碼') where user='root' and Host ='localhost'; 然后接著再輸入： flush privileges;
9.輸入命令show databases; 查看數據表
MySQL常用的命令如下
| List of all MySQL commands: Note that all text commands must be first on line and end with ';'（要以“;”結尾） ? (/?) 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. |
