Jump to content

Installing on Local and Virtualbox?


greenace92

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.