Hello.
If you want to have a complete understanding of how MySQL access privilege system works, read this chapter of the manual: http://dev.mysql.com/doc/mysql/en/privilege-system.html James <[EMAIL PROTECTED]> wrote: > I had set up the following > > I have a MYSQL server running on let's say 123.xx.xx.xx > > User: user1 > Host: 111.xx.xx.xx > > and gave that user the appropriate priveleges. > > > So. I tried to connect to the MYSQL server from 111.xx.xx.xx using > user1, but it won't allow my to. > > I then had to add this entry: > > User: user1 > Host: % > > > Now I'm allowed to access the MYSQL server. Doesn't % open it up to > all clients wanting to connect? I want to restrict which machine can > connect to the server. How do I do that? > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
