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]
