MySQL uninstall and compression version of the installation

Due to the help of other project groups, in order to develop a convenient local database, found that the SQL script is not executed by the colleague. Based on the error message, the discovery is a version issue. My machine is mysql5.5, and my colleague's library is 5.7.

So, just reload a 5.7.

Unloading

After uninstalling MySQL in the Control Panel-Uninstall or change program, manually remove the MySQL installation directory.

Then cmd input regedit, open the Registry Editor, under HKEY_LOCAL_MACHINE under System ControlSet001 and ControlSet002 under the service of the MySQL directory all removed, it is possible. If I do not delete the registry, I have tried to reload the MSI card at the end has not been successful.

mysql5.7 compressed version Installation

Here was originally to MySQL official online download, but download speed is too slow, let the next colleague sent a compressed version of To me. The installation process encountered a lot of pits.

Here are the steps:

　　

1. First change the My-defalut.ini to My.ini into the bin directory
2. Add the environment variable mysql_home and add it to the path
New My.ini under 3.mysql directory
[Mysqld]
Basedir=d:\\software\mysql-5.7.17-winx64
Datadir=d:\\software\mysql-5.7.17-winx64\data
Port = 3306
Sql-mode=strict_trans_tables,no_auto_create_user,no_engine_substitution
# Maximum number of connections allowed
Max_connections=20
# The character set used by the service side defaults to the 8-bit encoded latin1 character set
Character-set-server=utf8
# The default storage engine that will be used when creating a new table
Default-storage-engine=innodb
[MySQL]
# Set the MySQL client default character set
Default-character-set=utf8
#代码结束

4. Generate the Data folder
Mysqld--initialize-insecure--user=mysql
5. Service Installation
Mysqld–-install

6. Start the service
net start MySQL

7. Set the password
Method One:
Update Mysql.user Set Authentication_string=password (' You want to enter the password ') where user= ' root ' and Host = ' localhost ';
And then enter:
Flush privileges;
Method Two:
Use the mysqladmin-u root-p Password command, prompt for a password to enter directly, and then enter a new password to complete the password modification
The command to exit MySQL is exit. The direct close CMD window is not exited, and the exit is not exited until you enter exit.

-----------------------------

This is mainly the following commands.

Start the service

net start MySQL

Stop Service

net stop MySQL

Connect to MySQL

Mysql-u root-p

-----------------------------

In doubt, please leave a message and make progress together. Thank you!

MySQL uninstall and compression version of the installation