WampServer
Apache, PHP, MySQL on Windows
Home forum
Back to WampServer
presentation
Downloads
Addons
Trainings
Alter Way
Go to Topic:
Previous
•
Next
Go to:
Forum List
•
Message List
•
New Topic
•
Search
•
Log In
•
Print View
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:
Reply
•
Quote
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
Options:
Reply
•
Quote
Go to:
Forum List
•
Message List
•
Search
•
Log In
Sorry, only registered users may post in this forum.
Click here to login