Mysql 8.0.16 Win10 zip version installation configuration graphic text tutorial
This article shares the installation and configuration tutorials of mysql 8.0.16 Win10 zip version for your reference. The details are as follows
First, go to mysql's official website to download the latest version of mysql.
1. Select community as shown in the figure
two。 Click on the icon download
3. Decompress it to the specified disk
Example: F:\ mysql8.0.16
4. Configure environment variables
MYSQL_HOME:F:\ mysql8.0.16`
Add;% MYSQL_HOME%\ bin after path
5. Add File my.ini File
6. Put the following code in the my.ini file
Mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set 3306 port port = 330mm set mysql installation directory basedir=F:\ mysql8.0.16# set mysql database data storage directory datadir=F:\ mysql8.0.16\ data# allow maximum number of connections the character set used by the max_connections=200# server defaults to 8-bit coded latin1 character set character-set-server=utf8# creation The default storage engine default-storage-engine=INNODB that will be used when creating new tables
Special note: basedir and datadir, please modify them according to your actual installation directory
7. To open cmd.exe, you must run as an administrator
7.1 initialize the database
Mysqld-initialize-user=mysql-console
Remember the assigned password:
7.2 installation Services
Mysqld-install MySQL
7.3 start the service
Net start MySQL
If the prompt service starts, everything will be fine if it succeeds.
The first time use mysql will prompt you to change your password.
Alter user 'root'@'localhost' identified by' root' (new password)
After the modification is successful, you can exit and log in to mysql again.
The following other commands may be used
Out of Service
Net stop MySQL
Delete a service
Sc delete MySQL (executable if a problem occurs)
Uninstall mysql
Mysqld-remove
The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.
