Lost of mysql root password

satimis · 12-06-2007, 07:30 AM

Hi folks,

Ubuntu 7.04 server amd64
mysql-server 5.0.38
mysql-admin 1.2.5rc-1
mysql-admin-common 1.2.5rc-1
mysql-client 5.0.38
libmysqlclient15-dev 5.0.38

$ sudo mysql -u root mysql

Code:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Please advise how to recreate new mysql root password w/o the old password? TIA

B.R.
satimis

trickykid · 12-06-2007, 07:45 AM

You didn't pass a password to it. If you don't know your password, restart mysql with the --skip-grant-tables switch, reset or create new password for root, then restart again without the --skip-grant-tables

If you do know the old password, try running:

mysql -uroot -p mysql

And let it prompt for the password, or pass it with --password=<password>

satimis · 12-06-2007, 08:43 AM

Quote:

Originally Posted by trickykid

You didn't pass a password to it. If you don't know your password, restart mysql with the --skip-grant-tables switch, reset or create new password for root, then restart again without the --skip-grant-tables

Thanks for your advice.

Tried some suggesions found on googling w/o result.

Performed test;

# /etc/init.d/mysql stop

Code:

 * Stopping MySQL database server mysqld                                    [ OK ]

# /etc/init.d/mysql start --skip-grant-tables

Code:

 * Starting MySQL database server mysqld                                    [ OK ] 
 * Checking for corrupt, not cleanly closed and upgrade needing tables.

# mysql -u root password myrootpassword

Code:

mysql  Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (x86_64) using readline 5.2
Copyright (C) 2002 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Usage: mysql [OPTIONS] [database]
  -?, --help          Display this help and exit.
......
......
column-names                      TRUE
sigint-ignore                     FALSE
port                              3306
prompt                            mysql> 
quick                             FALSE
raw                               FALSE
reconnect                         TRUE
socket                            /var/run/mysqld/mysqld.sock
ssl                               FALSE
ssl-ca                            (No default value)
ssl-capath                        (No default value)
ssl-cert                          (No default value)
ssl-cipher                        (No default value)
ssl-key                           (No default value)
ssl-verify-server-cert            FALSE
table                             FALSE
debug-info                        FALSE
user                              root
safe-updates                      FALSE
i-am-a-dummy                      FALSE
connect_timeout                   0
max_allowed_packet                16777216
net_buffer_length                 16384
select_limit                      1000
max_join_size                     1000000
secure-auth                       FALSE
show-warnings                     FALSE

# mysql -u root -p

Code:

Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Still failed.

Eversince I accidentally removed /home/satimis previously some problem popup. Whether I have to remove mysql-server and reinstall it? Would it affect other packages. The mail server is now running w/o problem including SquirrelMail, the webmail.

TIA

B.R.
satimis

jay73 · 12-06-2007, 09:04 AM

http://dev.mysql.com/doc/refman/5.0/...rmissions.html

satimis · 12-06-2007, 09:59 AM

Hi folks,

Problem solved following;

Recover MySQL root password
http://www.cyberciti.biz/tips/recove...-password.html

Thanks

satimis

trickykid · 12-06-2007, 12:30 PM

Quote:

Originally Posted by satimis

Hi folks,

Problem solved following;

Recover MySQL root password
http://www.cyberciti.biz/tips/recove...-password.html

Thanks

satimis

Yeah, I'm kind of confused on why you would try passing a password as:

mysql -u root password mypassword

Did you not read my instructions:

mysql -u root -p mysql --password=password

It kind of needs the -- and = when specifying the password.

You can also do:

mysql -uroot -p<password> without a space and it will work but I don't recommend this. Anyone that gains access to your server can see your mysql password in your history.

satimis · 12-06-2007, 09:05 PM

Quote:

Originally Posted by trickykid

Yeah, I'm kind of confused on why you would try passing a password as:

mysql -u root password mypassword

Did you not read my instructions:

mysql -u root -p mysql --password=password

It kind of needs the -- and = when specifying the password.

You can also do:

mysql -uroot -p<password> without a space and it will work but I don't recommend this. Anyone that gains access to your server can see your mysql password in your history.

Hi trickykid,

Sorry I haven't finished trying your second suggestion. On running;

Code:

# mysql -u root -p mysql

It popup for password. The old password can't work. I don't why. So I stopped there.

satimis