Using the OS X binary dist of mysql 4.0.14.
I put my.cnf in both the data dir and /etc, restarted the server, but it doesn't seem to be reading the config.
I added these options to the my-large.cnf under [mysqld]: safe-show-database safe-user-create
Hmmmm....
In your first paragraph, you say you used my.cnf. In your second paragraph, you say you used my-large.cnf.
So it's difficult to tell what you've actually done. What files do you have in what directories?
And tested with a user who had no privelages to the mysql db, but the db shows up with the SHOW DATABASES command.
Does mysqladmin variables show these options? If not, how can I tell what options are active?
Try:
mysqld --print-defaults
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
