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" to login using the local machine I had to be specific grant all on llcopy.* to ullcopy@'localhost' identified by 'pllcopy'; Only then did the mysql starting command mysql -uullcopy -ppllcopy actually work. Secondly, Take my two PC's KERRY - 192.168.1.113 (Windows 2000) SIAN - 192.168.1.115 (Windows 98) mask - 255.255.255.0 with MySQL installed on machine SIAN. I used the TCP/IP install example on machine SIAN to set up a new user grant all on llcopy.* to ullcopy@'192.168.1.%' identified by 'pllcopy'; I would now expect me to be able to login from machine KERRY using the command mysql -h192.168.1.115 -uullcopy -ppllcopy since they are on the same network. But I get an error telling me that Access is denied to [EMAIL PROTECTED] The only way I could get me to be able to login was to set up a user grant all on llcopy.* to ullcopy@'KERRY' identified by 'pllcopy'; Now it worked. Unless there is a step I am unaware of, this implies that for 4.0.20a I have to set up a user for every computer name I have on a network i.e. If I have 20 PC's and I want a user ullcopy then I have to create 20 "ullcopy" users which cannot be correct. I also tried grant all on llcopy.* to ullcopy@'%' identified by 'pllcopy'; but I still got access denied. I also tried it with the MySQL server running on my Windows 2000 and Windows XP (Pros). All with the same results. Can someone help me please Kerry
