access mysql with a password
Posted by: sirquits (---.asia.info.net)
Date: December 23, 2005 09:11AM

hi,

i want to make my mysql db secure, so i've set a password for the root user:

shell> mysql -u root
mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd')
-> WHERE User='root';
mysql> FLUSH PRIVILEGES;

in phpmyadmin, i changed the password also:

$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'newpwd'; // MySQL password

problem is, phpadmin now cannot acces mysql, even if i do this:

mysql> UPDATE mysql.user SET Password=OLD_PASSWORD('newpwd')
-> WHERE User='root';

any help?

Options: ReplyQuote
Re: access mysql with a password
Posted by: sirquits (---.asia.info.net)
Date: December 23, 2005 09:21AM

don't ask me why or how, but now it works smiling smiley

Options: ReplyQuote


Sorry, only registered users may post in this forum.