Need a web GUI interface to MySQL
-
@jaredbusch said in Need a web GUI interface to MySQL:
Is phpMyAdmin still the goto for this?
Is there something better?
I use phpMyAdmin for web GUI... but when it's publicly accessible, I don't use a default setup. There's some extra steps in securing it that are often overlooked.
-
nice overview on the editor side .
Also, damn, 3.5 million calls in the CDR since Jan 10, 2013.
-
Never used adminer before... gonna check it out.
It looks like a damn good and more secure replacement.
-
@obsolesce said in Need a web GUI interface to MySQL:
Never used adminer before... gonna check it out.
It looks like a damn good and more secure replacement.
i've not looked at securing.
This is internal only for the moment. jsut needed some quick access tools for testing.
-
I still use PHpmyadmin and has worked well.
-
@jaredbusch said in Need a web GUI interface to MySQL:
@obsolesce said in Need a web GUI interface to MySQL:
Never used adminer before... gonna check it out.
It looks like a damn good and more secure replacement.
i've not looked at securing.
This is internal only for the moment. jsut needed some quick access tools for testing.
If necessary, one can setup basic HTTP authentication using nginx.
-
If it doesn't have to be web based you could use MySQL Workbench - which I think is more capable than the web GUIs.
-
@emad-r said in Need a web GUI interface to MySQL:
For admin stuff, most devs uses mysql workbench its 28 MB and has alot of functionality.
@pete-s said in Need a web GUI interface to MySQL:
If it doesn't have to be web based you could use MySQL Workbench - which I think is more capable than the web GUIs.
Overkill and slow.
-
@emad-r said in Need a web GUI interface to MySQL:
Why do you want to use anything other than phpmyadmin, it is very stable mature project since years, the other alternatives for it are meh, who gives shit if the alternative is single file install.
Because it is bloated piece of crap. I have never liked it. It always seemed too complicated for a basic task.
And it is most certainly not stable. it totally totally broke not that many years back.
-
I use just the CLI client when I can get away with it, phpMyAdmin when I can't. But I admit that it is way too much bloat for something really basic. I prefer MongoDB's GUI manager for most things, but it lacks some basics that you miss from phpMyAdmin.
-
@scottalanmiller said in Need a web GUI interface to MySQL:
I use just the CLI client when I can get away with it, phpMyAdmin when I can't. But I admit that it is way too much bloat for something really basic. I prefer MongoDB's GUI manager for most things, but it lacks some basics that you miss from phpMyAdmin.
Right, I generally just use the CLI and fire some basic queries. But in this instance it was an unknown database structure with unknown amounts of data.
A simple PHP based GUI like phpMyAdmin is really nice for that.
I had never heard of Adminer before, but it is now my 100% go to solution for this.
Just drop the adminer.php and editor.php file in the
wwwroot folder and get a quick glance of what you have or whatever. Then delete them. -
What I like about MongoDB's native management app is that you run it on your desktop, connect to the server over SSH, and it talks to the database over that channel so literally nothing gets installed server side, only client side.
-
@jaredbusch said in Need a web GUI interface to MySQL:
@emad-r said in Need a web GUI interface to MySQL:
For admin stuff, most devs uses mysql workbench its 28 MB and has alot of functionality.
@pete-s said in Need a web GUI interface to MySQL:
If it doesn't have to be web based you could use MySQL Workbench - which I think is more capable than the web GUIs.
Overkill and slow.
It's not overkill if you're a DBA or developer.
And if you're smart you install it on the machine you do admin from and not on each server.
And you did ask for the best... -
@pete-s said in Need a web GUI interface to MySQL:
@jaredbusch said in Need a web GUI interface to MySQL:
@emad-r said in Need a web GUI interface to MySQL:
For admin stuff, most devs uses mysql workbench its 28 MB and has alot of functionality.
@pete-s said in Need a web GUI interface to MySQL:
If it doesn't have to be web based you could use MySQL Workbench - which I think is more capable than the web GUIs.
Overkill and slow.
It's not overkill if you're a DBA or developer.
And if you're smart you install it on the machine you do admin from and not on each server.
And you did ask for the best...Actually, no I did not. Read the OP again. Don’t forget the title of the thread.
A fat client is almost always overkill and slow. But MySQL Workbench is a total piece of crap.
-
@jaredbusch said in Need a web GUI interface to MySQL:
@pete-s said in Need a web GUI interface to MySQL:
@jaredbusch said in Need a web GUI interface to MySQL:
@emad-r said in Need a web GUI interface to MySQL:
For admin stuff, most devs uses mysql workbench its 28 MB and has alot of functionality.
@pete-s said in Need a web GUI interface to MySQL:
If it doesn't have to be web based you could use MySQL Workbench - which I think is more capable than the web GUIs.
Overkill and slow.
It's not overkill if you're a DBA or developer.
And if you're smart you install it on the machine you do admin from and not on each server.
And you did ask for the best...Actually, no I did not. Read the OP again. Don’t forget the title of the thread.
A fat client is almost always overkill and slow. But MySQL Workbench is a total piece of crap.
The web tools you are talking about also requires a web server and a php installation so they're not exactly "thin" but you want something simple on a LAMP server or similar. I get that.
MySQL Workbench has it's place too. It's to MySQL what SQL Developer and Enterprise Manager is to Oracle DB. I find it useful and use it almost daily.
-
Back on site at the client that first prompted me to look into this.
It is such an awesome tool
-
@Pete-S said in Need a web GUI interface to MySQL:
@jaredbusch said in Need a web GUI interface to MySQL:
@pete-s said in Need a web GUI interface to MySQL:
@jaredbusch said in Need a web GUI interface to MySQL:
@emad-r said in Need a web GUI interface to MySQL:
For admin stuff, most devs uses mysql workbench its 28 MB and has alot of functionality.
@pete-s said in Need a web GUI interface to MySQL:
If it doesn't have to be web based you could use MySQL Workbench - which I think is more capable than the web GUIs.
Overkill and slow.
It's not overkill if you're a DBA or developer.
And if you're smart you install it on the machine you do admin from and not on each server.
And you did ask for the best...Actually, no I did not. Read the OP again. Don’t forget the title of the thread.
A fat client is almost always overkill and slow. But MySQL Workbench is a total piece of crap.
The web tools you are talking about also requires a web server and a php installation so they're not exactly "thin" but you want something simple on a LAMP server or similar. I get that.
MySQL Workbench has it's place too. It's to MySQL what SQL Developer and Enterprise Manager is to Oracle DB. I find it useful and use it almost daily.
MySQL Workbench has very little use to me as it is such a heavy handed client. Yes it works. No I do not like it.
For a client on Linux, I prefer Azure Data Studio actually. It is lightweight and lets me work without being in my way. It is based on the VSCode backend to my understanding. If it ever gets MySQL connectivity it will be perfect.
