30-aug-2009

PHP + MySQL
To find out what caused the inability of PHPMyAdmin on Eden, the emulated Alpha, to reach the database on the real one (Diana), I checked whether port 3306 is opened on the Windows environment. I also installed MySQL on the Vista machine, in case the problem was local on that machine.
As it turned out: the Windows installation of MySQL has no problem reaching the Diana one: start a MySQL client on the Windows machine, and connect to the database on Diana proved possible, without a problem. But still, connecting using PHPMyAdmin on Eden still didn’t work.
So I installed MySQL on Eden, following the instructions on the VMS-MySQL wiki, but wasn’t able to login once I changed the passwords, not even from the commandline. So I deleted the database and created a new one, but this time, I did not logout and tried to access it by PHPMyADMIN while the session was still open. It works fine, though now I’m too short in pagefile; I got a message within my interactive session:

mysql>
%SYSTEM-W-PAGEFRAG, page file filling up; please create more space

mysql>

After I disconnected from the session I wasn’t able to login again. Nor did PHPMyAdmin, for some reason.
I may have forgotton something…

So it looks as if connecting over the network, via PHPMyAdmin, doesn’t work yet. Locally, there is no problem (as long as the access isn’t blocked – by the McAfee or Windows firewalls on the laptop). I prefer this to be solved, I won’t need to pass all data from Diana to Eden, to test WordPress….

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.