Connecting to Database

Make sure the right info is in /root/.my.cnf

 

If you forgot your mysql root pass, you can reset it with this script:
[code:1:7c47f09e4e]
#!/usr/bin/perl

print "Enter new root pass: ";
chomp($newroot = <STDIN>
chomp($hostname = `hostname`);

system("kill `cat /var/lib/mysql/$hostname.pid`"
sleep(2);
system("killall -9 mysqld"
system("safe_mysqld --skip-grant-tables &"
sleep(2);
system("mysql -h localhost -e \"update user set Password=PASSWORD('$newroot') where User='root'\" mysql"
system("mysqladmin -h localhost flush-privileges"
print "mysql root pass set to $newroot\n";

if (! -e "/root/.my.cnf&quot {
open(MY, ">/root/.my.cnf&quot || die "can't open my.cnf for writing: $!\n";
print MY "[client]\npassword=$newroot\n";
close MY;
system("chmod 640 /root/.my.cnf"
}
print "Be sure to edit /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.php.inc!\n";
exit;
[/code:1:7c47f09e4e]
Hope that helps!

Regards,
Matt

[Edited on 8/14/01 by Site5-Matt]

 

/usr/local/cpanel/bin/updatephpmyadmin

You are probably looking to run this script.

 

[quote:8f970e772c].... I\'m doing it through WHM, and it says it changes it, but it doesn\'t. [/quote:8f970e772c]

WHM doesn\'t seem to update the new MySql password in ~/.my.cnf. Try putting the password in manually in that file after you\'ve changed it in WHM.

Nick, I know this isn\'t the bugs section, but you may like to have a look at this

Regards.

 

[quote:a5e6cfe454][quote:a5e6cfe454].... I\'m doing it through WHM, and it says it changes it, but it doesn\'t. [/quote:a5e6cfe454]

WHM doesn\'t seem to update the new MySql password in ~/.my.cnf. Try putting the password in manually in that file after you\'ve changed it in WHM.

Nick, I know this isn\'t the bugs section, but you may like to have a look at this

Regards. [/quote:a5e6cfe454]


Please post it in bugs so I can hope to keep track

 

[quote:44910f6c72] Please post it in bugs so I can hope to keep track.[/quote:44910f6c72]
Done.

 

My Sql

I looked in config.inc.php in /usr/local/cpanel/base/3rdparty/phpMyAdmin

But I dont see a password set. I did delete it from the other suggestion and after I updated my php, it changed password set to no in Cpanel, what else do I need to do?