Hello.
You may grant some rights to 'user'@'ip-address' and then if you can connect from that host and your mysql.user table doesn't have additional entries from that host - then this option works. If your MySQL version is newer then 4.0.6, you may execute: SELECT CURRENT_USER(); to be sure. Mauricio Pellegrini <[EMAIL PROTECTED]> wrote: > Is there a way to check whether this option is active or not, while the > server is running? > > Thanks > Mauricio > > > On Tue, 2005-03-08 at 06:39, Gleb Paharenko wrote: >> Hello. >> >> > Is the option well set and in the right place ? >> >> Yes. If your mysqld reads this file (use --defaults-file command line >> option to be sure). >> >> > No.2 >> > This slowness problem could occur also on a server running SuSe Linux >> > 8.2 ? >> >> Usually using MySQL server on Unix gives better results than on Windows. See: >> http://dev.mysql.com/doc/mysql/en/windows-vs-unix.html >> >> >> >> Mauricio Pellegrini <[EMAIL PROTECTED]> wrote: >> > Hi, >> > Sometimes our Internet conection goes down and then all conections via >> > tcp/ip to our the mysql server (v.4.1.5) are slow. >> > >> > I've read in the manual that one could use --skip-name-resolve as a >> > possible solution to this problem under windows. >> > >> > The thing is that I've set this option int /etc/my.cnf in this way >> > >> > [mysqld] >> > port = 3306 >> > socket = /tmp/mysql.sock >> > skip-locking >> > skip-name-resolve >> > >> > >> > but I don't see it in the output from ps aux | grep mysql >> > my questions are >> > >> > No.1 >> > Is the option well set and in the right place ? >> > >> > >> > No.2 >> > This slowness problem could occur also on a server running SuSe Linux >> > 8.2 ? >> > >> > >> > >> > Thanks >> > Mauricio >> > >> > >> > >> > >> >> >> -- 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]
