I am trying to install AbanteCart cart on yahoo web hosting. Yahoo interfaces with MySQL through phpMyAdmin. I have created a database with a table name AbanteCart with all rights and privileges granted. The version info is as follows
Database server
• Server: mysql via TCP/IP
• Server type: MySQL
• Server version: 5.1.55 - Source distribution
• Protocol version: 10
• User: Mowattm1@localhost
• Server charset: UTF-8 Unicode (utf8)
Web server
• Apache
• Database client version: libmysql - 5.1.55
• PHP extension: mysql
phpMyAdmin
• Version information: 4.0.10.16l
When I call upon AbanteCart installation file index.phb and enter my logon info, local host and database name. I keep getting this error
Name Info
2::warning mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /Custombuiltpc/AbanteCart/public_html/core/database/mysql.php on line 47
Sql query show variables like '%socket%'; results in tmp/mysql5.1.55.10920.sock
I tried using this command
$host = 'localhost:/tmp/mysql.sock';
Where I substituted the socket value
$host = 'localhost:/tmp/mysql5.1.55.10920.sock';
But got a syntax error, tried $hostname, instead of $host and got same syntax error.
Also Did query on
SHOW VARIABLES WHERE Variable_name = 'hostname'
hostname p8db9.geo.ne1.yahoo.com for mysql database
p8db9.geo.ne1.yahoo.com same for AbanteCart
When I entered the above as local host , I still got database connection and socket error.
Hello.
You should to ask your hosting provider support about it.
Looks like firewall issues between php and mysql apps.
This problem not related to AbanteCart directly. It's a server misconfiguration trouble.
Thanks for responding. Yahoo is currently researching the issue.
In phbmyadmin I entered this sql SHOW VARIABLES WHERE Variable_name = 'hostname'
And got hostname p8db9.geo.ne1.yahoo.com
If I use this as local host, I get the system 111 communication connection error
If I use localhost as host name, I get the socket 96 error
2::warning mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (96) in /Custombuiltpc/AbanteCart/public_html/core/database/mysql.php on line 47