Create_tmp_table_priv - how to grant? - solved

2004-03-24 Thread Hugh Beaumont
Hi List, Ok, I'm a moron... problem solved: Should have been: grant CREATE TEMPORARY TABLES ... and not grant Create_tmp_table_priv ... Well atleast this is now in the archives for search engines to pick up on... I swear I sat there for 10 minutes thinking "Should I clutter the list wit

Create_tmp_table_priv - how to grant?

2004-03-24 Thread Hugh Beaumont
Hi List, I hate to bother the list with what should be a simple question but I've been unable to get this to work or find anything on mysql.com or google. I need to grant : Create_tmp_table_priv on a particular database. As root (mysql user) I tried : grant Create_tmp_table_priv on mydatabas

flush-hosts problem with 3.23.58 rpm?

2003-11-10 Thread Hugh Beaumont
Hi List, I've recently started seeing quite a few errors with MySQL servers I admin, they are all requests to run: mysqladmin flush-hosts The only change I can identify is our upgrade to 3.23.58 (mysql.com provided RPM - running on redhat 7.3) Is anyone aware of an issue with this version or

mysql processes

2003-11-07 Thread Hugh Beaumont
Hi List, I've searched the archives and the web many times in the past for answers to the following questions but never really got a complete understanding of what is going on. Hopefully someone on the list will be able to take the time to set me straight. I have a typical php + mysql + linux s

ho-hum... file descriptors...

2003-01-14 Thread Hugh Beaumont
Hello All, I've read many different methods to expand the number of file descriptors that mysql (and apache) can use. However I've not been able to find the perfect method, many guides seem to be out of date, etc. I am wondering, does anyone have any advice on their own preferred methods of set