MySQL free install version + SQLYOG installation Steps---a little late for the hair.

Source: Internet
Author: User
Tags configuration settings mysql free

Always some friends will not install MySQL, in fact, the software installation is not the focus of learning MySQL, basically installed once, after the general company will not let you install, if not to install, Baidu a bit on the line. Install version Baidu has a lot of, below to provide a free installation version of the steps it:

Extract

Create a new TXT text

Rename to My.ini

Open with Notepad

Configure required information, save exit

Configuring Environment variables

Save path

Open Environment configuration settings

Select Path

put it in the last Press the keyboard End Key ---- The cursor reaches the last semicolon ; End

Add the mysql bin directory and click OK

Start Menu Enter cmd to run as Administrator

CD to MySQL bin path

Execution command mysqld-install installation

then enter net start MySQL

Service started successfully

or Windows key +r key to bring up run interface input services.msc

find MySQL Right-click Start service

Refresh services.msc will find that MySQL can run services.msc launch next time. MySQL Service has

Input mysql-u root-p carriage return

You can set the password here.

Method 1: Use the Set password command
Log In FirstMysql.
format:Mysql> Set password for user name @localhost = password (' new password ');
Example:mysql> Set password for [email protected] = password (' 123 ');

Method 2: Use Mysqladmin
format:Mysqladmin-u username-p Old password password new password
Example:mysqladmin-uroot-p123456 Password 123

Method 3: Edit the user table directly with update
Log In FirstMysql.
mysql> use MySQL;
mysql> Update user set Password=password (' 123 ') where user= ' root ' and host= ' localhost ';
mysql> flush Privileges;

Method 4: When you forget the root password, you can do this
take windows as an example:
1. Close the running MySQL service.
2. Open the DOS window and go to the Mysql\bin directory.
3. Enter Mysqld--skip-grant-tables carriage return. --skip-grant-tables means skipping permission table authentication when starting the MySQL service.
4. Open a DOS window again (because the DOS window is no longer moving), go to the Mysql\bin directory.
5. Enter MySQL return and, if successful, the MySQL prompt > will appear.
6. Connection rights database: use MySQL;.
6. Change Password: Update user set Password=password ("123") where user= "root"; (don't forget the last semicolon).
7. Refresh permissions (required steps): flush privileges;.
8. Quit quit.
9. Log out of the system and then enter, using the username root and the new password you just set 123 to log in.

Let's take a look at the installation of SQLyog

Double-click the. exe file

Select the language and Determine

just close it and open it.

Then select New

OK, you can.

No password changes so don't fill in the code. Click Connect

Click Yes

Click Yes

you can do it after you maximize it.

You can modify password authorization by SQLyog new user , etc.

Click Add New User

Enter user name and password

This step to see your own situation select if the native test chooses localhost

Then click Create

Save changes after authorization and close

Reconnect the SQLyog, please.

Select yes after clicking Connect

Success

The next step is to use the

MySQL free install version + SQLYOG installation Steps---a little late for the hair.

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.