Re : Help On SQLyog
Even I have tried, SQLyog and MyCC both. MyCC has some interesting features like Blob Editing and Editing Table Properties etc. but SQLyog has some very good features like Multiple Query Execution and Multiple ResultSet in different tabs, which I find usefule manytimes. If you are heavy queries, then I suppose SQLyog is a better option. Karam - Original Message - From: Robert Tam [EMAIL PROTECTED] To: Kevin Tsay [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 11:57 PM Subject: Re: Help on SQLyog Kevin, It sounds like you don't have your MySQL access setup correctly. I am also a newbie to MySQL. I recently experienced the same problem with MyCC, which is similar software to SQLyog. I have both, MyCC and SQLyog, installed and currently comparing and contrasting to see which one I like to use. I used Webmin (a graphical user tool which allows me to configured just about anything in Linux) to configured my MySQL access. You basicall need to set the user's permission to access MySQL from another host or all hosts (the MySQL is set to localhost only). You may need to specify the port 3306 in the /etc/my.cnf file as well. This did it for me. Good Luck! - Original Message - From: Kevin Tsay [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 10:45 AM 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: 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 __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com - 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
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: 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
Re: Help on SQLyog
On Tue, 1 Oct 2002, Kevin Tsay wrote: 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: 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 ? Hi, You need to grant the root user access to your server from the host you're trying to connect from. See the Technical Reference on GRANT statement for help on how to do that. Best regards, Iikka 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Help on SQLyog
Kevin, It sounds like you don't have your MySQL access setup correctly. I am also a newbie to MySQL. I recently experienced the same problem with MyCC, which is similar software to SQLyog. I have both, MyCC and SQLyog, installed and currently comparing and contrasting to see which one I like to use. I used Webmin (a graphical user tool which allows me to configured just about anything in Linux) to configured my MySQL access. You basicall need to set the user's permission to access MySQL from another host or all hosts (the MySQL is set to localhost only). You may need to specify the port 3306 in the /etc/my.cnf file as well. This did it for me. Good Luck! - Original Message - From: Kevin Tsay [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 10:45 AM 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: 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
RE: Help on SQLyog
Check the db table in mysql database. See what that says also, I notice the error was that kevin.smith.com not allowed sould that be [EMAIL PROTECTED] not allowed? Generally you will get kevin@localhost not allowed. Grant priviledges to that user on that machine as [EMAIL PROTECTED] Nestor :-) -Original Message- From: Kevin Tsay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:53 AM To: Nestor Florez Cc: [EMAIL PROTECTED] Subject: RE: Help on SQLyog 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: 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
Re: Help on SQLyog
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: 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
