Daniela Mamede d Almeida Wrote:
-------------------------------------------------------
> I have to load a file to my mysql db. For that I
> do...
> mysql xxx < load_sentence.sql
> ERROR 1045 (28000): Access denied for user
> 'defendoc'@'localhost' (using password: YES)
>
> The user table has ...
> mysql> select * from user where User =
> 'defendoc';
> | Host | User | Password | Select_priv
> | Insert_priv | Update_priv | Delete_priv |
> Create_priv | Drop_priv | Reload_priv |
> Shutdown_priv | Process_priv | File_priv |
> Grant_priv | References_priv | Index_priv |
> Alter_priv | Show_db_priv | Super_priv |
> Create_tmp_table_priv | Lock_tables_priv |
> Execute_priv | Repl_slave_priv | Repl_client_priv
> | Create_view_priv | Show_view_priv |
> Create_routine_priv | Alter_routine_priv |
> Create_user_priv | ssl_type | ssl_cipher |
> x509_issuer | x509_subject | max_questions |
> max_updates | max_connections |
> max_user_connections |
>
> | % | defendoc | 27605b3a4b0c11b5 | N
> | N | N | N | N
> | N | N | N | N
> | Y | N | N
> | N | N | N | N
> | N | N |
> N | N | N
> | N | N | N
> | N | N |
> | | | |
> 0 | 0 | 0 |
> 0 |
>
> If I run any other query, it works perfectly.
> If I change "Host" for localhost, it works fine.
> But I think "%" allows every host, isn't it?
> Which can be the problem?
>
> Thanks a lot in advanced.
> Daniela.
You need to create the SAME user at 'localhost' and '%'. It is related to the way MySQL sorts user's table.
Full explanation of why you need permissions at 'localhost' and '%' can be found at:
http://dev.mysql.com/doc/refman/5.1/en/adding-users.html