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

2024-07-24 13:15:26

字體：大中小

來源：轉載

供稿：網友

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

官方參考手冊

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

mysql5.7,mysql5.7.21,密碼

2.配置mysql的環境變量，創建MYSQL_HOME，并且在Path添加上%MYSQL_HOME%/bin;

mysql5.7,mysql5.7.21,密碼

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文件

mysql5.7,mysql5.7.21,密碼

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

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

mysql5.7,mysql5.7.21,密碼

6.啟動MySQL服務，命令：net start mysql

mysql5.7,mysql5.7.21,密碼

7.設置密碼 mysqladmin -u root password 密碼

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

mysql5.7,mysql5.7.21,密碼

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

mysql5.7,mysql5.7.21,密碼

9.輸入命令show databases; 查看數據表

mysql5.7,mysql5.7.21,密碼

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.

10.輸入 /q; 退出MySQL

11.關閉MySQL服務,命令：net stop mysql

mysql5.7,mysql5.7.21,密碼