Re: I can't make user from the MySQL Control center

[Curtis Maurand]

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

Re: I can't make user from the MySQL Control center

[Stefan Hinz]

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

I can't make user from the MySQL Control center

[Karáth Attila]

Hi,

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. I think, I have to
enable at  the linux consol
that the root (SQL root) could be administrate the SQL server on my
notebook.
What have to I do if I want to administrate SQL server from not localhost ?


-
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