FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


SQL creating limited user





Jamatu
I want to create a limited user to access the databases for my forums and some other things rather than using root (I see this as a security risk). I've been looking around and this is what i've come up with so far, do you see anything wrong with it?

Code:
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,REFERENCES,INDEX,LOCK TABLES,CREATE TEMPORARY TABLES
ON phpbb.*
TO 'admin'@'localhost'
IDENTIFIED BY 'xxxxxxxxx';

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,REFERENCES,INDEX,LOCK TABLES,CREATE TEMPORARY TABLES
ON eqdkp.*
TO 'admin'@'localhost'
IDENTIFIED BY 'xxxxxxxxx';

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,REFERENCES,INDEX,LOCK TABLES,CREATE TEMPORARY TABLES
ON eqbkp.*
TO 'admin'@'localhost'
IDENTIFIED BY 'xxxxxxxxx';
n0obie4life
Seriously, I doubt you can do something like that.

I don't know, but I wouldn't risk it.
Jamatu
I don't mean on this server n0obie4life I mean on my linux server Razz
Jamatu
Nevermind about this now, I used phpMyAdmin to create the user and gave him specific privileges rather than doing it through a terminal, that way I shouldn't make any mistakes and messup the mySQL user table!
rohan2kool
i believe that should work.
Related topics
Windows Vista Official Thread
phpBB in my account?
HTML
do you like the look of my site?
MAC OSX on PC's!!!
How to Block shared network drive accesss for Limited User??
The Best Security?
FreeBSD. My installation exprerience.
which is better?
Flash 8.0.24 in IE
Creating a limited user in Linux
my sql create user problem
Enable Wireless Connection for Limited User account???
How I can clean all data from computer
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.