Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Error No. 2003

forums › forums › SQLyog › Using SQLyog › Error No. 2003

  • This topic is empty.
Viewing 7 reply threads
  • Author
    Posts
    • October 25, 2011 at 9:10 am #12482
      numb3rs
      Member

      Error No. 2003

      Can't connect to MySQL Server on'localhost' (10061)

      I have MySQL and SQLyog on same machine

      Im trying to connect SQLyog to MySQL. Can anyone help me with this

    • October 25, 2011 at 11:04 am #32736
      sathish
      Member

      Hello,

      Please read this FAQ: http://webyog.com/faq/content/23/15/en/error-no-2003-can_t-connect.html

      Note that this is a *connection* error and not an *authentication* error (ie: not because user or password is wrong).

      First you should check for firewall issues and settings in server configurations like 'skip_networking' and 'bind_address'.

      Regards,

      Sathish

    • October 25, 2011 at 4:49 pm #32737
      numb3rs
      Member
      'sathish' wrote:

      Hello,

      Please read this FAQ: http://webyog.com/faq/content/23/15/en/error-no-2003-can_t-connect.html

      Note that this is a *connection* error and not an *authentication* error (ie: not because user or password is wrong).

      First you should check for firewall issues and settings in server configurations like 'skip_networking' and 'bind_address'.

      Regards,

      Sathish

    • October 25, 2011 at 5:47 pm #32738
      numb3rs
      Member

      Sorry repeating post.

      I went into my.ini and tried placing a # in front of skip-network and save changes but I was denied access. I went through MySQL folder directory but not by using MySql. If I need to use MySQL can you provide query which would allow me to make the changes needed or access that

      my.ini and make the Chang.

    • October 25, 2011 at 7:50 pm #32739
      numb3rs
      Member

      How do I get to server configuration?

    • October 25, 2011 at 9:24 pm #32740
      peterlaursen
      Participant

      'server configuration' and 'my.ini' is the same thing

      I f I understand you commented the 'skip-networking' option. Now you are able to *connect* – but not able to *authenticate* . It seems you get another error ' access denied' or 'connection denied'. About this read http://webyog.com/faq/content/23/18/en/error-no-1045-connection-denied.html

      “User is not allowed to connect from the actual host. Note that MySQL by default only allows connection from 'localhost'. To specify from where a user may connect SQL wildcards (% and _) can be used. Simply 'someuser@%' means that user 'someuser' may connect from everywhere.”. If you are connecting from a remote host and the remote user is not created you will have to do with any client that can connect (mysql command line, PhpMyAdmin or whatever). Or alternativley use SSH- or HTTP-tunneling. With tunneling you technically connect from 'localhost'.

    • October 25, 2011 at 10:34 pm #32741
      numb3rs
      Member

      No was not able to comment it out. I went to my MySQL folder….clicked on my.ini (came up as notepad) I put comment in tried to save changes and it said access is denied. So I need to know the correct way to access MySQL configuration. Thanks. I'm a newb.

    • October 26, 2011 at 1:02 am #32742
      numb3rs
      Member

      I used mysql server instance configuration to make changes. Will try to connect

  • Author
    Posts
Viewing 7 reply threads
  • You must be logged in to reply to this topic.