1

I'm a spoilt windows user and always have used a WAMP stack with a GUI that allows me to start or stop apache and mysql services. I find it really hard switching to the LAMP command line and was wondering if any of you could share some information.

I have been using the bitnami linux install and with regard to stability, its absolutely horrid!

Thanks in advance for the help!

Best,

Improve this question
1

5 Answers 5

Reset to default
3

This is so easy. Using it in Ubuntu 14.04 LTS and it's working without a hitch:

enter image description here

  1. Create a new file via terminal by running the command below

    gedit ~/.local/share/applications/lamp.desktop

  2. Copy and paste this text inside

    [Desktop Entry]
Name=LAMP
GenericName=LAMP
X-GNOME-FullName=LAMP
Comment=Open services of your LAMP server
Exec=gksu service apache2 start && gksu service mysql start
Icon=emblem-web
Terminal=false
Type=Application
StartupNotify=true

X-Ayatana-Desktop-Shortcuts=Start;Stop;Restart

[Start Shortcut Group]
Name=Start
Exec=gksu service apache2 start && gksu service mysql start
TargetEnvironment=Unity

[Stop Shortcut Group]
Name=Stop
Exec=gksu service apache2 stop && gksu service mysql stop
TargetEnvironment=Unity

[Restart Shortcut Group]
Name=Restart
Exec=gksu service apache2 restart && gksu service mysql restart
TargetEnvironment=Unity

  3. Drag and Drop onto the launcher by navigating to ~/.local/share/applications/ in Nautilus.

Source: What Custom Launchers and Unity Quicklists are available?

Improve this answer
0

We have two GUI's available

  • To have MySQL GUI you can install and use phpmyadmin. To install 

    sudo apt-get install phpmyadmin

    With this you can manage MySQL database in GUI way.

  • To have Apace GUI you can use rapache , with this tool you can manage both local & remote connections.

      sudo apt-get install rapache
Improve this answer
3
  • Rapache is not available - E: Unable to locate package rapache
    – Parto
    Jul 10, 2015 at 20:15
  • version of Ubuntu @Parto ?
    – Raja G
    Jul 11, 2015 at 9:31
  • Ubuntu 14.04 LTS
    – Parto
    Jul 11, 2015 at 11:02
0

To the best of my knowledge, phpMyAdmin doesn't allow for the starting/stopping of the mysql service. The MySQL Workbench app is a GUI and does allow for remote MySQL Server administration, including starting and stopping the server and many other functions. I run it on my Ubuntu workstation for running queries, creating dbases and tables, user admin, and managing backups of mysql.

The command line is actually easy to use for starting and stopping services like Apache and mysql:

sudo service apache stop will stop the process.

sudo service apache restart will restart the service (loading any new configs).

sudo service apache start will start the service.

Replace apache with mysql in the command for the same functions.

Improve this answer
0

I concur with douggro as I am a fan of command line. However, there is python-based app that I use it with so much benefit for my other purposes when using my server. You could run this app right off your browser even if apache is not up.

Webmin

 wget http://prdownloads.sourceforge.net/webadmin/webmin_1.660_all.deb 
 sudo dpkg -i webmin_1.660_all.deb -y

Since you are using WAMP stack, this probably is beneficial for you as well -who knows.

Usermin

 wget http://prdownloads.sourceforge.net/webadmin/usermin_1.560_all.deb
 sudo dpkg -i usermin_1.560_all.deb -y

You can control MySQL and even more functions. It has the feature where you are looking for in controlling with restarting feature.

Improve this answer
1
  • Webmin provides everything Usermin does.
    – Kaz Wolfe
    Sep 10, 2014 at 0:14
0

You could use xampp which works pretty much in the same way as wampp, it even has an installer!

https://www.apachefriends.org/index.html

Improve this answer
1
  • How is this better than the other solutions?
    – Kaz Wolfe
    Sep 10, 2014 at 0:14

Not the answer you're looking for? Browse other questions tagged .