After added the skip - grant - tables also restart, but still appear this problem, can't enter the mysql, really don't know what's the reason and solve,,

CodePudding user response:

See the error log, posted

CodePudding user response:

Look at the error log

CodePudding user response:

The original poster hello
I was wondering if you forgot the root password

The steps
1, first check whether the mysql service is started, if has launched its first stop service, can be in the operation of the start menu, use the command:
Net stop mysql


Open the first cmd1 window, switch to mysql bin directory, run the command:
Mysqld - defaults to the file="C: \ Program Files \ MySQL \ MySQL Server 5.1 \ my ini" - the console - skip - grant - tables
Note:
This command by skipping access security checks, open the mysql service, such a connection to the mysql, don't have to enter your user password, has opened up the mysql service at this time!
Keep not to close the window,


2, open the second cmd2 window, connect mysql:
Type the command:
Mysql -u root -p
A:
Enter the password:
Enter directly, in here you don't have to enter the password,
Then I would be a successful login information,


Using the command:
show databases;


Use the command to switch to the mysql database:
use mysql;
Use the command to change the root password:
UPDATE the user SET the Password=Password (' newpassword) where the user='root';

Refresh the permissions:
FLUSH PRIVILEGES;
Then exits, log back in:
The quit
Log back in, can turn off before the cmd1 window, and then use the.net start mysql start the service
Mysql -u root -p
Input password prompt, enter the new password login:
Enter password: * * * * * * * * * * *
The login information: success is all ok

CodePudding user response:

The original poster and stickers to genuflect is begged

CodePudding user response:

After I enter the password or not, or there were 2003 10061 error, not into the data
, could you tell me how to solve the building Lord finally

CodePudding user response:

Ok, quite right

CodePudding user response:

Me too, even have no access to the mysql server now