re: re: Remote ServerAccess
Eric, Monday, September 23, 2002, 6:55:57 PM, you wrote: EL Well what if you have a user that you want to give permission to from any EL computer in the domain. EL Such as user: mysqluser with READ|SELECT|UPDATE from anywhere EL in: mydomain.com EL But not from any other domain. Did you check link that I mentioned below? I guess no. You can do it by specifying '%.mydomain.com' in the Host field. EL At 05:17 PM 9/23/02 +0300, Victoria Reznichenko wrote: Patrick, Monday, September 23, 2002, 4:24:13 PM, you wrote: PF I'm just starting out with MySQL. How do you set permission to allow for PF access from a domain or IP. I found this in the docs. I this all I need? PF GRANT ALL PRIVILEGES ON *.* TO monty@% - IDENTIFIED BY 'some_pass' WITH PF GRANT OPTION; Patrick, % in the host field means any host. If you want to allow connection only from certain host for user, you should specify host name or IP adddress, like GRANT ALL ON *.* TO 'someuser'@'ensita.net' IDENTIFIED BY 'soempassword' WITH GRANT OPTION; Some info you can also find here: http://www.mysql.com/doc/en/Connection_access.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Remote ServerAccess
Hello, I'm just starting out with MySQL. How do you set permission to allow for access from a domain or IP. I found this in the docs. I this all I need? GRANT ALL PRIVILEGES ON *.* TO monty@% - IDENTIFIED BY 'some_pass' WITH GRANT OPTION; DBA / Unix Administrator Patrick Fowler Wynit, Inc. 6847 Ellicott Drive East Syracuse, NY 13057 V (315) 437-7617 x2172 F (315) 437-0432 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Remote ServerAccess
Patrick, Monday, September 23, 2002, 4:24:13 PM, you wrote: PF I'm just starting out with MySQL. How do you set permission to allow for PF access from a domain or IP. I found this in the docs. I this all I need? PF GRANT ALL PRIVILEGES ON *.* TO monty@% - IDENTIFIED BY 'some_pass' WITH PF GRANT OPTION; Patrick, % in the host field means any host. If you want to allow connection only from certain host for user, you should specify host name or IP adddress, like GRANT ALL ON *.* TO 'someuser'@'ensita.net' IDENTIFIED BY 'soempassword' WITH GRANT OPTION; Some info you can also find here: http://www.mysql.com/doc/en/Connection_access.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Remote ServerAccess
Follow up question, Well what if you have a user that you want to give permission to from any computer in the domain. Such as user: mysqluser with READ|SELECT|UPDATE from anywhere in: mydomain.com But not from any other domain. Thanks, Eric Lamendola Slingo Inc. And if not, Hey what do I know At 05:17 PM 9/23/02 +0300, Victoria Reznichenko wrote: Patrick, Monday, September 23, 2002, 4:24:13 PM, you wrote: PF I'm just starting out with MySQL. How do you set permission to allow for PF access from a domain or IP. I found this in the docs. I this all I need? PF GRANT ALL PRIVILEGES ON *.* TO monty@% - IDENTIFIED BY 'some_pass' WITH PF GRANT OPTION; Patrick, % in the host field means any host. If you want to allow connection only from certain host for user, you should specify host name or IP adddress, like GRANT ALL ON *.* TO 'someuser'@'ensita.net' IDENTIFIED BY 'soempassword' WITH GRANT OPTION; Some info you can also find here: http://www.mysql.com/doc/en/Connection_access.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php