Hi all, 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. --- 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? 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? -yves -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
