I have a need to get data from the db that requires me to 1) do a select and create a new table with the results 2) run a query against that new table 3) drop the new table
I have a script on my server that does this using the root account that has all on *.* for the db. It works fine. I now want to get these results on a web page. I want to create a new db user for my .php web page to use to connect to the db that only has the needed priviledges on that specific db to get the job done. what priviledges do I need to give that user? currently I have the following but the user can't even log into the db from the command line.. mysql> show grants for user; +----------------------------------------------------------------------- ---------+ | Grants for [EMAIL PROTECTED] | +----------------------------------------------------------------------- ---------+ | GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY PASSWORD '6fe4c0ab2cf30ae3' | | GRANT SELECT, INSERT, UPDATE, CREATE, DROP ON `db1`.* TO 'user'@'%' | +----------------------------------------------------------------------- ---------+ 2 rows in set (0.00 sec) when I do a "show grants for user", what should I see to allow what I want? Thanks, Jeff McKeon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]