On Mon, 15 Jul 2002 11:58:33 +0200 Jarek Jarzebowski <[EMAIL PROTECTED]> wrote:
> 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). > Such a user CAN create new users (by adding appropriate records in mysql tables). The only trouble is that he cannot do flush-privileges, so users created this way will be valid after the next restart of the database. --------------------------------------------------------------------- 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