#1  
Old 23rd August 2010, 03:15
kendel kendel is offline
HowtoForge Supporter
 
Join Date: Aug 2010
Posts: 132
Thanks: 4
Thanked 1 Time in 1 Post
Default MySQL +phpMyadmin

I been going off old outdate guides and informaion around the internet and nothing is working

I have 2 Servers
Server A running apache, php, phpmyadmin
Sever B running MySQL

Server A has IP of 192.168.1.110
Server B has IP of 192.168.1.120

I edited /etc/phpmyadmin/config.inc.php

to have these:
$cfg['Servers'][$i]['host'] = 'MySQL IP Address'; // MySQL hostname
$cfg['Servers'][$i]['port'] = 'port number'; // MySQL port
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['connect_type']= 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'username'; // MySQL user
$cfg['Servers'][$i]['password'] = 'password'; // MySQL password


(This par was confusing to I just re-added the line above instead of searching for it all).

Then I set the MySQL vi /etc/mysql/my.cnf to comment out #bind-address = 127.0.0.1
There is another line that most of the guides asked me to comment out but I cannot find that like: # skip-networking

The Next closest match to that is: skip-external-locking

I will assume that is not it and leave it alone....

I keep getting errors for example: "Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly"

Another error was it canno connect because it is not accepting connections from the IP Address of my webserver...

Can anyone help?
Reply With Quote
Sponsored Links
  #2  
Old 24th August 2010, 07:30
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,407
Thanks: 834
Thanked 5,496 Times in 4,326 Posts
Default

1) Post the output of:

netstat -tap | grep mysql

2) Make sure that you created an additional root user record in the mysql User database which allows access from the IP or % and not just from localhost.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 24th August 2010, 13:04
kendel kendel is offline
HowtoForge Supporter
 
Join Date: Aug 2010
Posts: 132
Thanks: 4
Thanked 1 Time in 1 Post
 
Default

Ok thank you I will try...
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
phpmyadmin stops authenticating, mysql does fine isn General 2 8th January 2010 16:57
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
PhpMyAdmin MySql Basics - MySql Connect DankSherman Programming/Scripts 1 10th March 2008 05:29
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
phpmyadmin "Cannot load mysql extension. Please check your PHP configuration" rjamesd Programming/Scripts 4 23rd October 2007 16:27


All times are GMT +2. The time now is 12:29.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.