Dear Mike,
read the chapter about the privilege system in the MySQL manual
(manual_Privilege_system.html#Privilege_system)!
You'd better use the GRANT command to grant rights to users (which are
stored in mysql.user) or to users who only have access to special
databases and tables (which are stored in mysql.db). If you manipulate
these tables manually, you will have to use
FLUSH PRIVILEGES
afterwards for changes to take effect.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "Mike Blezien" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 30, 2001 7:19 PM
Subject: Privilege settings
Hi all,
trying to figure out the relationship of the mysql User and db tables.
Now when
a database is created and privileges are assigned to the new db, the db
table is
updated and the user table is updated, but in the privilege columns of
the user
table, all are set to 'N' but the appropriate privileges are set to 'Y'
in the
db table for that particular database.
Is there something I'm missing or doing wrong??
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
---------------------------------------------------------------------
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
