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.
CodePudding user response：
If you would like to use the workbench, then yes, u need to install it from here.
Otherwise, I would suggest you the phpMyAdmin, it comes preinstalled with XAMPP, which you can access from http://localhost/phpmyadmin. The phpMyAdmin is a data administration tool written in PHP for MySQL where you can view/edit/delete the data - similar to the workbench.
CodePudding user response：
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 sequelize.js 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).
CodePudding user response：
No need actually, MySQL bundle with XAMPP therefore you can straight start MySQL from the panel.