Original Poster Posted September 24, 2008 Share Posted September 24, 2008 hi i need some help with the mysql server on my ubuntu server.. basicly im using the apache2 with the mysql and the phpmyadmin but my sql has no password!!!! i want to know how to add one please thank yous :p if any one can give me a script it would be great Link to comment Share on other sites More sharing options...
-Alex- Posted September 24, 2008 Share Posted September 24, 2008 Run this in shell: mysqladmin -u root password NEWPASSWORD Or this from PHPMyAdmin: update user set password=PASSWORD("NEWPASSWORD") where User='root'; Link to comment Share on other sites More sharing options...
-Alex- Posted September 27, 2008 Share Posted September 27, 2008 Just to clarify, if you're using the PHPMyAdmin option, you need to have selected the mysql database, and after you've ran that command, run: flush privileges; Link to comment Share on other sites More sharing options...
Recommended Posts