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

Log to remote: OK, Log into local = NO

forums › forums › SQLyog › Using SQLyog › Log to remote: OK, Log into local = NO

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • February 4, 2005 at 10:33 pm #8777
      mchinn
      Member

      I'm able to successfully log into several remote mysql databases (not within our network) using SQLyog. However I'm not able to log into a MySQL (3.23.58 ) server running RHEL3 on our intranet.

      I've checked the firewall on the server and it will let port 3306 (tcp) in both directions. I'm also able to use phpmyadmin on that box to manage those databases. Here are the settings I've tried:

      MySQL Host Address: 192.168.1.50 (IP address of RHEL server)

      User Name: .xxxxx (user that has ALL permissions)

      Password: xxxx

      Port: 3306 (default)

      Databases: xxxx This is a database that the user has full permissions to

      I'm able to manage the database through phpmyadmin using these exact settings.

      And also, I've check that Apache + PHP4 + MySQL is working properly. I have several test Content Management Systems running OK.

      I'm NOT trying to login using tunneling.

      Ideas? Thanks,

      Michael

    • February 5, 2005 at 6:10 am #16942
      Ritesh
      Member

      This is very strange. Can you connect to the MySQL server using the mysql command line tool?

      I believe you have PHP installed in your local machine and you are connecting to the same MySQL server through PHP. Make sure that the details that you provide in SQLyog is exactly same as what you provide in PHP.

    • February 5, 2005 at 5:31 pm #16943
      peterlaursen
      Participant

      I believe it must be some sort of networking or server problem!

      PhpMyAdmin is running on the same machine as as the MySQL server, so here is no networking issue!

      What happens if you install sqlyog on the machine running the MySQL-server. Can you connect then ?

      Also check that the “skip-networking” parameter is not set in the my.ini -file.

    • February 6, 2005 at 4:57 pm #16944
      mchinn
      Member

      Hmm… Well SQLyog is installed on my workstation (Windows 2000 SP4). From my workstation I'm able to log into several MySQL databases outside our network.

      The database I'm having trouble logging into is sitting in the next room! The server is running RHEL and MySQL 3.23.

      The iptables firewall (on the RHEL box) allows tcp port 3306 in and out.

    • February 6, 2005 at 5:24 pm #16945
      Ritesh
      Member

      Can you connect to the MySQL server using the mysql command line tool?

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