Computing.Net > Forums > Linux > PhpMyAdmin cant conncet

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

PhpMyAdmin cant conncet

Reply to Message Icon

Name: djx01dlob
Date: May 16, 2005 at 11:21:01 Pacific
OS: Linux Fedora Core 3
CPU/Ram: 768Meg
Comment:

Hi,

I have just instlaled a clean instalation of fedora core to run as a ftp and web serer.

I am tryign to set up mysql, when i installed i selceted all the mysql options and all teh web server options inclusing php mysql or something.

I also have webmin which reports that mysql server is running, and i have made a username in there sa well as root.

I am trying to set up phpmyadmin, i have downloaded it, un zipped it and ftped it to a folder called phpmyadmin in my /var/www/html folder.

The problem is, is that when i go there, i get the error:

MySQL said:

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

I think i have set up the config fiel right:

ive put in my pmi url to be:
(just for localuse)

"http://10.0.0.10/administration/phpmyadmin"

ANd have entered a blowfish secret, got he auth type on cookie (althpouhg on http no usernames seem to work) and my user naem and password in thee first section.

Any help appreciated

Thanks

Darren

Thanks,



Sponsored Link
Ads by Google

Response Number 1
Name: jimminy
Date: May 16, 2005 at 14:00:32 Pacific
Reply:

What type of socket (socket or TCP) did you setup in the phpmyadmin config? Does the socket exist?


0

Response Number 2
Name: djx01dlob
Date: May 16, 2005 at 14:05:25 Pacific
Reply:

Its set as tcp, is this right?

If not how whould it be set up.

Thanks

Darren

Thanks,


0

Response Number 3
Name: jimminy
Date: May 16, 2005 at 14:12:52 Pacific
Reply:

TCP is fine. do a netstat -an. Is mysql.sock listed?


0

Response Number 4
Name: djx01dlob
Date: May 16, 2005 at 23:20:20 Pacific
Reply:

Hi,

Netstat is not listed, although wen i accidently did netstat -sumthing else mysql was listed as a tcp entry.

Not shore what i did there though.

do i need mysql.sock to work even though im connecting with tcp?

Thanks

Darren

Thanks,


0

Response Number 5
Name: jimminy
Date: May 17, 2005 at 07:55:48 Pacific
Reply:

Yes.

Post the following lines (and their values) from your config.inc.php file:

$cfg['Servers'][$i]['host']
$cfg['Servers'][$i]['port']
$cfg['Servers'][$i]['socket']
$cfg['Servers'][$i]['connect_type']
$cfg['Servers'][$i]['auth_type']



0

Related Posts

See More



Response Number 6
Name: djx01dlob
Date: May 17, 2005 at 11:51:48 Pacific
Reply:

$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$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'] = 'socket'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli')
$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).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user


Thats the liuens form the config file

anything wrong?

DArren

Thanks,


0

Response Number 7
Name: djx01dlob
Date: May 17, 2005 at 11:52:53 Pacific
Reply:

( the connect type is tcp sorri, i was just tring it under socket when i did that, its tcp though, althoug dosnt work on socket either

Darren

Thanks,


0

Response Number 8
Name: djx01dlob
Date: May 18, 2005 at 10:14:34 Pacific
Reply:

Hi,

I ahve changed a few settings in teh cofig fiel and it will now let me try to login but it just sais the username or password is denied, what is cuaing this?

Darren

Thanks,


0

Response Number 9
Name: jimminy
Date: May 18, 2005 at 10:56:04 Pacific
Reply:

Just a guess - wrong username and password?


0

Response Number 10
Name: djx01dlob
Date: May 18, 2005 at 11:25:18 Pacific
Reply:

No, i dont think this i the problem, as the usernaem and pword i have in, works if i go to the command line and type in mysql -u root -p
and put the root password in tehre it work

just wont in phpmyadmin.

What could cause this?

DArren

Thanks,


0

Response Number 11
Name: jimminy
Date: May 18, 2005 at 11:32:56 Pacific
Reply:

Ok.

What settings did you change in the config file? What were their previous values, and what are their current values?


0

Response Number 12
Name: phpien
Date: May 28, 2005 at 02:17:44 Pacific
Reply:

Hi,

I had the same problems and finally this configuration worked for me.

$i++;
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$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'] = ''; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli')
$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).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
// with 'config' auth_type)
$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only


I did not set any connection type and I tried this before setting mysql root password.

You may want to try?


0

Sponsored Link
Ads by Google
Reply to Message Icon






Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Linux Forum Home


Sponsored links

Ads by Google


Results for: PhpMyAdmin cant conncet

Phpmyadmin wont work www.computing.net/answers/linux/phpmyadmin-wont-work/27841.html

Cant compile kernel 2.2.17 help. www.computing.net/answers/linux/cant-compile-kernel-2217-help/2776.html

Apache & Permissions www.computing.net/answers/linux/apache-amp-permissions/27492.html