greenace92 Posted December 10, 2015 Share Posted December 10, 2015 I am trying to setup a local LAMP server at the moment so that I can develop without putting stuff online to see it. I had a problem with mysql, regarding the ip-address I think. The problem is that I can't connect and then I can't finish the installation setup and I end up having to abort installation and then purge the files. I'm not sure what to do, I will look around and try again but if someone knows the quick fix I'd appreciate it. I'm not sure if this is a socket problem. Quote Link to comment Share on other sites More sharing options...
greenace92 Posted December 10, 2015 Author Share Posted December 10, 2015 I'm not sure if this is a standard installation message I've seen before regarding the command apt-get install phpmyadmin Message: The phpmyadmin package must have a database installed... If you are an advanced database administrator and know... Otherwise, you should probably choose this option... Configure database for phpmyadmin with dbconfig-common? This is the order of installations that I follow: apt-get update apt-get install libapache2-mod-php5 apt-get install php5 apt-get install mysql-server apt-get install php5-mysql apt-get install phpmyadmin *here at the moment* then edit apache2.conf by adding this line for phpmyadmin: Include /etc/phpmyadmin/apache.conf So I continue the phpmyadmin by choosing yes regarding dbconfig-common: passwords... Ahh here's the error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Then given option to abort, retry, retry (skip questions), ignore All of my other successful installations have been on virtual private servers that I rent. The only thing I could think of is that I don't have a static ip address, using dynamic as provided by ISP, but not sure if that is the problem in question, will do some research. Quote Link to comment Share on other sites More sharing options...
greenace92 Posted December 10, 2015 Author Share Posted December 10, 2015 Sorry I just realized that this is phpmyadmin problem, not mysql, I suppose if a mod could move this thread that would be helpful, but when creating the thread and reproducing the steps to get to the problem, I initially thought it was a mysql problem. Quote Link to comment Share on other sites More sharing options...
greenace92 Posted December 10, 2015 Author Share Posted December 10, 2015 I've been trying the solutions on this page, haven't fixed it yet http://stackoverflow.com/questions/3694575/phpmyadmin-is-throwing-a-2002-cannot-log-in-to-the-mysql-server-phpmyadmin Quote Link to comment Share on other sites More sharing options...
greenace92 Posted December 10, 2015 Author Share Posted December 10, 2015 Yeah so I guess I got it to work, not sure how I fixed it. I'll try to replicate it again on my other computer. It could be due to an interrupted-install dpkg but not sure. I did edit these lines: $cfg['Servers'][$i]['host'] = '127.0.0.1'; bind-address = 127.0.0.1 $cfg['Servers'][$i]['port'] = '3307'; // MySQL port These are my settings: /etc/phpmyadmin/config.inc.php set to $dbserver set to localhost /etc/mysql/my.cnf set to port = 3307 bind-address set to localhost those look like the main changes Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.