Lost of mysql root password

satimis · #1 (**permalink**) 12-06-07, 07:53

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

shammat · #2 (**permalink**) 12-06-07, 09:31

Everything you need is in the manual

r937 · #3 (**permalink**) 12-06-07, 10:02

nice one, shammat

see http://forums.devshed.com/mysql-help...rd-494248.html

satimis · #4 (**permalink**) 12-06-07, 10:12

Quote:

Originally Posted by shammat

Everything you need is in the manual

Thanks for your advice.

# kill `cat /var/run/mysqld/mysqld.pid`
No complaint

# SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mysqlpassword');

Code:

bash: syntax error near unexpected token `('

# SET PASSWORD FOR 'root'@'localhost' = PASSWORD'mysqlroot';

Code:

bash: SET: command not found

# which set
# which SET
both w/o printout.

Pls advise which package I need to install to have this bash command 'SET'? TIA

B.R.
satimis

shammat · #5 (**permalink**) 12-06-07, 10:16

Quote:

Originally Posted by satimis

Pls advise which package I need to install to have this bash command 'SET'?

Read the manual carefully:

Quote:

Originally Posted by Manual

Create a text file and place the following command within it on a single line

r937 · #6 (**permalink**) 12-06-07, 10:26

Quote:

Originally Posted by shammat

Read the manual carefully:

heh, RTFMC

by0nder · #7 (**permalink**) 01-19-08, 10:52

shell> echo "SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');" > /etc/mysql-init
shell> sudo mysqld_safe --init-file=/etc/mysql-init &

Internet Services

Web Development

Digital Marketing

Consumer Tech