I am in the process of trying to import a fairly large Mediawiki website into a LAMP VA running on VMWare.

I did this about a year ago successfully and used SQLYOG (community version) to import the mysql database because PHPMyadmin has a fairly low limit on importing a database (50 Mb). SQLYOG allowed me to do this without any difficulty

Unfortunately, I now seem to be unable to connect SQLYOG to the LAMP VA.

I am a noob when it comes to LAMP so I am unsure why it worked the last time I did this but now I am unable to connect.

I can run phpmyadmin with no problem using https://[lamp.local.ip]/phpmyadmin, however, when I try to connect SQLYOG I receive the message - "Error No. 2005 Unknown mysql server host https://[lamp.local.ip] (11004)"

Any help would be greatly appreciated.

Thanks

Please read:
http://webyog.com/faq/content/16/66/en/wha...-at-an-isp.html


My best idea is that you remove "https://". As you use the COMMUNITY version you must connect directly. For direct connection to MySQL, protocol descriptors (like "https://" and "http://") does not apply!

Some routing systems on some networks will simply ignore the protocol descriptor if the MySQL port is specified, but not all! And it is theoretically incorrect to specify like "https://" .. SQLyog is not a browser and MySQL is not a Webserver!

I had already tried simply using the IP address but that didn't work. My post on this forum was out of frustration as I tried a number of approaches using the IP address but nothing has worked.

As i indicated, I am running mysql as part of a LAMP virtual appliance under VMWare. My reference to accessing phpMyAdmin was simply to confirm that mysql is running and I can access it using phpMyAdmin.

OK ...

Actually I have myself a Linux system (OpenSuSE 11) running in VirtualBox in WinXP. The Linux has a complete LAMP stack too.

The problem is that the 'guest' ip (and the Linux/'guest' domain name) is not registered anywhere in the 'host' OS. Also the Internet and your LAN/WLAN does not know about the 'guest' OS. But every Virtualisation Manager has some host and guest extensions (to share folders, to share CD drives, USB drives etc). In your case there must be host and guest extensions that allow for http (and https) access from host to guest.

That phpMyAdmin connects is really not at all MySQL related I think. I am sure that you would be able to connect to any website on the 'guest' (phpMyAdmin is basically a website only!). I am correct that phpMyAdmin is installed on 'guest'?



I have one 'workaround' that works for me. I use a dynamic DNS service (www.dyndns.dk). That gives me a private subdomain on dyndns.dk (myalias.dyndns.dk). So when I specify host as 'myalias.dyndns.dk' in SQLyog on 'host' it will connect to the running MySQL server on 'guest' provided that I specify the correct port. (I use 3306 on the 'guest' and 3307 on the 'host', so with host as 'myalias.dyndns.dk' I can connect to both actually - what also lets me copy data, sync etc.).


I will ask those of our guys that have most experience with VMware to help here!

Hi,

Can you please tell me few details like.

1) What is the network type you have chosen under Vmware ? (please see the attached image: network_type )

2) Can you please let us know also the MySQL version in which you are connecting.


I have a MySQL running in VMware which uses a bridged networking, and I am able to make a direct connection with the MySQL server from SQLyog using the guest IP (please see the attached image: sqlyog_config).


Please also refer this link.
http://www.webyog.com/faq/content/23/17/en...erver-host.html

Regards

Supratik