-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Egor, et al --
...and then Egor Egorov said... % % 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. ... % > grant all privileges on wc_jpo.* to wcjporoot identified by 'pass' % > with grant option ; % > flush privileges ; ... % > % > 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; Son of a gun; there is one there (two, actually; one is 'localhost' and the other is the host name). And I'm in! So is that user a common problem, then? How was it created? And do I like the one for the hostname entry? Thanks & 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) iD8DBQFAYFFyGb7uCXufRwARAuAXAKDFcV1e//jhn3Yh/7/9dyQcObjZqgCfYGPg hxKWLNstuhXBm/44fnrqx2g= =BNdM -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
