DEV Community

Jochem Stoel
Jochem Stoel

Posted on

[Node] phpMyAdmin alternative for Node.js?

#node #javascript #mysql #phpmyadmin

More often than not I still find myself (temporarily) installing some Apache distribution bundle with phpMyAdmin because it is the fastest way to create and manage my application databases.

This has often led me to the idea to write a phpMyAdmin clone/equivalent in JavaScript for Node and/or Electron. It even seems like a fun thing to do but I don't want to waste my time reinventing another wheel.

I have not yet come across a decent/complete replacement for phpMyAdmin yet though. Did you?

Top comments (5)

Collapse
 
bgadrian profile image
Adrian B.G. • • Edited

MySQL Workbench is pretty great, but if you want PHPMyAdmin you do not need to pollute your local env with Apache and PHP if you use docker. All the dependencies will be inside the container, which can be removed or upgraded with one command.

##install the mysql & phpmyadmin 
docker run --name=mysql5 -e MYSQL_USER=iamgroot -e MYSQL_PASSWORD=a -d mysql/mysql-server:5.7 && \
docker run --name phpmyadmin5 -d --link mysql5:db -p 8080:80 phpmyadmin/phpmyadmin

More on hub.docker.com/r/phpmyadmin/phpmya...

After the install you can start/close it as needed

docker start/stop phpmyadmin5
Collapse
 
jsrn profile image
James •

On Windows I tend to use SQLYog Community Edition which provides a pretty good GUI for managing MySQL databases.

I'm interested to hear what GUI tools people use on Linux systems, because I'm yet to find one I like as much as SQLYog or HeidiSQL.

Collapse
 
omulmicsinegru profile image
Ionita Matei Iosif •

When i worked on a Linux box I tried really hard to find a HeidiSQL clone.
The closest thing i found was: dbeaver.io/

Collapse
 
sarbazx profile image
Taskhyn Maksim •

On Mac I use SequelPro

Collapse
 
buinauskas profile image
Evaldas Buinauskas •

How about MySQL Workbench?

Read next

mana95 profile image

Understanding about React Outlet with proper routing

Manoj Prasanna 🚀 -

simonjohansson profile image

Node.js Frameworks Roundup 2024 — Elysia / Hono / Nest / Encore — Which should you pick?

Simon Johansson -

adaobilynda profile image

useReducer and how it is different from useState

Adaobi Okwuosa -

kocreative profile image

After Effects: While Loops

Kat -