Installing on Local and Virtualbox?

[greenace92]

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.

[greenace92]

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.

[greenace92]

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.

[greenace92]

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

[greenace92]

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