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();
t
Well, we allready use ip numbers instead of host names in the grant
tables, but after setting the skip-name-resolve startup option
machines with Windows ( any flavor) are still slow when internet
connection goes down.
Still, I cant tell if the startup parameter (skip-name-resolve) has been
accepte
Mauricio Pellegrini wrote:
Is there a way to check whether this option is active or not, while the
server is running?
Not sure why it doesn't show up in "SHOW VARIABLES", but one way
to check would be to see whether the hosts in the "Host" column
of "SHOW PROCESSLIST" are shown as IP addresses or
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 lin
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 r
