468,770 Members | 2,392 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,770 developers. It's quick & easy.

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 2014

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
reply views Thread by zhoujie | last post: by
1 post views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.