You need to take a look at the database called mysql.
In it you have:
culumns_priv
db
func
host
tables_priv
user
as tables.
Use the GRANT command to set the USERS, or you can also do an insert
statement like so:
insert into mysql.tables_priv VALUES
('10.129.29.%','ai','httpd','pop_materials','gevery2@localhost','','Select,I
nsert,Update,Delete','')
and that will give the user httpd the Select,Insert,Update,Delete priveleges
on that particular table.
DB's is a bit different, but look at your output from
USE mysql;
DESC db;
commands.
-Original Message-
From: Intercession Tech Support [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 3:09 PM
To: [EMAIL PROTECTED]
Subject: User/database permissions
This is going to be a very basic question, so please excuse me.
I have a MySQL server running, but when I added users I inadvertently
gave them all permissions to everything. They can all access every one
else's databases and make what ever changes they want and even delete.
How do I lock it down where they only have rights to their own?
I don't even know how to view what users are there, much less change
their rights.
I've been looking in the documentation online, but it seems to assume
that I know more than I do.
Thank you in advance.
-MWhitaker
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php