DEV Community

Cover image for Installing MySQL Workbench And XAMPP on Ubuntu-18.04 and higher
Flovet-stack
Flovet-stack

Posted on

Installing MySQL Workbench And XAMPP on Ubuntu-18.04 and higher

What is MySQL Workbench?

MySQL Workbench is a cross-platform graphical user interface tool used for MySQL database management. Mainly, this tool is used by database architects, administrators, and database developers to visualize the design of the database.

Step 1:

  • Download MySQL workbench from the below URL https://dev.mysql.com/downloads/Workbench
  • Select your operating system
    Alt Text

  • select a suitable version for your operating system
    Alt Text

  • After selecting the version that suits your OS, click download. On the next page, click “No thanks, just start my download”
    Alt Text

Step 2:
Once the download is completed, you click on the downloaded file in the directory which you saved it.
A page like this will open, which is a re-direct of the workbench file in the Ubuntu App Store.
Alt Text

Step 3:
Once the installation process is complete, launch workbench using the app launcher.
Alt Text

Now let’s proceed to install XAMPP on Ubuntu 18.04 or higher

What is XAMPP?
Alt Text

XAMPP is the most popular PHP development environment
XAMPP is a completely free, easy to install Apache distribution containing MariaDB, PHP, and Perl. The XAMPP open source package has been set up to be incredibly easy to install and to use.
Reference ===> https://www.apachefriends.org/index.html

Step 1:
Select the version you want to download specific to your OS.
Alt Text

Step 2:
Open your terminal and navigate to the folder where you downloaded the XAMPP installer
Alt Text

Step 3:
write the following code into the terminal and input your password when you are prompted to
Alt Text

You can then proceed with the installation process

Top comments (3)

Collapse
 
alyatek profile image
alyatek

I'm no one to tell how you how you should do things, but installing XAMPP on Ubuntu is the same thing as having Windows and installing XAMPP, which makes having a linux machine rendered useless.

The big purpose of having a linux machine is that you can install everything independantly and configure everything your way, installing that software takes that away.

I recommend you learning how to install the LEMP, or LAMP stack, so in the future you have more freedom and knowledge about the main services that make your website run.

Collapse
 
flovetstack profile image
Flovet-stack

Thanks very much for your opinion and I understand your point very much which just leads us to the "XAMPP or LAMP" debate.
In my opinion, the decision depends on the individual and his needs, and personally, I will go for XAMPP, because I know installing LAMP gives you that freedom but then again XAMPP is a cross-platform package that comes with Apache, PHP, and MySQL plus it can also be used to configure LAMP(or WAMP on windows and MAMP on Mac)

Collapse
 
traore19 profile image
traore19

waouh,thanks