David T-G <[EMAIL PROTECTED]> wrote:
>
> I have just moved my web site from one server to another (whew!) and I am
> having a problem with a mysql user definition for a calendar program.
>
> I used mysqldump to dump the calendar database (wc_jpo) and loaded it on
> the new server; it appears to be happily there. I then ran
>
> grant all privileges on wc_jpo.* to wcjporoot identified by 'pass'
> with grant option ;
> flush privileges ;
>
> and similarly for "... wcjporoot@"%" ..." but still cannot get in;
> whenever I try with the mysql client I get
>
> bash-2.05a$ mysql -uwcjporoot -p wc_jpo
> Enter password:
> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
>
> and, similarly, the web script cannot get in. Yet when I select the user
> record from mysql.user and mysql.db they appear complete.
>
> What glaringly obvious omission have I failed to see?
>
>
Remove entry for user ''@'localhost from the mysql.user table:
DELETE FROM user WHERE user='' AND host='localhost';
FLUSH PRIVILEGES;
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
