View Single Post
  #9  
Old 7th February 2006, 23:03
Jrdgames Jrdgames is offline
Member
 
Join Date: Feb 2006
Location: USA East Coast
Posts: 71
Thanks: 11
Thanked 0 Times in 0 Posts
Default

this command: mysqladmin -u root password yourrootsqlpassword seems to require that you have a mysql password and this command: mysqladmin -u root -p<current_password> password <new_password> seems to be for resetting the password but you have to have a password to reset and on this page it says
Quote:
If you have never set a root password for MySQL, the server does not require a password at all for connecting as root.
but in terminal if I leave the password blank it says it fails to connect:
Code:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
is there any easier way to do it? or is there an interface that can be used instead of doing everything through terminal?

Sorry for not understanding this very good but im new to it.
thankyou for your help so far.
__________________
My Server Stats:
No servers currently working.