MySQLroot password reset error: mysqladmin: connecttoserverat 'L _ MySQL

MySQLroot password reset error: mysqladmin: connecttoserverat bitsCN.com

MySQL root password reset error: mysqladmin: connect to server at 'localhost' failed solution

1. login failed. mysqladmin failed to change password

[Root @ mysql var] # mysqladmin-u root password '123'

Mysqladmin: connect to server at 'localhost' failed

Error: 'Access denied for user' root' @ 'localhost' (using password: NO )'

2. stop the mysql service.

[Root @ mysql var] #/etc/init. d/mysqld stop

Shutting down MySQL... SUCCESS!

3. start in security mode

[Root @ mysql var] # mysqld_safe -- skip-grant-tables &

/Opt/mysql/product/5.5.25a/bin/mysqld_safe -- skip-grant-tables &

[1] 10912

[Root @ mysql var] #110407 17:39:28 mysqld_safe Logging to '/usr/local/mysql/var // mysql.chinascopefinanical.com. err '.

110407 17:39:29 mysqld_safe Starting mysqld daemon with databases from/usr/local/mysql/var/

4. log on with the root account without a password

[Root @ mysql var] #/usr/bin/mysql-uroot-p [Note: You do not need to worry about the password when you are required to enter the password, press the enter key and you will be taken over]

Enter password:

Welcome to the MySQL monitor. Commands end with; or/g.

Your MySQL connection id is 48

Server version: 5.1.41-log Source distribution

Type 'help; 'or'/h' for help. type'/C' to clear the current input statement.

Mysql> use mysql;

Database changed

5. manually update the password

Mysql> update user set password = password ("guxxxxxahyotherwise") where user = 'root' and host = 'localhost ';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

Mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

Mysql> quit

Bye

[Root @ mysql var] # mysql-uroot-pgunnhtqhjunfky6ahyh _

Welcome to the MySQL monitor. Commands end with; or/g.

Your MySQL connection id is 172

Server version: 5.1.41-log Source distribution

Type 'help; 'or'/h' for help. type'/C' to clear the current input statement.

Mysql> quit

Bye

6. restart normally

[Root @ mysql var] # service mysqld restart

Shutting down MySQL .. 110407 17:45:29 mysqld_safe mysqld from pid file/usr/local/mysql/var // mysql.chinascopefinanical.com. pid ended

SUCCESS!

Starting MySQL... SUCCESS!

[1] + Done mysqld_safe -- skip-grant-tables

[Root @ mysql var] #

7. other forms of error analysis

7.1 if no sock is found, an error is returned:

[Root @ app60 mysqld] #/usr/bin/mysql-uroot-p

Enter password:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql. sock' (111)

[Root @ app60 mysqld] #

Add the sock parameter when logging on.

[Root @ app60 mysqld] #/usr/bin/mysql-uroot-p -- socket =/opt/mysqldata/mysql. sock

Enter password:

Welcome to the MySQL monitor. Commands end with; or/g.

Your MySQL connection id is 6

Server version: 5.1.69 Source distribution

Copyright (c) 2000,201 3, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

Affiliates. Other names may be trademarks of their respective

Owners.

Type 'help; 'or'/h' for help. type'/C' to clear the current input statement.

Mysql>

Mysql>

7.2 ERROR [Error]/usr/libexec/mysqld: ERROR writing file '/var/run/mysqld. pid' (Errcode: 28)

130830 10:59:02 InnoDB: Initializing buffer pool, size = 1.0G

130830 10:59:02 InnoDB: Completed initialization of buffer pool

130830 10:59:02 InnoDB: Started; log sequence number 0 2727887496

130830 10:59:02 [ERROR]/usr/libexec/mysqld: Error writing file '/var/run/mysqld. pid' (Errcode: 28)

130830 10:59:02 [ERROR] Can't start server: can't create PID file: No space left on device

130830 10:59:02 mysqld_safe Number of processes running now: 0

130830 10:59:02 mysqld_safe mysqld restarted

130830 10:59:02 InnoDB: Initializing buffer pool, size = 1.0G

130830 10:59:02 InnoDB: Completed initialization of buffer pool

130830 10:59:02 InnoDB: Started; log sequence number 0 2727887496

130830 10:59:02 [ERROR]/usr/libexec/mysqld: Error writing file '/var/run/mysqld. pid' (Errcode: 28)

130830 10:59:02 [ERROR] Can't start server: can't create PID file: No space left on device

130830 10:59:03 mysqld_safe Number of processes running now: 0

130830 10:59:03 mysqld_safe mysqld restarted

130830 10:59:03 InnoDB: Initializing buffer pool, size = 1.0G

[Analysis]: if the default pid file cannot be written, modify/etc/init. d/mysqld and point the pid to another path.

[Root @ app60 mysqld] # vi/etc/init. d/mysqld

.....

Get_mysql_option mysqld datadir "/var/lib/mysql"

Datadir = "$ result"

Get_mysql_option mysqld socket "$ datadir/mysql. sock"

Socketfile = "$ result"

Get_mysql_option mysqld_safe log-error "/var/log/mysqld. log"

Errlogfile = "$ result"

Get_mysql_option mysqld_safe pid-file "/opt/mysqldata/mysqld. pid "# '/var/run/mysqld. pid 'raw value. here it is changed to another path/opt/mysqldata/mysqld. pid

Mypidfile = "$ result"

.....

Then start the mysqld service. OK.

BitsCN.com