About MySQL green version of the installation operation

MySQL has a fool-style installation and a green installation of two versions:

1. Fool style

   Fool-type installation just need to set up the path of installation, server type, account and password, types of access and other basic operations, its settings are also simple button event triggered, you can compare the simple to put their own MySQL local server installed, including its database encoding set operation.

2. Green Edition

The green version of MySQL installation is also relatively simple, but in the installation of the need for careful operation, which involves:

2.1 List

The green version of the decompression, and the decompression of the path, such as the author's path: " D:\Program Files\mysql-5.6.15 " in the context of the system set: " Path：‘mysql的安装路径’ ;

2.2 List

The basic configuration of MySQL database, that is, the basic configuration of MySQL database in My-default.ini file, the basic configuration that I do here is to realize the installation path of MySQL, as well as the configuration of port number and so on.

Such as:

Basedir =d:/program files/mysql-5.6.15
DataDir =d:/program Files/mysql-5.6.15/data
Port =3306
server_id =10

2.3 The final installation of the MySQL database is performed under administrator's permission after the above operation is completed:
Mysqld install mysql–defaults-file= "Your INI file path, which is the file path modified above"

2.4 Starting the Service

net start MySQL without error, prompt to start successfully

2.5 If the server fails to start, you can try the following:

Enter cmd into the MySQL installation directory, then cut into the bin directory and enter the Mysqld-nt--skip-grant-tables command. This cmd window does not close first, open another window to log in to MySQL or directly open the MySQL Command line Client input the correct password, OK!

2.6 Configuration of the user name and password for the server:

Mysql-u root-p Initial password is empty mysql>use mysql;mysql>update user set Password=password (' NewPassword ') where user= ' root '; Mysql>flush privileges;

2.7 View the encoding of your own MySQL database:

Show variables like ' character% '; The following is my own:! [Enter picture description here] [1] Modify the operation of the encoding: if it is a green version of the installation, then the coding is more troublesome, we can use the following URL for each database connection when the database connection: jdbc:mysql://localhost:3306/database name? Useunicode=true&characterencoding=utf-8 do not have any spaces, otherwise it will go wrong.

About MySQL green version of the installation operation