Can't connect to local MySQL server through socket , cloud hosting

[rogue0104]

Hello guys , this is real pain for me, i recently moved my website to the cloud hosting after configuring

setting.inc.php.....

..............

<?php
define('_DB_SERVER_', 'localhost');
define('_DB_NAME_', 'mydbname');
define('_DB_USER_', 'myuser');
define('_DB_PASSWD_', 'xxxxxxxxxx');
define('_DB_PREFIX_', '');
define('_MYSQL_ENGINE_', 'InnoDB');
define('_PS_CACHING_SYSTEM_', 'CacheMemcache');
define('_PS_CACHE_ENABLED_', '0');
define('_MEDIA_SERVER_1_', '');
define('_MEDIA_SERVER_2_', '');
define('_MEDIA_SERVER_3_', '');
define('_PS_DIRECTORY_', '/');
define('_COOKIE_KEY_', 'xxxxxxxx');
define('_COOKIE_IV_', 'xxxxxxx');
define('_PS_CREATION_DATE_', '2013-08-24');
define('_PS_VERSION_', '1.5.4.1');

........................................

still getting errror >

 

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) prestashop

 

I was searching for the solution but no success at all.

I dont know how to modify the setting.inc.php file to connect to mysql server

myphpadmin says >

• Server version: 5.0.83-community-log
• Protocol version: 10

Server: "ip of the server" via TCP/IP

 

I tried to put servers IP instead of "localhost" after that, only blank page,..

..also i can see "no privileges" in phpmyadmin, but i didnt even have an option to add the privileges along the mysql db and user setup, so thats another question..how to add privileges via phpmyadmin, is there a syntax I can use to add privileges?

 

any help really appreciated thanks

[rogue0104]

update > after click on the website link i got > Connected to MySQL  now...so its connected to the DB, but how can i reach website to be loading , not this report.

[rogue0104]

here is the error log >

PHP Fatal error: Uncaught exception 'PrestaShopException' with message 'Shop not found' in /usr/local/pem/vhosts/104207/webspace/httpdocs/myshop.com/classes/shop/Shop.php:369\nStack trace:\n#0 /usr/local/pem/vhosts/104207/webspace/httpdocs/myshop.com/config/config.inc.php(90): ShopCore::initialize()\n#1 /usr/local/pem/vhosts/104207/webspace/httpdocs/myshop.com/index.php(27): require('/usr/local/pem/...')\n#2 {main}\n thrown in /usr/local/pem/vhosts/104207/webspace/httpdocs/myshop.com/classes/shop/Shop.php on line 369

[rogue0104]

Well, nobody a single word...anyway I sorted that out,..by changing the permission of cache folder,..so if anybody has the same problem, hope it will be helpful.

Edited April 23, 2014 by rogue0104 (see edit history)