Create_tmp_table_priv - how to grant? - solved
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 with what I'm sure is some dumb mistake on my part" ... hit send message, 5 seconds later I found the solution. :) Sorry! __ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Create_tmp_table_priv - how to grant?
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 mydatabase.* to [EMAIL PROTECTED]; but it doesn't work : ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Create_tmp_table_priv on mydatabase.* to [EMAIL PROTECTED]' Am I missing something really obvious here? This is on 4.0.18-standard. The server is an upgraded 3.23.x not a clean 4.0.x install. Possibility of something old causing this to break? Thanks in advance... __ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
flush-hosts problem with 3.23.58 rpm?
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 a previous version (we may have been a few releases behind 3.23.x before we upgraded). I am seeing this all over the place and have not been able to figure out why. In lieu of an fix, can anyone recommend good ways to prevent it? Right now I just run flush-hosts from cron every 15 minutes but I do not like this messy solution (plus even running it every 15 minutes we get frequent problems still). Any ideas or advice? Thanks! __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql processes
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 setup. Today I noticed a high load, and checked things out with: mysql% show processlist; it showed 6 processes running: [ I'll skip all the ascii output since it usually ends up garbled] 6 rows in set (0.00 sec) however if I do: ps axuw | grep "mysql" | wc -l I get: 28 What is going on here? Do I have 28 mysqld's waiting around for requests and just 6 actually processes running? Is there any way to regulate this - something similiar to apache's max_clients, min spare server, max spare servers, etc? We often have mysql just totally melt down a server - someone will run a bit query and then all the others start to back-up. We then end up with a ton of queries trying run at once, the load goes to 50 or even 100(!). How can I stop this? Any tips at all on regulating the use of mysql - this is an ISP server so it is very hard to make sure that all usrs are running sensible and well-constructed database schema's. I have tried to contact mysql for consulting but their beginning prices are too high for our modest budget. Does anyone else know of ways to get some help if no one on the list is able to advise? Thanks! __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ho-hum... file descriptors...
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 setting up a Redhat (7.3 and/or 6.2) box for running a large number of databases (and apache). Any advice at all is welcome, pointers to other resources are fine. I've looked around a lot and nothing I try seems to make much of a difference. If you have any advice in general about running larger MySQL installs I would love to hear! What do you do when prep'ing a new MySQL box? All advice is welcome! Thanks! __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php