User priviledges question
Posted 08 September 2006 - 05:16 AM
i.e multible uses on one server creating, editing and removing their own databases with no access to any other databases on the server. And root to have global access to all databases created.
Posted 08 September 2006 - 07:22 AM
GRANT ALL ON `username\_%`.* TO username@localhost; GRANT ALL ON `username\_%`.* TO email@example.com;
Users by default have access to Db 'test' btw.
Posted 11 September 2006 - 01:43 AM
IDENTIFIED BY 'password here'to the end of the GRANT statement or you'll create users with blank passwords.
GRANT ALL ON ... IDENTIFIED BY 'password'
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users