Topic: Mysql on SME 7.0 RC3

[maykelsoft]

How can I restore the mysql root default password?

I got this error:
Access denied for user 'root'@'localhost' (using password: YES)

Please help.

Thanks,

Mike

[judgej]

How can I restore the mysql root default password?

I would recommend that you don't. Leave the root password well alone, as it is hard-coded in a number of different places.

If you want to create and manage your own databases, then log in as root and create a  new user with all the relevant privileges. Use that new user exclusively.

-- JJ

[raem]

maykelsoft

> How can I restore the mysql root default password?

Darrell May has a howto in his contrib area which I think is still applicable.

[maykelsoft]

Where can I get that howto?

When using mysql I got this error:
[root@server]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Thanks,

Mike

[judgej]

Where can I get that howto?

When using mysql I got this error:
[root@server]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Are you sure you want to reset the mysql root password? Is everything else working? If so, best not to touch the root password.

The file '.my.cnf' in the root home directory contains the password that the shell root user will use to log in to mysql. Try expanding that template and see if it makes a difference:

/sbin/e-smith/expand-template /root/.my.cnf

You did not say how your password got changed. Was it like like after an install? After an update? Or have you been changing it?

-- JJ

[maykelsoft]

Got same error... when issuing command mysql

[root@server ~]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[raem]

maykelsoft

> Where can I get that howto?

The Contribs link at the left is a good place to start, then click the link for Users Contrib Directories which should take you to
http://mirror.contribs.org/smeserver//contribs/

Look in dmay, although I have just looked myself and cannot find it there.
I'm sure there used to be a howto for resetting the mysql password to the default, for those naughty people who change it and should not have changed it.
You may have to search the wayback machine web site, unless someone else can provide a link.

[raem]

maykelsoft

I think the howto I referred to has been deprecated, that's probably why it was removed. Charlie Brady answered this a while ago so search these forums on mysql and you will find the answer.

[chris burnat]

http://bugs.contribs.org/show_bug.cgi?id=399
http://bugs.contribs.org/show_bug.cgi?id=778
Hope it helps...

[maykelsoft]

Its working now... thanks for all your reply...

Solve by issuing this commad:
# cd cd /service/mysqld
# runsvctrl d .
# /usr/libexec/mysqld --bootstrap --user=mysql  --skip-grant-tables < ./set.password
# runsvctrl u .

Thanks...

Mike

[recoco]

How can I restore the mysql root default password?

If you want to create and manage your own databases, then log in as root and create a  new user with all the relevant privileges. Use that new user exclusively.

-- JJ

hi,sir.What is the root's default password?I did'nt remerber i had set that on install process.

[dsemuk]

hi,sir.What is the root's default password?I did'nt remerber i had set that on install process.

It is a random (74 character)? string generated during the install process.

You cannot simply copy the password from another server.

Dave

[recoco]

hi,sir.What is the root's default password?I did'nt remerber i had set that on install process.

It is a random (74 character)? string generated during the install process.

You cannot simply copy the password from another server.

Dave

found it.It is in root's home dir.filename is .my.cnf.