operation steps:

1, install MySQL database

1, Download MySQL-5.6.17-winx64.zip file.

2, decompressed to the specified directory, this example is D:mysql-5.6.17-winx64.

3, modify the configuration file, the name of the my-default.ini is changed to: my.ini, the parameter configuration inside the file: the

 [mysqld] of the mysql. 6.17-winx64/data

note: the path is a backslash, it can also be changed to two positive slashes, plus double quotes,

examples:

 datadir= "D: mysql-5.6.17-winx64data" MySQL port port=3306 MySQL port. CT_TRANS_TABLES

4, install MySQL service

to find cmd.exe, click right to run as administrator (Win 7 under strict division of privileges, must be administrator identity)

Mysqld --install -manual [service name]

-install MySQL --defaults-file= "D: mysql-5.6.17-winx64my.ini" D: mysql-5.6.17-winx64my.ini. Take -D as an option to deal with.

MySQL MySQL acquiescence searches for c:my.ini and c:windowsmy.ini, my.ini or my.cnf in the installation directory.

5, MySQL services start and stop

, enter MySQL bin directory under doc command (D: mysql-5.6.17-winx64bin>),

.

two, root password modification and login

1, login

login MySQL database in the command window.

note: the initial password of the MySQL decompress version is empty for the administrator root, so it will be logged into the MySQL database directly once again.

remote login (extension) configuration

 MySQL -h 192.168.80.109 -u root? P MySQL -h. If you enter the password, you can write the password directly after -p, so you don't need to enter the password anymore. 

2, modify the root password

to start MySQL service, input the command:

use MySQL

use MySQL data source.

flush privileges,

mysql is new to set a user or change the password after the need to use flush privileges to refresh MySQL's system permissions related tables, otherwise there will be a denial of access, and another way is to restart the MySQL server to make the new setup effective.

note:

may be the following problem:

ERROR 1044 (42000): Access denied.

''@'localhost' can be seen.

method one:

1. closed mysql

# service.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 MySQL -u root Mysql> UPDATE user SET Password=PASSWORD ('newpassword') where USER='root'; mysql> FLUSH PRIVILEGES; Accordingly 

2.

2.

 mysqld_safe --skip-grant-table 

fewer mysqld_safe --skip-grant-table veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins potatoes veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins stationery veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins toilet veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins veins this is a

screen. Demo from.....

3. opens a new terminal to

 MySQL -u root MySQL mysql> 0000 "> three, uninstall the installed MySQL

" can be viewed through the Windows service manager. "Start" -> "run", enter "services.msc", enter. The service manager of Windows is popped up, and then the service item named "MySQL" is visible.

enters the D: mysql-5.6.17-winx64bin> under the doc command; input "mysqld -remove" or "SC delete MySQL" to perform the uninstall service.

summary of

above is a small edition of the MySQL green decompression edition installation and configuration operation steps, I hope to help you, if you have any questions please give me a message, the small editor will respond to you in time. Thank you for your support for the script home website.

This paper fixed link:http://www.script-home.com/mysql-green-decompression-edition-installation-and-configuration-operation-steps.html | Script Home | +Copy Link

Article reprint please specify:MySQL green decompression edition installation and configuration operation steps | Script Home

You may also be interested in these articles!