"Yves Goergen" <[EMAIL PROTECTED]> wrote: > I'm wondering if I can set safe_show_database on my Windows 2000 MySQL 3.23.56-nt. > Here's what I did: > > --- (c:\winnt\my.ini) > [mysqld] > set-variable = safe_show_database=1 > --- > > -> NT Service didn't want to (re)start anymore.
You should specify: [mysqld] safe-show-database > > --- > mysql> show variables like "safe%"; > +--------------------+-------+ > | Variable_name | Value | > +--------------------+-------+ > | safe_show_database | OFF | > +--------------------+-------+ > 1 row in set (0.00 sec) > > mysql> set session safe_show_database=ON; > ERROR 1064: You have an error in your SQL syntax near 'safe_show_database=ON' at > line 1 > mysql> set session safe_show_database; > ERROR 1064: You have an error in your SQL syntax near 'safe_show_database' at line 1 > --- > > So why doesn't this work? I have successfully set the variable on my Linux box (same > MySQL version): > > --- (/etc/my.cnf) > [mysqld] > safe-show-database > --- > > Isn't this feature available on Windows? Available, but your definitions on Linux and Windows are different. >At least I've found nothing in the doc that would say so. > Ok, I couldn't set it to OFF on my Linux either, inside the mysql shell. That's > another point, why can't I set a mysql variable with SET command? What the heck is > going on in there? You can't set this option with SET command. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
