How to change the ‘root’ password for MySQL in cpanel?

[amie900218]

hai, can somebody help me, how to change root password for mysql in CPANEL? i tried to put my website online, but it send message :

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in /home/akmajuco/public_html/_class/cms_class.php on line 9
Access denied for user 'root'@'localhost' (using password: YES)

i hope someone can help me.

[pritaeas]

Most hosts don't provide an option for this (and I don't think they will allow you to use root). I think you should use the username and password as provided by them. Also, you should be able to create new users in your cPanel, then you can create your own password.

[amie900218]

haha, tq pritaes for the reply. i have solve it using your suggestion.