MySQL 5.7.21 installation and password configuration tutorial

MySQL5.7.21 installation and password setting tutorial, as follows

Official reference manual

1. Unzip the MySQL 5.7.20 installation package, such as X:\MySQL\mysql-5.7.21-winx64. (There is no data and my.ini)

2. Configure mysql environment variables, create MYSQL_HOME, and add %MYSQL_HOME%\bin to Path;

3. Configure my.ini. And put my.ini in the bin directory (1. If it is placed in the mysql-5.7.21-winx64 directory, the MYSQL service may not be started when executing net start mysql below, 2. data will not be automatically generated)

[client]
 
default-character-set=utf8
 [mysqld]
#Unzip directory such as: D:\MySQL\mysql-5.7.21-winx64
 basedir = %MYSQL_HOME% 
#Unzip directory such as: D:\MySQL\mysql-5.7.21-winx64\data
 datadir = %MYSQL_HOME%\data 
 port = 3306 
 default-character-set=utf8

4. Enter the command line as an administrator (you can find it by searching and typing cmd in Cortana), and enter the X:\MySQL\mysql-5.7.21-winx64\bin directory and enter the command: mysqld --initialize-insecure (generate a root user without a password). Then the data file will appear in the mysql-5.7.20-winx64 directory.

5. Enter mysqld --install again. If Service successfully installed appears, registration is successful.

Note: If this operation reports an error message "Install/Remove of the Service Denied!", it is recommended that you enter the command prompt as an administrator.

6. Start the MySQL service, command: net start mysql

7. Set the password mysqladmin -u root password password

8. Change the password as follows: Then enter mysql -uroot -p Since you have logged in before, just enter the password you just set (the first time you log in as root, you can enter directly without a password) MYSQL>

Then enter: update mysql.user set authentication_string=password('the password you want to enter') where user='root' and Host ='localhost'; Then enter: flush privileges;

9. Enter the command show databases; to view the data table

Commonly used MySQL commands are as follows

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. Enter \q; to exit MySQL

11. Shut down the MySQL service, command: net stop mysql

Wonderful topic sharing: Installation tutorials for different versions of MySQL Installation tutorials for MySQL 5.7 versions Installation tutorials for MySQL 5.6 versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.