$ sudo nano /etc/apache2/apache2.conf

Add the phpmyadmin config to the file:
Include /etc/phpmyadmin/apache.conf

then restart apache:
$ sudo service apache2 restart

and you are ready to go

sudo /etc/init.d/apache2 restart
* Restarting web server apache2 AH00558: apache2: Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1. Set the ‘ServerName’ directive globally to suppress this message

The php.ini file had a typo, so when I searched for extension=myphp.so it was not found because the line really had ‘extension=mphp.so’

Otherwise no problems. Easier than I remembered things going back when I installed AMP on Windows XP a few years back!

That’s not quite true, it depends on the DocumentRoot in apache2 site configuration.

If you define DocumentRoot as /var/www then it will be /var/www not/var/www/html.

By the way, when you type “localhost” to test the apache installation, it will go to the file /var/www/html/index.html – only firefox does not show the complete url in the browser bar – that is why it is easy to overlook, where the root of the webserver is …

I guess it took me a two or three hours trying various other options, before I found the solution. My guess is that the apache directory for web root changed a while ago, and so this looks as if php install is not working, but it is. If the writer of this tutorial mysoomro could change it to the new root, that could be most useful …

I hit the obstacle, that in the above instruction the test file is not created in the directory, where the apache server has its root …

The root is not in /var/www – but in /var/www/html !!
This can be seen or set differently in the /etc/apache2/sites-available/000-default.conf file, where apache gets its directions from.

That cannot work, right? Either create the file in the test procedure above in the right directory, or copy it with sudo cp into the root directory /var/www/html …

Happily found that one out, so simple. Did not find that hint on the web, so I wanted to add it here. Maybe others can benefit from it. Go mint.

sudo gedit /var/www/html/testphp.php

Or copy the file testphp.php into the directory “html”
This is the root directory for the apache server – at least it was in my MATE 14.2 installation, when I had followed all of the above steps.

I’m not criticizing the tutorial, just suggesting that rather than using APT directly, it may be easier to use the Software Manager.

Check the permissions of the files in /etc/apache2 using “ls -l” from a terminal window (of course, you have to be *inside* the directory for that to help you! )

If the “httpd.conf” file’s permissions are different, make them the same and then try again.

Another note that I discovered while trying to install WordPress, (and this may be the same for other installed apps in your web server’s “www” directory).
**You must change the user and group of all these files to be the default “apache2″ user, or you will get strange and bizarre errors involving permissions.

The way you do this is:
First: Go to your /etc/apache2 directory and there should be an apache2.conf file there.
(Note that I do **NOT** have my box up or open right now, so I am doing this from memory!!)

Second: Somewhere in that file, down near the bottom I think, should be something that mentions the default user name. In my case it was something like “www_data” or “www_user” (or something like that, again, I’m doing this from memory)

Third: Once you discover what that default user is, chown everything in your /var/www directory – and all subdirectories – to that user.

Viz.: (as root, or “sudo” all these commands)
“cd /var/www” (or wherever your web root directory is.)

Note that before executing the next command, you **must** be within the /var/www directory, or wherever your web root directory is!

