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.
Recent comments
1 day 2 hours ago
1 day 7 hours ago
1 day 8 hours ago
1 day 9 hours ago
1 day 11 hours ago
1 day 15 hours ago
1 day 16 hours ago
1 day 18 hours ago
2 days 7 hours ago
2 days 9 hours ago