471,117 Members | 1,230 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,117 software developers and data experts.

rights to create table, select, then drop table..

I have a need to get data from the db that requires me to=20

1) do a select and create a new table with the results=20
2) run a query against that new table=20
3) drop the new table=20

I have a script on my server that does this using the root account that
has all on *.* for the db. It works fine.=20

I now want to get these results on a web page.=20
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.=20

what priviledges do I need to give that user?=20

currently I have the following but the user can't even log into the db
from the command line..=20

mysql> show grants for user;=20
+-----------------------------------------------------------------------
---------+=20
| Grants for user@% |=20
+-----------------------------------------------------------------------
---------+=20
| GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY PASSWORD
'6fe4c0ab2cf30ae3' |=20
| GRANT SELECT, INSERT, UPDATE, CREATE, DROP ON `db1`.* TO 'user'@'%' |=20
+-----------------------------------------------------------------------
---------+=20
2 rows in set (0.00 sec)=20

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/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 2086

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by david | last post: by
reply views Thread by Engwar | last post: by
2 posts views Thread by Karen Sullivan | last post: by
2 posts views Thread by joshsackett | last post: by
2 posts views Thread by masri999 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.