I have just installed XAMPP on my Ubuntu 7.10 box. I have problems with connecting to example databases/tables in the XAMPP instance via MySQL Administrator (which I have also just installed). I haven't changed anything in the XAMPP settings. What settings are required for MySQL admin to connect to the MySQL dbs created by XAMPP? I can see them via phpMyAdmin, so this cannot be an installation failure.
Conditions:
When Connect to MySQL Server Instance window was brought up,
I typed Server Hostname = localhost.
For Username field, I tried all relevant rows I could find in USER table under database MYSQL (as I said above, I can see tables via phpMyAdmin).
Password field is left blank since no pws are set.
Symptoms:
For all combinations of values, the following message is returned:
- Code: Select all
Could not connect to host 'localhost'.
MySQL Error Nr. 2002
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem.
I am prompted to ping the localhost server. The responses I get is endless rows of something like this:
- Code: Select all
PING localhost (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.056 ms
Thank you verrrry much in advance.