Can someone go through the Grant command with me? I want to be able to give one of my site full privilages.
If anyone can help...
Thanks
James
If anyone can help...
Thanks
James
Jan 6, 2001, 6:27 PM
Veteran / Moderator (6956 posts)
Jan 6, 2001, 6:27 PM
Post #5 of 7
Views: 4478
Install MySQLMan
Use that to edit the 'mysql' table directly.
Then, reload mysql to let the changes take effect. This is the _biggest_ problem. People forget that if you edit the permissions directly you MUST issue a 'reload' command. If you use 'grant' the reload is done automatically, but the syntax is much more complex.
It's really easy to add a user, and set _all_ their permissions to 'n' (except the root user) in the user table. This way, a user exists, but has _no_ access to anything.
Then, go to the database table, and enter that user, and give them permissions to access that database you want to give them access to, and give them the necessary permissions for that database in that table.
That way, your users have acces _only_ to the specific database, and can't do anything else. DO NOT give them "grant" ability (but I think you can do that only in the 'users' table anyway.
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
Use that to edit the 'mysql' table directly.
Then, reload mysql to let the changes take effect. This is the _biggest_ problem. People forget that if you edit the permissions directly you MUST issue a 'reload' command. If you use 'grant' the reload is done automatically, but the syntax is much more complex.
It's really easy to add a user, and set _all_ their permissions to 'n' (except the root user) in the user table. This way, a user exists, but has _no_ access to anything.
Then, go to the database table, and enter that user, and give them permissions to access that database you want to give them access to, and give them the necessary permissions for that database in that table.
That way, your users have acces _only_ to the specific database, and can't do anything else. DO NOT give them "grant" ability (but I think you can do that only in the 'users' table anyway.
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
Jan 10, 2001, 12:34 PM
Administrator (9387 posts)
Jan 10, 2001, 12:34 PM
Post #7 of 7
Views: 4443
The syntax is:
GRANT ALL ON database.* TO user@localhost IDENTIFIED BY 'password'
where database is the name of the database you want to give access to, user is the username and 'password' is the password.
If you use MySQLMan and edit the table directly, then be sure to do a FLUSH PRIVELAGES command (type it into the SQL Monitor) to reload the privelages table.
Cheers,
Alex
--
Gossamer Threads Inc.
GRANT ALL ON database.* TO user@localhost IDENTIFIED BY 'password'
where database is the name of the database you want to give access to, user is the username and 'password' is the password.
If you use MySQLMan and edit the table directly, then be sure to do a FLUSH PRIVELAGES command (type it into the SQL Monitor) to reload the privelages table.
Cheers,
Alex
--
Gossamer Threads Inc.