MYSQL5.6 database ZIP installation and precautions in VS _ MySQL

MYSQL5.6 database ZIP installation and precautions for use in VS bitsCN.com

First, mount the resource: http://download.softagency.net/mysql/downloads /.

Find MYSQL5.6. for the two versions, check the system and set them to 64-bit: http://download.softagency.net/mysql/downloads/mysql-5.6/mysql-5.6.16-winx64.zip. Decompress the package and store it in the desired place. The path is D:/SDT/mysql5.6.16 _ x64, as shown in:

After decompression, the files in the directory may be a little different from those in the image. there are no files my. ini and my_default_old.ini, and there is a my_default.ini file. This is what we will do next. copy and paste the my_default.ini file in the current folder, and change the other file name to my. ini. The other file can be replaced or replaced with me.

The configuration file of my. ini needs to be changed to the following two places:

Basedir = D: // SDT // mysql5.6.16 _ x64
Datadir = D: // SDT // mysql5.6.16 _ x64 // data

Port = 3306
# Custom host ID identifier for master-slave or multi-server identification. it is an int type.
Server_id = 1

Or

Basedir = D:/SDT/mysql5.6.16 _ x64
Datadir = D:/SDT/mysql5.6.16 _ x64/data

Port = 3306
# Custom host ID identifier for master-slave or multi-server identification. it is an int type.
Server_id = 1

Note thatThe forward slash is two, and the backslash is one, Any one of the rows, other can be modified or not, my complete configuration is as follows:

# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html# * ** Do not edit this file. it's a template which will be copied to the # *** default location during install, and will be replaced if you # *** upgrade to a newer version of MySQL. [mysqld] # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. start at 70% of total RAM for dedicated server, else 10%. innodb_buffer_pool_size = 128 M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # These are commonly set, remove the # and set as required. basedir = D: // SDT // mysql5.6.16 _ x64datadir = D: // SDT // mysql5.6.16 _ x64 // dataport = 3306 # custom host ID identifier, it is used for identification between master and slave servers. it is an int type server_id = 1character_set_server = utf8 # maximum number of connections max_connections = 100 # default TABLE type of the create table statement. if you do not specify the type, use the downstream type default-storage-engine = InnoDB # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. join_buffer_size = 128Msort_buffer_size = 2Mread_rnd_buffer_size = 2 M SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

Next, add the database root directory path to the environment variable "path", for example, "D:/SDT/mysql5.6.16 _ x64/bin ".

Open the cmd console,Windows 7 system should be opened as Administrator, Enter "D:/SDT/mysql5.6.16 _ x64/bin/mysqld.exe -- install mysql5 ",Be sure to use full pathThe installation is successful in English. The command here probably means creating a database service instance of mysql5. If it cannot be started without a full path, you can enter "services. msc" in the running section to check the running Directory of the mysql5 service.

Enter "net start mysql5" in CMD to start the "mysql5" instance we just created. the normal operation should be in English that the data service is successfully enabled.

Next, configure the root password and enter "mysql-u root-p" in cmd. because the database does not have a password by default, press enter twice and enter"update user set password=PASSWORD(‘123456’) where User='root';"123456" indicates the password to be updated. you can change the password according to the actual situation.

Currently, the database is basically configured. next we can go to "MySQLWorkbench". my database version is 6.0.7 and the resources are located in the top directory. Decompress the package and put it into the desired file directory. Note that the directory path is preferably in English. Otherwise, an error may be reported, it indicates what ansi environment is required. Open mysqlworkbench.exe, Databse-> conect to database, fill in the user name and password, and the above root and 123456, you can operate mysql on the GUI.

Next, we integrated mysql in VS and found a. net_connecter above 6.7xx on the Internet that is no longer using the vs integration plug-in. we need to use the mysql-install tool:

Bytes.

Another online installation version for the web version:

Http://cdn.mysql.com/Downloads/MySQLInstaller/mysql-installer-web-community-5.7.3.0-m13.msi

BitsCN.com