The control center doesn't have a command to flush the tables or reload the
user tables.  So the new user won't have access until you do:

mysqladmin -u <some user with authority> -p<password> -h<your db host>
reload

Curtis

Stefan Hinz said:
> Karáth,
>
>> I just have installed the MySQL on a Suse linux.
>> I would like to administrate it from Win2k with MySQL Control Center
>> 0.8.9 beta. But I can't make new user in the control center.
>
> Obviously, you're logged in to the MySQL server as a user who doesn't
> have the privileges to create new users.
>
> If you're connecting from your notebook with an IP that never changes,
> you can (logged in via localhost as MySQL root user) grant the
> necessary privileges:
>
> GRANT ALL PRIVILEGES ON *.* TO 'notebook'@'192.168.1.42' IDENTIFIED BY
> 'vErYsEcReT' WITH GRANT OPTION;
>
> Assuming 192.168.1.42 is your notebook's IP.
>
> Regards,
> --
>  Stefan Hinz <[EMAIL PROTECTED]>
>  iConnect GmbH <http://iConnect.de>
>  Heesestr. 6, 12169 Berlin (Germany)
>  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3
>
>
> ---------------------------------------------------------------------
> 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




---------------------------------------------------------------------
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

Reply via email to