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

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.