Hello, I have a mysql (3.23) server running on a linux system. The server has several databases belonging to the (unix) user who created his database. So each Student may create his own database and usually only he himself may access/modify the data in this database. This creation of a new database is done by a web interface executed as the mysql-root user. The problem now is, that sometimes a database should not only be accessible by the owner himself but also by another user protected by a password. So the owner "x" of a database wants to do this: $ mysql -h mysqlserver -u x -p xyz mysql> grant select on dbOfUserX.* to otherUser identified by 'otherPassword'; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' The user "otherUser" does not already exist in the mysql users table. The user "x" has the grant right and just saying: mysql> grant select on dbOfUserX.* to otherUser; works just fine. But user x is unable to allow someone else to access his database with password protection. So the question is, how can the privilege system be set up, so that a user x can allow another user y to access his database by password (different from the password of the user x of course). Another question is, how can I (the db-admin) allow a user to access the mysql-DB (to allow the password change) without allowing him to change passwords of other users that already exist in the mysql user table (having their own databases)? Where is the information stored, that allows a user (execpt for root) to access the mysql database. Thanks for any help Rainer Krienke -- --------------------------------------------------------------------- Rainer Krienke [EMAIL PROTECTED] Universitaet Koblenz, http://www.uni-koblenz.de/~krienke Rechenzentrum, Voice: +49 261 287 - 1312 Rheinau 1, 56075 Koblenz, Germany Fax: +49 261 287 - 1001312 --------------------------------------------------------------------- --------------------------------------------------------------------- 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
