1. Just unzip is no my. Ini configuration file, the need to create a document, change the suffix,
2. Provide content here (note that copy and paste to remove content) :
[mysql]
# set the mysql client default character set
Default - character - set=utf8
[mysqld]
# set port 3306
Port=3306
# set the mysql installation directory, according to your installation to write
Basedir=D: \ mysql - 8.0.15 - winx64
# set up the mysql database data storage directory, I was manually create D:/mysql/mysql - 8.0.15 - winx64 both directories, initialization data automatically create
Datadir=D:/MYSQL/MYSQL - 8.0.15 - winx64 \ data
# to allow maximum number of connections
Max_connections=200
# server character set the default use 8 bits for coding the latin1 character set
Character - set - server=utf8
# to create a new table will use the default storage engine
Default - storage - engine=INNODB
3. Then configure the system environment variable, I'm the mysql directly to the full path name added to the bin directory path in the
4. The official start of the installation! As an administrator to open the CMD, enter
Mysqll - install
According to the Service successfully installed.
Installation is successful!
5. At this time to open the database service
The right-click my computer, management, service, find the mysql service, right-click start
6. Enter the mysql - the initialize - the console, initialize database, if there is a popup window lack anything, is the lack of operation environment of c + + 2015, search online download good
Show [System] [MY - 013169] [Server] D: \ mysql - 8.0.15 - winx64 \ bin \ mysqld exe (mysqld 8.0.15) initializing of Server in progress as the process of 6376
2019-10-14 T07: abide. 769174 z 0 [Warning] [MY - 013242] (Server) - character - set - Server: 'utf8 is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Both Please consider using UTF8MB4 in order to be unambiguous.
2019-10-14 T07: usurer. 412167 z 5 [Note] [MY - 010454] [Server] A temporary password generated for root @ localhost: Lu. LJLo8Jgef
The 2019-10-14 T07:25:42. 894103 z 0 [System] [MY - 013170] [Server] D: \ mysql - 8.0.15 - winx64 \ bin \ mysqld exe (mysqld 8.0.15) initializing of Server has completed
Pay attention to A temporary password generated for root @ localhost: is the database password after initialization, behind the space, pay attention to the case
7. Then log in mysql -u root -p
Password: you just said
After the success of the 8. Log in to must be initialized password: the alter user 'root' @ 'localhost' identfied with mysql_native_ password by 'enter your new password;
Query OK, 0 rows affected (1.90 SEC) modified successfully!
9. The installation was successful!!!!!!
CodePudding user response:
Just installed mysql - 8.0.17 - winx64 yesterday, no my. Inihttps://blog.csdn.net/sinat_28984567/article/details/102535923
CodePudding user response:
The