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]
