phpMyAdmin5.0.2

Name: phpMyAdmin
Rating: 4.375 (8 reviews)

23 March 2020

Manage MySQL databases via the Web.

Follow this app Developer website

Overview

phpMyAdmin is intended to handle the administration of MySQL over the Web. Currently it can:

Create and drop databases
Create, copy, drop, and alter tables
Delete, edit, and add fields
Execute any SQL-statement, even batch-queries
Manage keys on fields
Load text files into tables
Create and read dumps of tables
Export data to CSV values
Administer multiple servers and single databases

Note: While the software is classified as free, it is actually donationware. Please consider making a donation to help support development.

What's new in phpMyAdmin

Version 5.0.2:

Welcome to the release of phpMyAdmin version 5.0.2. This is fixes an important security flaw as well as containing several other bug fixes.

First the security fixes:

PMASA-2020-2 SQL injection vulnerability in the user accounts page, particularly when changing a password
PMASA-2020-3 SQL injection vulnerability relating to the search feature
PMASA-2020-4 SQL injection and XSS having to do with displaying results
Removing of the "options" field for the external transformation.
We are removing the ability for users to set "options" field for the external transformation. This must now be hard
Coded in the plugin file directly (where the program is configured). This feature allows users to pipe output directly to an executable file,
However the options field presented a security risk and we have decided to move the options to be hard coded in the transformation plugin file.
For further assistance, please reach out to our support team through email or Github pull request.

Next a few of the key bugfixes included with this release:

Fix for copying a user account
Removed SET AUTOCOMMIT=0 from SQL export
Fix for the display of table borders
Fix for ENUM radio button user interface problems
Improved the prompt for abandoning changes when no changes were made in the SQL window
Fix for inserting a primary key with "insert as new row"
Fix incorrect suggested latest available version to version 5

21 Reviews of phpMyAdmin

Warning, Do not upgrade to 4.2.3 if you are not running MySQL 5.5 or later. I found this out the hard way running MySQL 5.0.

(1)

ylluminate

27 March 2013

Version: 4.0.0-beta3

While not specifically an OS X app, it is appreciated to see updates here. Also, it's certainly one of the most handy tools in a developer's tool belt on any server running MySQL.

(3)

Show comment (1)

Um, you can run it on OS X Server just like you can Apache or MySQL?

How is this a Mac application?

(4)

Show comments (10)

The download link is wrong, it goes to release notes. So instead click on the Development team link, then you'll find downloads in different formats on the right of the window.

(0)

MAMP does indeed simplify Life in a big way. Other stuff is usually NerdWare. If the world were run by nerds we'd have to get out of the car to change a red light to a green one by hand lol Nerd motto: "make sure things are as complex as possible".

I'm tired of hunting for tutorials and finding installation procedures for out of date versions. This should have an installer that can get it in and working in under a minute. If someone made an installer for phpmyadmin that could install it in a couple clicks I'd pay $100 on the spot for it right now. My time is worth to much to me to keep screwing around trying to learn how to get it installed.

Show comments (3)

This is back to being my favourite application. I find it indispensible for MySQL administration. The past few versions have been rock-solid. Setup is still a little tricky, but has been improved considerably with the setup scripts.

Anyone interested in this might also want to check out "MySQL Administrator." (http://dev.mysql.com/downloads/administrator/1.1.html). It doesn't look like it would work remotely, but on the other hand it is an actual program, not a collection of PHP scripts. It seems pretty well organized, while in my every-so-often use of phpMyAdmin, that program has always seemed confusingly organized.

Show comments (2)

Wow - up until this version (2.8) everything was great. I cannot for the life of me get this version to work, despite following the instructions to the letter. I get errors such as "A session is active. You cannot change the session module's ini settings at this time", even when I try using the setup script. I love this app. I hope this is a bug that will be fixed soon, or that it is something that can be solved by better documentation. For right now, I can't use it.

This is the best and easiest way that I've found to run your databases. Easy to: create, copy, export, update etc. If you haven't tried it, what's stopping you? It's free! To the guy with the setup problems... It's a little scary the first time but all you usually need to do is edit the config file to add the mySQL:username, mySQL:password and the directory where the site files are (which is probably the toughest part). All the other options(very many) were fine for me at the defaults. The only problem that I've had is that on very large sql files (over 500k of inserts), it sometimes chokes. I'm not sure if this is a phpMyAdmin, browser or server problem. (It says maximum 2048k) The same data in a csv file works as an import but it's also smaller in bytes. I use it for home tinkering and remotely on a 34 site server.

This is simply the best way to manually interact with a mySQL database. I use it both on my webserver and on my PowerBook for local testing. It has a very good graphical interface that gives the user access to just about any controls on the database or table. I suppose if I had to fault it for anything, it would be it's comprehensive features. It can be simply overwhelming to a new user. But to novices, I'd say, just sit down to take the time to learn it. The mySQL manual is relatively easy to understand, although there's a lot of information in it.

This is the best tool possible for interfacing with a common DBMS. A great way for learning SQL through the interface which explains all operations performed. The beginners to DBMS stuff are more than welcome, if they can handle the setup process :) - consider that as an initiation for this side of information technology.

man, installing this is harder then installing PHP Mysql and Apache alltogether. what is this skilltesting software supposed to make things "easier"?

Absolutely indispensible for web based management of your MySQL databases. Super fast, capable, clean, and easy. Love it!

Another great free program for os x. It takes a little time to understand but it works well for Beta. Can't wait for a final release

The app doesn't wanna download with FlashGet. I'm on a PC but I download it for a Mac. On the official website (sourgeforge), are files for Mac ? But files doesn't can be load too. Who can explain me why ? Or better, send me the app on colasmalaise@wanadoo.fr That would be so sympathic ! Thx and Bye !

Awesome app. I live by this baby and there is sooo much you can do with it. The interface IS a bit intimidating but once you get over that, you are ready to roll. As for comparing it to Navicat... Navicat is just as superb as phpMyAdmin and has a much cleaner and easier to use interface... however it also costs $99 while this app is free.

Excellent tool for administering your MySQL setup. Someone commented that Navicat is better...I personally think that they have relatively equivilant feature sets (though Navicat has a nice cocoa interface). The biggest difference is that Navicat costs and phpMyAdmin is free. I won't pay simply for a slicker GUI.

phpmyadmin is good for server side administration, but for client side administration Navicat (http://www.mysqlstudio.com) seems perform a lot better. kkna

phpMyAdmin5.0.2

Overview

What's new in phpMyAdmin

First the security fixes:

Next a few of the key bugfixes included with this release:

Related articles

Join over 500,000 subscribers.

21 Reviews of phpMyAdmin

More apps