Check out the GRANT syntax in the manual. I don't see where you granted any privileges.
Kevin Tsay wrote: >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 > > > > --------------------------------------------------------------------- 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
