Hey just as it says, id like to create a user (that parts done) and LIMIT them to access rights for ONE database only...how do I go about doing this? is it possible?
set permissions in their profile then check it when they try to use other databases. simple.
You do this when adding users. You can limit databases and/or tables in your GRANT statements.
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Adding_users
