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 =3D safe_show_database=3D1
---
-> 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=3DON;
ERROR 1064: You have an error in your SQL syntax near =
'safe_show_database=3DON' 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/my***********...ie.nctu.edu.tw