Jan Kudrman wrote: > Dear Michal, > > I am not sure, but I think you can create an user will all the rights in > "mysql - user" (database - table) - this will solve your problem with full > access to all databases.
I think that the better choice is to use GRAND command: grant all on *.* to 'newuser'@'yourhost' identified by 'somepass'; Above will create user named newuser with all privileges on all databases (including mysql) but without grant privilege (can't create new users). Something like that will create user with all provileges on all dbs and with power of creating new users: grant all on *.* to 'newuser'@'yourhost' identified by 'somepass' with grant option; For more information take a look on GRAND command. > > And then you can use other tables in database "mysql" to define rights of > this user to table "user". > > Have a look to manual pages: > 4.2 General Security Issues and the MySQL Access Privilege System > http://www.mysql.com/doc/P/r/Privilege_system.html > > Regards, > Jan > > > (...) Best Regards, -- Jarek --------------------------------------------------------------------- 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
