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
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:
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.