-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi, all --

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?


TIA & HAND

:-D
- -- 
David T-G                      * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/      Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (FreeBSD)

iD8DBQFAYBTxGb7uCXufRwARAhEGAKC35yFC89RpB1Lt4fgwsnzIB35XWQCgi0hS
Ymu/m2NsXwSdPgRCJx5MVQM=
=ES0o
-----END PGP SIGNATURE-----

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to