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
