David T-G <[EMAIL PROTECTED]> wrote:
> -----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?
When server reads table user, it sorts entries by host, then by user. Entry
''@'localhost' is more specific than 'wcjporoot'@'%'. So it will be find first:
http://www.mysql.com/doc/en/Connection_access.html
> How was it created? And do I
> like the one for the hostname entry?
>
This user is created by default and has permissions only on the database 'test'.
--
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]
