Having Problems loging into Mysql Database Ubuntu 6.06 Perfect Setup

admin@monitorwaves:~$ mysqladmin -u root password sqlpass
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

I am connecting using putty could this be why i am having this problem? If not then why am i getting this error. Thanks again for your time. You guys are GREAT!

 

try this

I had this same problem before. Here's what I think I did try:
mysqladmin -u root -p sqlpass

-u = user and -p should = password iirc. This may require you to enter your password after you press enter (not sure if sqlpass actually is read or not) but either way you should be able to login with this. let me know if it doesn't work and I'll see what else I can find.

 

Hi all,

This might be good reading

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

regards
brainz