>> 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? > Sorry, wasn't clear. I used my-large.conf as the template for my.cnf. First tried the file in mysql data dir, then in /etc.
>> >> 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 > Thanks. Guess it is reading the file (output is below) but not behaving the way I expected. Users without permissions to can see the mysql db using SHOW DATABASES (though they can't access any tables, they can USE it). Is this correct behaviour or am I missing something. mysqld --print-defaults ./bin/mysqld would have been started with the following arguments: --port=3306 --socket=/tmp/mysql.sock --skip-locking --key_buffer=256M --max_allowed_packet=1M --table_cache=256 --sort_buffer_size=1M --read_buffer_size=1M --myisam_sort_buffer_size=64M --thread_cache=8 --query_cache_size=16M --thread_concurrency=8 --safe-show-database --safe-user-create --skip-networking --log-bin --server-id=1 -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Development/Promotion Mac Consulting/Sales http://www.systame.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
