Mysql password reset?

[RogelioH]

Hi,

I typed this by mistake

root@host [~]# /usr/bin/mysqladmin -u root password 'new-password'

how can i reset the passwd? am getting weird errors when going to mysql in user control panel.

cPanel.net Support Ticket Number:

[tAzMaNiAc]

Originally posted by RogelioH
Hi,

I typed this by mistake

root@host [~]# /usr/bin/mysqladmin -u root password 'new-password'

how can i reset the passwd? am getting weird errors when going to mysql in user control panel.

cPanel.net Support Ticket Number:

Do you have access to WHM?

You can reset it there.

cPanel.net Support Ticket Number:

[RogelioH]

I am trying but it doesnt let me.

here is what i get in user control panel when i click on mysql..



ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)'



And when i try to reset through whm i get.


030603 18:23:28 Do you already have another mysqld server running on port: 3306 ?
030603 18:23:28 Aborting

030603 18:23:28 /usr/sbin/mysqld: Shutdown Complete

Done
Changing Password....ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
Done
Reloading Mysqld...
Done








cPanel.net Support Ticket Number:

[tAzMaNiAc]

Originally posted by RogelioH
I am trying but it doesnt let me.

here is what i get in user control panel when i click on mysql..



ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)'



And when i try to reset through whm i get.


030603 18:23:28 Do you already have another mysqld server running on port: 3306 ?
030603 18:23:28 Aborting

030603 18:23:28 /usr/sbin/mysqld: Shutdown Complete

Done
Changing Password....ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
Done
Reloading Mysqld...
Done








cPanel.net Support Ticket Number:

Oh boy.. I didn't have that problem? Maybe submit a support request to Cpanel.... They would know what to do.

cPanel.net Support Ticket Number:

[RogelioH]

thank you guys i fixed it.

cPanel.net Support Ticket Number:

[bmcclure]

How did you fix it? I changed the password to what I wanted to after MySQL just updated to .13 and now everythign says access denied for root@localhost...

cPanel.net Support Ticket Number:

[123computerbook]

i have the same prob whats the fix??

cPanel.net Support Ticket Number: