ERROR 1045: Access denied for user

Question: I'm trying to start the mysql command-line utility and keep getting 'ERROR 1045: Access denied for user.' What does this mean and how do I fix it?
Answer: There are a few possibilities; you:

1. Didn't tell mysql to prompt you for the password. Try starting it like this:

    mysql -u username -p(Remember to replace "username" with the MySQL username assigned by your administrator.)

2. Supplied the wrong password. (Usernames and passwords are case-sensitive.)

3. Don't have access. Contact your administrator for more assistance.

Warning: While it's possible to specify your password while starting the mysql utility, we strongly recommend against doing so. If you do so, it's very possible your password can then be viewed by others using your system. Consider, for example, the w command, which (among other things) displays the command you're executing--along with any parameters used to start it.

ERROR 1045: Access denied for user: 'some_username@some_server' (Using password: YES)
While this error fundamentally means that the user 'some_username' is not authorized to access the host 'some_host', there can be a number of reasons why this happened. These are:

1. You typed entered your username or your password incorrectly. If this is a case you simply have to click on the back button and re-enter them.
2. The access permissions could be improperly set. Read the section titled Configuring the MySQL Access Rights to find out how to fix this problem.
3. The MySQL database has not be reloaded. This needs to be done for the new access rights to take effect. See the end of Configuring the MySQL Access Rights to see how to do this.

Hverken case 1, 2 eller 3 passer. Og ingen af løsning-forslagene passer heller! Jeg har jo RTFM :)

Du kan se rettighederne med

show grants for user    (user erstattes med det specifikke brugernavn)

Jeg har selv haft problemer med grant, og dette hjalp mig.

Mvh
Lone

Det var så også derfor jeg ikke skrev, hvad der stod i manualen men noget jeg fandt på andre sider - dog pegede *ALT* hvad jeg fandt på en af ovenstående muligheder, så jeg ville da forsøge at kigge det igennem en gang til - det kan jo også være at oprettelsen af brugeren er blevet korrumperet - prøv at oprette en tilsvarende bruger og se om du stadig har problemet dér!

GRANT ALL PRIVILEGES ON *.* TO 'brugernavn'@'%' IDENTIFIED BY PASSWORD '3fe85be5980d0b6f' WITH GRANT OPTION ser rigtigt ud.

Hvis jeg fjerner passwordet så virker brugeren korrekt.

Skal passwordet være klar tekst eller krypteret? Og hvis det skal krypteres hvilken metode skal der så bruges?

Fik det selv til at funge får lang tid siden nu, jeg lukker den fordi jeg rydder op i mine spørgsmål :)

Så kunne du eventuelt poste, så andre med samme problem (mig), også kan få gavn af dit spørgsmål :)