MySQL Green installation

Download file: MySQL5.1 (green). rar MySQL Green edition installation

1. Unzip the MySQL server 5.1.rar to the MySQL Server 5.1 directory

2. Modify the My.ini file under MySQL Server 5.1 folder

Basedir= "G:/mysql/mysql Server 5.1/"

Datadir= "G:/mysql/mysql Server 5.1/data/"

Modify the directory correctly

3. Execute the install.cmd file under Bin directory

4, you can run the root directory directly under the Run.bat file to start the MySQL service,

5. There are also some bat files under the bin directory,
Install.bat
Unstall.bat
Stop the service. bat
Start the service. bat
Connect. bat
The password for the root user of the database can be found in the Connect. bat file, and you can see the "Instructions for use. txt" file in the compressed package

Reference Source: http://www.cnblogs.com/kuailewangzi1212/archive/2011/11/02/2232940.html

------------------------------------

Error description

After the installation is successful, start the service, continue to enter in cmd: net start MySQL, the service started successfully!

At this time many people will appear error, please see note:

Note: Error 2 and error 1067 often occur at this time.

If the "Error 2 system cannot find a file", check whether the configuration file has been modified or whether to enter the bin directory, if the configuration file is correct and enters the bin folder, you need to remove MySQL (remove service input mysqld--remove MySQL) and re-install (input mysqld-install);

If error 1067 occurs, it is a configuration file modification error, verify that the configuration file is correct.

After the service starts successfully, you can log in, enter Mysql-u root-p (the password of the database root user), log in successfully!

Reference Source: http://www.cnblogs.com/gaintry/p/5772685.html

---------------------------------

What to do if the root password in MySQL is forgotten

The previous period of time to change the root password in MySQL at random to get a, and did not when the matter, 10.1 back to use when they found that they forgot the password from the online search, did the following summary:

1) First close the MySQL service net stop MySQL on the command line and start it in the command line without checking permissions;
Mysqld--skip-grant-tables interface will stay there all the time, don't bother with it.

2) then reopen a command Prompt window (CMD) with a blank password to log in to MySQL using the root user;
Mysql-u Root directly in, modify the root user's password (at this time cannot use the Set Password statement);
mysql> Update Mysql.user Set Password=password (' New password ') where user= ' root ';
mysql> flush Privileges;
Mysql> quit

3) then press and hold CTRL + ALT + DEL on the keyboard, open Task Manager, end the MYSQL-NT process or end the mysqld process, or end all MySQL-related processes, then restart the MySQL service and reopen the command-line interface MySQL- Uroot-p Enter your new password is OK;
The above is the password cracking method of MySQL under Windows.

Now I'm talking about MySQL under Linux.
1) in etc/my.cnf [mysqld] field join: skip-grant-tables restart MySQL service,
MySQL does not require a password to log in to the database
2) then go to MySQL mysqluse MySQL;
MySQL Update user set Password=password (' New password ') WHERE user= ' root ';
After running, finally remove the etc/my.cnf in the Skip-grant-tables, restart Mysqld can

Reference Source: Http://zhidao.baidu.com/link?url= Cb29xskhydun4wsl0zr3ixzmwtdcjv0mpyrpvpc-c3ur8pdcdbfgqgsu2ynlkocg7zykeoojlcmpvitsew-7tq

MySQL Green installation