installation of MySQL

MySQL is a relational database management system developed by the Swedish MySQL AB company and currently belongs to Oracle products. MySQL's most popular relational database management system, MySQL is one of the best RDBMS (relational database Management system, relational databases management systems) application software in WEB applications.

1> download MySQL database, go to official website download: http://www.mysql.com/, select Downloads---Community---mysql Community Server

2>: After the download corresponds to a zip compressed file, unzip well, put in your own habit of the disk. I put it here in C:\Program Files\mysql, such as:

3> in the corresponding folder, there is a my-default.ini, a copy in the folder, renamed to My.ini.

4>. Open My.ini, add the following configuration to the file, save and exit

-This is the database installation path Basedir = C:\Program files\mysql--This is the database's save path DataDir = C:\Program files\mysql\data--This is the port number of the database port = 3306

　　　　　　

5>. Configure the environment variables for MySQL, such as:

C:\Program Files\mysql is the installation path of the database

　　　　

6> As an administrator, go to command prompt cmd and switch to the MySQL bin directory below:

7>. Execute mysqld.exe--initialize command

After executing this command, we will find a folder of data in the MySQL installation directory,

8>: Executes the Mysqld-install installation command, the successful word appears as follows-Service successfully installed.

9> mysqld.exe-nt--skip-grant-tables, after the command is entered, the window does not react, and it is closed.

10>: Reopen the DOS window, switch to the MySQL bin directory, and execute Mysql.exe-u root.

11> After execution, close the DOS window. Enter the task manager at the same time, turn Mysqld.exe off and re-enter the service to open MySQL:

*. Note If the warp configuration appears

installation of MySQL