RE: Creating a New User - What am I doing wrong?
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]
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]
Creating a New User - What am I doing wrong?
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
RE: What am I doing wrong????a
Thanks. I think your help is what I needed & is highly appreciated. Kirti -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 4:22 AM To: [EMAIL PROTECTED] Subject: Re: What am I doing wronga "Kirti S. Bajwa" <[EMAIL PROTECTED]> wrote: > Hello List: > > Please point to what am I doing wrong: > > I am trying to install MySQL on top of RH9. I am following steps outlined > MySQL official documentation from Section 2.3.1 titled "Quick Source > Installation Overview". These are the steps I have performed: > > # cd /usr/local > > Note: on RH9 group (mysql) & user (mysql) are already there.. > # gunzip mysql-standard-4.0.17-pc-linux-i686.tar.gz > # tar -xvf mysql-standard-4.0.17-pc-linux-i686.tar > # cd mysql-standard-4.0.17-pc-linux-i686 > > NOW THE PROBLEM > = > According to the instructions, my next step is: > > # ./configure --prefix=/usr/local/mysql > > But I get a message that "./configure" is already done...". > > This is where I am struck-up for the whole day. Can someone help to direct > me to the right direction. mysql-standard-4.0.17-pc-linux-i686.tar.gz is a binary distribution. You should download source or install MySQL from binary distribution. -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What am I doing wrong????a
"Kirti S. Bajwa" <[EMAIL PROTECTED]> wrote: > Hello List: > > Please point to what am I doing wrong: > > I am trying to install MySQL on top of RH9. I am following steps outlined > MySQL official documentation from Section 2.3.1 titled "Quick Source > Installation Overview". These are the steps I have performed: > > # cd /usr/local > > Note: on RH9 group (mysql) & user (mysql) are already there.. > # gunzip mysql-standard-4.0.17-pc-linux-i686.tar.gz > # tar -xvf mysql-standard-4.0.17-pc-linux-i686.tar > # cd mysql-standard-4.0.17-pc-linux-i686 > > NOW THE PROBLEM > = > According to the instructions, my next step is: > > # ./configure --prefix=/usr/local/mysql > > But I get a message that "./configure" is already done...". > > This is where I am struck-up for the whole day. Can someone help to direct > me to the right direction. mysql-standard-4.0.17-pc-linux-i686.tar.gz is a binary distribution. You should download source or install MySQL from binary distribution. -- 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]
What am I doing wrong????
Hello List: Please point to what am I doing wrong: I am trying to install MySQL on top of RH9. I am following steps outlined MySQL official documentation from Section 2.3.1 titled "Quick Source Installation Overview". These are the steps I have performed: # cd /usr/local Note: on RH9 group (mysql) & user (mysql) are already there.. # gunzip mysql-standard-4.0.17-pc-linux-i686.tar.gz # tar -xvf mysql-standard-4.0.17-pc-linux-i686.tar # cd mysql-standard-4.0.17-pc-linux-i686 NOW THE PROBLEM = According to the instructions, my next step is: # ./configure --prefix=/usr/local/mysql But I get a message that "./configure" is already done...". This is where I am struck-up for the whole day. Can someone help to direct me to the right direction. Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
