Many thanks Paul,
I will read and digest tomorrow in normat daylight hours.
Kerry
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: 09 August 2004 20:55
To: Kerry Frater; "MySQL List"
Subject: Re: Creating a New User - What am I doing wrong?
At 20:25 +0100 8/9/04, Kerry Frater wrote:
>I am using 4.0.20a Windows version downloaded as the binary file with
>Installer built in.
>The system was installed with the "defaults". Nothing was run and the
>default mysqld was allowed to run at start up. I have tried this using
>Windows XP, Windows 2000 Pro & Windows 98.
>
>I am testing the system by using the "mysql" program to insert records from
>the PC machine to the machine where the MySQL installation is.
>
>My manual implies that if I created a user ullcopy with a password pllcopy
>using the syntax
>
>grant all on llcopy.* to ullcopy identified by 'pllcopy';
>
>then it would create a "global" user thoat could log on from anywhere BUT
>whether I am on the local machine or remote machine or if I use the -h
>option then I get an error giving me "ACCESS denied"
This problem goes away if you remove the anonymous-user accounts, as
described here:
http://dev.mysql.com/doc/mysql/en/Default_privileges.html
The reason for what you are seeing is explained here:
http://dev.mysql.com/doc/mysql/en/Connection_access.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]