Can not setup PHPMyAdmin

[hbaker]

Hello, slightly new to php and I am running into problems installing PHPMyAdmin to my server. I modified the config.inc.php file with my hostname, mysql02.powweb.com, as well as all the other required changes. I uploaded all files in ASCII and I chmoded the folder 755. When I try to call phpmyadmin I get this error:

Error

MySQL said:


Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)


Any help would be greatly appreciated!

[Calash]

Check your config.inc.php file, line 63. Put your SQL server name in there instead of localhost and see if that works.

The SQL servers are no longer local to your web server, so you need to put the server name in the config file for it to work.

[hbaker]

Thank you for your response, but I had already entered in my server (mysql02.powweb.com) after looking up this problem and responses on this board. Any other ideas of what it could be?

[hbaker]

Also, I am trying to install OpenAuto Classifieds to my server and the configurator can not connect to the MySQL DB. The strange thing is that using all the same info: hostname, database name, username and password I can connect to the database I have setup fine using MySQL - Front. So, it's there appearantly and my login, server and db name are correct but nothing is able to access it besides MySQL - Front. :(

[HalfaBee]

How about posting the bit of config.inc.php withe the password edited out and maybe we can help you.

HalfaBee

[hbaker]

okay, here it is:

$cfg['PmaAbsoluteUri'] = 'http://www.bakercustomjewelry.com/phpmyadmin';


/**
* Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
* You should use this if and ONLY if the PmaAbsoluteUri auto-detection
* works perfectly.
*/
$cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;

/**
* Disable the default warning that is displayed on the DB Details Structure page if
* any of the required Tables for the relationfeatures could not be found
*/
$cfg['PmaNoRelation_DisableWarning'] = FALSE;


/**
* Server(s) configuration
*/
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
// You can disable a server config entry by setting host to ''.
$i++;
$cfg['Servers'][$i]['host'] = 'mysql02.powweb.com'; // MySQL hostname
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables)
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'hbaker'; // MySQL user
$cfg['Servers'][$i]['password'] = '******'; // MySQL password (only needed
// with 'config' auth_type)
$cfg['Servers'][$i]['only_db'] = 'bakercustomjewelry_db'; // If set to a db-name, only

[HalfaBee]

The only thing I can see wrong is the DB name.
Or did you really name it bakercustomjewelry_db

HalfaBee

[hbaker]

yes, after it would not work I tried renaming the db just for kicks...still no dice. I really don't need to install it I suppose since I am able to use MySQL-Front fine. My main concern now is getting OpenAuto Classifieds installed now, but it can not find the MySQL server. I am not sure if you are familiar with this program, but the only file you need to make updates to is the 'common.php' file and here is a snip from it:

<?php
//common include file

//mysql database setup
$user = "hbaker";
$password = "******";
$db = "bakercustomjewelry_db";
$server = "mysql02.powweb.com";


//OPENREALTY ADMIN PASS AND LOGIN
//DEFAULTS TO MYSQL DATABASE USER/PASS
$openadmin = "hbaker";
$openpassword = "******";

[HalfaBee]

Well you have me stumped.

Make sure the password is correct and remember that case is important.

If you get desperate PM me some ftp info and I will have a look for you.

HalfaBee

[hbaker]

I appreciate the help, and I will keep you in mind as a last ditch effort! Maybe my brain needs some food. I will sit down and try it all again after dinner and see if I have any better luck. It is very frustrating because I have installed all of this fine on other servers and haven't had any problems. Bleh....

Thanks!