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.