Nestor: I've set the password for root and granted privileges to it.
see below: mysql> select * from user where user='root'; +-----------+------+------------------+-------------+-------------+--------- ----+-------------+-------------+-----------+-------------+---------------+- -------------+-----------+------------+-----------------+------------+------ ------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-----------+------+------------------+-------------+-------------+--------- ----+-------------+-------------+-----------+-------------+---------------+- -------------+-----------+------------+-----------------+------------+------ ------+ | localhost | root | 005a1506376eec48 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | stargate | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | +-----------+------+------------------+-------------+-------------+--------- ----+-------------+-------------+-----------+-------------+---------------+- -------------+-----------+------------+-----------------+------------+------ ------+ 2 rows in set (0.04 sec) --Kevin -----Original Message----- From: Nestor Florez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:32 AM To: Kevin Tsay Subject: RE: Help on SQLyog Did you set the password for root? did you grant yourself permission on the DB you are trying to access? Nestor :-) -----Original Message----- From: Kevin Tsay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 10:45 AM To: [EMAIL PROTECTED] Subject: Help on SQLyog Dear Listers: I've installed MySQL over my Linux (RedHat 7.3) and SQLyog over my laptop. When I start SQLyog and type in the mySQLHostAddress: 10.0.5.210 User Name: root Password: xxxxxxxx Port: 3306 Itis giving me the error: Host 'kevin.sitesmith.com' is not allowed to connect to this MySQL server. Do I need to setup or change anything on MySQL DB in order for this connection to go through ? Thanks --Kevin --------------------------------------------------------------------- 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
