Installation and uninstallation of the installation board MySQL

Originally downloaded an installed version of MySQL, the official network is written 32-bit, but can be used on 64-bit machine, the installation process of the other modules can basically install, but the most important MySQL server installation failed. The log shows a missing vs2003, I installed a 2007, but I still can't install MySQL server. The online search did not find a practical solution, and finally decided to re-download a version.

Download a free-install version of MySQL from the official website, the first time with this version, recorded.

1, after the decompression of a new My.ini file, the contents are as follows

[MySQL]
# Set the MySQL client default character set
Default-character-set=utf8
[Mysqld]
#设置3306端口
port=3306
# set up the MySQL installation directory
basedir=d:/mysql/mysql-5.7.19-winx64/
# Set up a storage directory for MySQL database data
datadir=d:/mysql/mysql-5.7.19-winx64/data/
# Maximum number of connections allowed
max_connections=200
# 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
# Password-Free login
Skip-grant-tables

2. Create an empty folder data

3, run cmd with administrator privileges, switch to the MySQL bin directory, run "Mysqld.exe-install"

4, then you can see in the service Manager MySQL, directly with the mouse can start and stop

Gorgeous Split-line------------------------------------------------------------------------------------------------------------------

If the installation of MySQL has a problem requiring "uninstall", as long as a single command can be done "sc delete mysql", where MySQL is the name. Then you can re-install MySQL.

Installation and uninstallation of the installation board MySQL