Download and configure MySql, quickly start MySql batch processing, MySQL client software SQL-Front configuration --- ShinePans

Download and configure MySql, quickly start MySql batch processing, MySQL client software SQL-Front configuration --- ShinePans

First, download the SQL Green Edition,: http://yunpan.cn/cgERHhTtV8XGh extraction code 85bc

Decompress the package and use it. The installation directory contains the bin folder to start the service from the command in it.

As follows:

Then go to cmd and enter D: (I put the decompression package on drive D) to enter the root directory of drive D.

Then input cd D: \ mysql-5.0.22-win32 \ bin to enter the root directory of the installation package (you can copy the path and then cd)

Then enter the command mysqld -- console to enable the mysql Service as follows:

To start the service, you can use batch processing to create a text file in the bin directory, named MySql_Startup.txt, and double-click it, enter the text mysqld -- console, save the text, and change the file suffix. bat. Double-click the next time you start the service.

Then download SQL front 3.3:

Http://yunpan.cn/cgE6gB8eNrE5J extraction code 72b6

Set the server to localhost port 3306 by default

I encountered a problem with #1045 when I was just connecting. This is due to permission issues and password problems. Then I set the mysql permission to change the root password to 123.

Open cmd, cd, go to the bin directory of installation, and then enter the command line

End the mysql service, or directly terminate the mysqld-nt process in the task manager.

Enter mysqld-nt -- skip-grant-tables to disable the security check.

Msqladmin-u root flush-priviledges password "enter a new password here" note that you cannot forget the quotation marks

Now, connect to the database.