Search code examples
mysqlxamppsequelize.jsmysql-workbenchmern

Do I need to install mysql workbench if I already have xampp installed


I am developing web application using MERN stack but instead of using mongo db I am using mysql as a backend database. But do i need to install mysql workbench if I already have xampp installed. because i need to start xampp server for mysql. I am using sequelize library. I am new to the development.


Solution

  • tl;dr: No.


    XAMPP is a bundle which gives you:

    • PHP 7.4.29 , 8.0.19 , 8.1.6
    • Apache 2.4.53
    • MariaDB 10.4.24
    • Perl 5.34.1
    • OpenSSL 1.1.1o (UNIX only)
    • phpMyAdmin 5.2.0

    MariaDB is a database server (compatible with MySQL) which stores and processes data.

    PHP and Perl are programming languages which let you write software which interacts with the database. You need a programming language to do web development which is database driven. Other programming languages are available. You tagged this question which is a library for Node.js which you can use instead of PHP or Perl.

    phpMyAdmin is a database client. It gives you a GUI view of your database. It lets you manipulate the database, examine the content and structure of it, and run queries (including testing queries that you plan to use in the software you are writing with PHP/Perl/etc). This is useful but not necessary.

    MySQL Workbench is also a database client. It does the same job as phpMyAdmin. The feature set is probably a bit different. Like phpMyAdmin, it is useful but not necessary. You might prefer it to phpMyAdmin. You might prefer a different database client entirely (personally I'm rather fond of Beekeeper Studio).