“chown -R www_data:www_data ./*”

The “-R” tells chown (change owner) to recursively go into every sub-directory and make changes there too.

The “www_data:www_data” tells chown to change the user:group to www_data, or whatever your apache default user is, though my money’s on it being something like “www_data”

The “./*” part tells chown to start *in the current directory*, and change *everything there* If you remember, the “-R” tells it to keep going into all the sub-directories underneath “./” – the current directory – and change that stuff too.

Bottom line, if you run into weird issues, make sure you check ownership and permissions in each directory for all files you make, since “sudo” and root make files with “root:root” as the owner.

What say ye?

Jim (JR)

I did not have any major problems with installing the following stack.

Linux Mint 16
Apache 2.4.6
MySQL 5.5
PHP 5.5.3-1ubuntu2.3

Here are a few notes, some reiterating what other commenters have already said but still current as of the above versions.

I’m very new to Linux, so I’d appreciate others correcting my misunderstandings of how things work under the hood.

—–
(a) Enabling the PHP extension mysql.so

Installing MySQL 5.5 appears to take care of this through the *.ini files found in /etc/php5/apache2/conf.d so that there’s no need to hand edit the php.ini file to activate this extension as well as others.

—–
(b) libapache2-mod-auth-mysql “is not available …”

While installing phpMyAdmin using the command,

# apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin

got the error msg that libapache2-mod-auth-mysql “is not available …” etc etc.

So I installed without it. So far the stack seems to be working fine without that package.

—–
(c) Browsing to the url http://localhost/phpmyadmin

Installing phpMyAdmin apparently created the file

/etc/apache2/conf-enabled/phpmyadmin.conf

which aliases the url to /usr/share/phpmyadmin

—–
(d) Setting the MySQL root password.

During the install of MySQL, a keyboard-based dialog box popped up in the terminal window to prompt for a password for the root user. So there’s no need at all to set the password after the install by using the mysql command line utility.

—–
A very nicely written tutorial with some good details and explanations.

A couple of additional notes that you might want to include:

1. I did the steps in ths tutorial *before performing ANY updates* on my system after a fresh install, since I noticed that the update mamager wanted to update Apache2 – and I didn’t know if that would help or hinder. Maybe it does not matter, maybe it does, I don’t know. What I *DO* know is that it worked when I did it this way.

2. After installing Apache2, it’s a virtual certenty that you will get a “Could not reliably determine the server’s fully qualified domain name, using 127.0.0.1 for ServerName” error.

The fix is easy, just “sudo gedit /etc/apache2/httpd.conf”, and add the one line “ServerName (whatever your hostname is)”. Don’t include the quotes, (Doh!), and replace “(whatever your hostname is)” with the name you gave to your computer when you set it up. If you don’t remember, just type “hostname” in a terminal window, and it will tell you.

Restart Apache2 and this annoying warning goes away.

3. In my case, (Mint 13, Mate), there was no need to edit the /etc/php5/apache2/php.ini file. The commented line was not there, and apparently was not needed, since phpAdmin works anyway.

4. When you go to install phpMyAdmin, it will ask you to create a database for phpMyAdmin to play with, and I selected “Yes”. It asks for the password for the “administrative user” – and it sounds like it wants to create another password for yet another user. What it *really* wants is the password you created for the root user when you installed MySQL. If you get this wrong, you get a really scary warning. If you get that warning, just allow it to “retry”, and carefully type in the root password you created before.

5. I did not have to do anything to configure Apache2 to work with phpMyAdmin. It worked wonderfully right out of the box.

6. I noticed that phpMyAdmin *does not require any credentials* to access the MySQL databases! Maybe that’s a result of the database I created before, I don’t know. It *IS* scary!

In any event, I feel like I should send you a case of the finest Kentucky Sour-Mash Bourbon Wiskey – you saved me so much grief!

Thanks a LOT!

Jim (J.R.)

A+A =A over A

It helped me a lot and now I can build web sites with Joomla in my Linux mint!!!

Thanks again!!! Cheers!!!

@nisan92: I guess @Chet replied to your question very well.

Well done, good tutorial.

After you complete the above tutorial, you will now have a new folder called /var/www/. This is where you will put your site. I personally use the LAMP stack to run a local version of WordPress on my machine.

I install the latest version of WordPress right in the folder /var/www/.

I can then build the site and test various code changes and plugins “before” I FTP the site up to my web server. I hope this answers your questions.

eg 1 – when I installed MySQL from the command line, it failed .”..unable to fetch some archives…suggest you run (sudo) apt-get update”
The apt-get update seemed to be OK, but the tests later showed that MySQL was not present on my PC. So I took the easy way out and installed from the package manager, which worked with no problems.
eg 2 The tutorial recommends some changes to the phpini file to work with SQL, but my phpini file is not as described. Hope it doesn’t matter, or I can fix it.

Index of /

Name Last modified Size Description

I installed Apache2 through webmin; the command line supplied by webmin was:
apt-get -y –force-yes -f install apache2
No password was requested, but the installation went fine since I got “It works!”.
How could I make sure that there is a password and that it is not some kind of default password?

sudo chown -R /var/www

Thanks for this tutorial.

[Test on Mint Nadia MATE]

sudo apt-get install filezilla

or you can download it from this link:

http://community.linuxmint.com/software/view/filezilla

just click on install.
@stleon: thanks buddy!

http://www.webhostingtalk.com/showthread.php?t=875255 

MySQL: Error 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO): 

I also tried ‘sudo mysql -u root’ but got same result. Any help will be appreciated.

http://community.linuxmint.com/tutorial/view/244

You can find location of httpd-vhosts.conf file from httd.conf it is normally in apache/conf/extra.

<?php phpinfo(); ?>
not
<!–?php phpinfo(); ?–>

But I noticed this error long ago and corrected it twice.. If you look at the older comments you’ll find out.. But I don’t know why it’s changing again and again. I think some other codes are messing up with the codes in this tutorial..

Sorry for inconvenience.

Yeah, Test PHP instructions are still, or perhaps again screwy.

sudo gedit /var/www/testphp.php opens up a file called testphp.php, not phptest.php as you have written. And the file needs to contain this:

<?php phpinfo(); ?>

not this:

<!–?php phpinfo(); ?–>

And for those looking for ;extension=mysql.so in php.ini
search for this without the ; as it is spaced well apart from the rest and you’ll be able to find and uncomment it. (Which is what removing the semicolon does.)

I needed manuka’s comment to get phpmyadmin to work. Also, while it may seem obvious, phpmyadmin login is root plus the password created during the mysql install.

i work on LAMP last 3 Days.
I m working Linux Mint Katya 32bit
i also tries Mint community, ther Mr Collin helped me..

I want create DB for Drupal

But face probelem in log in of localhots/phpmyadmin
error : #1045 Cannot log in to the MySQL server

when i found i completely remove the mysql-server, PHP5,Apache2
and then follow the instruction given by u.
Start was ok,but the commend does not show any thing

http://localhost/testphp.php

After that there is no content for ;extension=mysql.so

i still finding another solution..

Help me to sort out..

Regards,
Younis

Try using SCP Client for Mac
Transmit http://www.panic.com/transmit/
or filezilla or cyberduck.

If you want to setup FTP following link might help you in this regard.

http://community.linuxmint.com/software/view/vsftpd

https://security.appspot.com/vsftpd.html

http://www.unixmen.com/linux-tutorials/475-insall-vsftpd-in-ubuntu-

Got a question though, how can I set up FTP accounts within Mint/LAMP to allow access (uploading of files {plugins etc for the wordpress sites on there} for use on them – I also have this installed on a local PC, but do my site coding in Dreamweaver on a mac (on same local network).

Thank again. Mark

Type the following command to open up your apache2.conf file:
gksudo gedit /etc/apache2/apache2.conf

Add the following line of code inside apache2.conf:
Include /etc/phpmyadmin/apache.conf

Now restart Apache:
sudo /etc/init.d/apache2 restart

Done. I can’t claim credit for this and is documented on a few LAMP installs round the place

It should read
<?php phpinfo(); ?>

instead of
<!–?php phpinfo(); ?–>