Lost password - Linux sql
Posted on 2003-03-22
I have just started to use mysql, and was using webmin as a front end. I changed the password and now I get the error:
SQL select * from user order by user failed : Access denied for user: 'root@localhost' to database 'mysql'
trawling through the docs I find that I can --flush-privilege-tables. I assumed the syntax would be
but this is obviously wrong
I can log into mysql but when I try to change anything or create a database I get ERROR 1044: Access denied for user: 'root@localhost' to database 'newdatabase'
In fact I'm quite familiar with ERROR 1044: Access denied for user: 'root@localhost'... its all I ever seem to get (note of despair).
So how do I start again so that I can learn how to use it?
And how did I get myself into this mess - is there a problem using mysql as root?
Many thanks in advance.