LAMP and PHPMyAdmin

[nigelrrb]

Hi,

I'm new to Linux having used Windows for years, now trying to switch over, using Mint 8 Helena. I've installed LAMP server via the Terminal using Dataman's very helpful tutorial. Apache works fine, serves existing HTML websites. I can't find any menu items to control Apache, MySQL, PHP or PHPMyAdmin - how do I a) invoke PHPMyAdmin without a menu item and b) get these 4 items into the main menu? I would have installed LAMP via the package manager but the option wasn't available. Any help would be appreciated!

Many thanks,

Nigel.

[DataMan]

Nigel,

Did you install phpMyAdmin (it's in the repositories .. I think)?

If so you will need to point your browser to the (I think) index.php for phpMyAdmin as in this example

Code: Select all

http://localhost/phpmyadmin/index.php

Hope this helps get you started.


I'm at work right now and Windows-disadvantged so I'm doing this from failing memory

-DataMan

[nigelrrb]

Hi,

Many thanks for the prompt response! I had installed phpMyAdmin via the repositories, and I can get the login page exactly as you suggest, http://localhost/phpmyadmin/index.php. There I run into another problem - I can't log in. Where are the PHP files located? I have looked in /var/www/ and they don't appear to be there, and I'm not familiar enough with the Linux file system to know where to look. Sorry to appear a bit stupid!

many thanks,

Nigel.

[DataMan]

Aw rats, you're right! I don't use the phpMyAdmin from the repositories. I now remember that they're putting a symbolic link to another directory. Not sure, but I'd start probing at maybe /etc/Apache2 or /etc/php5.

As an option, you could easily download directly from phpMyAdmin and install into the /var/www area.

-DataMan

[GradysGhost]

When you installed MySQL, you should have been prompted for a root user password. You can log into PHPMyAdmin with the user `root` and whatever password you chose when setting up MySQL.

Restarting Apache and MySQL are pretty easy on the terminal:

Code: Select all

sudo /etc/init.d/apache2 restart
sudo /etc/init.d/mysql restart

You can put either of those commands into a script like this:

Code: Select all

#!/bin/bash
sudo /etc/init.d/mysql restart

Save it as something like restart-mysql.sh, make it executable for your user, then attach that to a launcher in the menu or on a panel. If you need clearer, more detailed instructions on how to do that, let me know.

[DataMan]

You can log into PHPMyAdmin with the user `root` and whatever password you chose when setting up MySQL

Doesn't he have to set the blowfish variable in the phpMyAdmin config file first? Been a while since I was cracking a new install of phpMyAdmin so I might be on the wrong path with this but....

-DataMan