-----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]