About MySQL

MySQL is a relational database management system (RDBMS) designed to help businesses record, update, and manage data and deploy cloud-native applications. Features include data masking and de-identification, multi-document transaction support, intrusion detection, alerts, and configuration management.

The application provides tools to automate administrative tasks such as data provisioning, backup, patching, and tuning. Engineers can protect confidential data by using encryption, key generation, and digital signatures. Administrators can also monitor user and application-level performance and resource consumption of the database via performance schema.

MySQL Enterprise Firewall helps database administrators protect information through real-time threat monitoring, whitelisting, and SQL statement blocking features. The Query Analyzer lets engineers view query activities, identify problematic queries through full table scans and bad index searches, and evaluate multiple executions during a specific time period.

Developers can use MySQL Workbench to perform database modeling, query development and testing, server configuration, audit data inspection, and database migrations. MySQL allows team members to recover data by utilizing backward compatible full recovery, precise one-click, point-in-time, and partial recovery capabilities.

Devices

Business size

S M L

Images

MySQL Enterprise Manager
MySQL Enterprise Monitor
MySQL Workbench
View 4 more
MySQL video
MySQL screenshot: MySQL Enterprise Manager MySQL screenshot: MySQL Enterprise Monitor MySQL screenshot: MySQL Workbench

Features

Total features of MySQL: 29

  • API
  • Access Controls/Permissions
  • Activity Management
  • Alerts / Escalation
  • Audit Management
  • Authentication
  • Automatic Backup
  • Backup and Recovery
  • Built-In Database
  • Compliance Management
  • Configuration Management
  • Data Migration
  • Data Recovery
  • Data Replication
  • Data Storage Management
  • Event Logs
  • HIPAA Compliant
  • Inspection Management
  • Monitoring
  • PCI Compliance
  • Real Time Monitoring
  • Relational
  • Reporting/Analytics
  • Risk Alerts
  • Sarbanes-Oxley Compliance
  • Secure Data Storage
  • Security Auditing
  • Single Sign On
  • User Management

Alternatives

Caspio

4,6
#1 Alternative to MySQL
Caspio is the world’s leading LOW-CODE platform for building online database applications without having to write code.

Quixy

4,8
#2 Alternative to MySQL
Quixy is a cloud-based No Code digital transformation platform that empowers business users with no coding skills to...

Zoho Creator

4,3
#3 Alternative to MySQL
Zoho Creator is a web-based, low-code platform that lets everyone build custom mobile-ready business apps without any...

DBeaver

4,3
#4 Alternative to MySQL
DBeaver is a database management software which helps organizations store and retrieve business data in a structured...

Reviews

Overall rating

4,6 /5
(1 426)
Value for Money
4,6/5
Features
4,4/5
Ease of Use
4,4/5
Customer Support
4,2/5

Already have MySQL?

Software buyers need your help! Product reviews help the rest of us make great decisions.

Write a Review!
Showing 5 reviews of 1 426
Fernando D.
Overall rating
  • Industry: Information Technology & Services
  • Company size: 201-500 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

The well balanced

Reviewed on 2020/09/30

I use MySQL in many personal projects, like my automated house project. It was a very good choice,...

I use MySQL in many personal projects, like my automated house project. It was a very good choice, I'm happy with this. Also, in the past, I have worked with MySQL and PHP in my company's intranet page. It was a good tool, but as the company grows, we need to migrate to another platform. Also, it is important to say that if you use the correct database engine with MySQL, you can have foreign keys and other types of constraints so it is very flexible.

Pros

MySQL is a well balanced product, while it is free to use, it also has many features you can find in corporative solutions, like SQL Server and Oracle. If you ever need help, you will find answers almost everywhere, from their own documentation to stackoverflow and other forums, easily. You will have a very short learning curve with MySQL.

Cons

When you need to deal with great amount of data, like some kind of data warehouse structure or huge amount of measures to analyze, you better go other choices. It starts getting too slow with the same hardware other products will work smoothly. But I guess that is not the purpose for MySQL. In the other hand, if you want it to build a transactional system like an e-commerce platform or even a Blog page, it is a very good choice!

Adonay andres A.
Overall rating
  • Industry: Information Technology & Services
  • Company size: 11-50 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 9.0 /10

Still good after lots of years

Reviewed on 2020/06/12

I've been using MySQL for 12+ years. It was great then and it's great now. Lots of features have...

I've been using MySQL for 12+ years. It was great then and it's great now. Lots of features have been added and query speed has been improved by a lot.
Since it's a software that has been around us for many years, I insist, the backwards compatibility isn't the desired one, all the needed adjustments to datasets generated in old versions (that are still running in production environments) rely on the dba. Would be great if there could be a utility that handles that.

Pros

I like that it has a community edition which allows to get the software for free with community support. In the case of red hat/CEntOS host, a repository settings can be added and the installation is pretty straightforward.
As long as it is correctly setup according to the server resources and expected demand, it runs pretty fast, it is stable and supports lots of connections.

Cons

I feel that it has been starting to loose its backwards compatibility. If you need to use a previous feature, for example, if you want to use the mysql native password, now you need to specify it when creating a user, otherwise, it won't work straightforward with most CMS software. Also, as some datatypes are being improved (which should be a nice to have feature), when migrating to a newer version, restoring a dump can turn into a headache. The users model have also changed, so, if you had a very large users set, you have to do some work to make it work again in newer versions.

Adam D.
Overall rating
  • Industry: Computer Software
  • Company size: 10 000+ Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Likelihood to recommend 10.0 /10

Powerful FOSS RDBMS

Reviewed on 2021/03/11

My experience with MySQL has been positive. I haven't found an application that it wasn't suited...

My experience with MySQL has been positive. I haven't found an application that it wasn't suited for yet. It has allowed us to move the majority of our systems off of Windows servers onsite to the cloud. Additionally it's compatible with ArouraDB which allows us to safe money with non production sites.

Pros

I've used both Microsoft SQL Server and Oracle and what I liked most about MySQL, aside from my personal preference for it's syntax, is that it runs well on all platforms and is easy to setup and maintain. MSSQL limits you to Windows servers and while Oracle will run on various platforms it is difficult to setup and maintain.

Cons

What I like least about MySQL is that backing up and restoring databases is a pain. You basically have to dump the database to a text file that contains every SQL statement needed to recreate the database. I also feel like the MySQL dataconnector for .NET Core isn't well developed or supported. Also MSSQL and Oracle have more ease of use functions when programming.

Verified Reviewer
Overall rating
  • Industry: Information Technology & Services
  • Company size: 11-50 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

MySQL the default database server

Reviewed on 2019/08/08

We just use MySQL for all of our databases

We just use MySQL for all of our databases

Pros

It's the default standard for many companies. MySQL has grown into a very stable product that never crashes. We've made the move to MariaDB, but found that the tables sometimes get corrupted when restarting a database server under heavy load. With the recent speed improvements to MySQL, we have decided to actually migrate back to MySQL.

Cons

I'd really like if they would spend a bit more time on their CLI interface. As in, syntax highlighting in the CLI, an easier way to scroll through multiline queries when going through the history. I would also like it if we can specify a color scheme to use for the output.

Mohammad iqbal K.
Overall rating
  • Industry: Computer Software
  • Company size: 51-200 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

MySQL is lighter and fast database

Reviewed on 2021/01/25

Our application has 2-way interface, data-entry and user / customer interfaces. On one hand it is...

Our application has 2-way interface, data-entry and user / customer interfaces. On one hand it is being used with .Net for data-entry part of application and on other hand being used with PHP for user / customer interface. The .Net part is deployed locally while user / customer interface is deployed on Azure. A in-house developed desktop utility is also being used to transport data from local MySQL server to Azure MySQL database. We are having almost 2M+ transactions in few tables, working well. It helps us to save the licensing cost. It is also being used in our other websites in backend for data storage and retrieval.

Pros

The thing I like most about MySQL is, It is available for multiple operating systems like Windows, Linux, etc. It is free and open-source. It is very lighter in comparison to MsSQL and very fast. It is very easy to learn and use. It is very easy to install, configure and manage. The syntax is very identical to the same we use sentences in English. It is capable to hold large data in tables. It is best free database with enterprise level features. It is supported by almost all popular programming languages. There are numerous 3rd party custom tools available for it.

Cons

With huge data, I had faced data loss and improper data retrieval but it is very rare and manageable. Some of the error messages are so general and unable represent the actual problem. Some error messages are so weird then the actual problem. It gives sense of insecurity at some points.

Showing 5 reviews of 1 426 Read all reviews

MySQL FAQs

Below are some frequently asked questions for MySQL.

MySQL offers the following pricing plans:

  • Starting from:
  • Pricing model: Subscription
  • Free Trial: Available

MySQL offers a free trial for new users, after which the software is available across 4 commercial editions. Pricing and functionality are outlined below. MySQL Cluster Carrier Grade Edition Subscription (1-4 socket server): starts at $10,000 per year MySQL Cluster Carrier Grade Edition Subscription (5+ socket server): starts at $20,000 per year MySQL Enterprise Edition Subscription (1-4 socket server): starts at $5,000 per year MySQL Enterprise Edition Subscription (5+ socket server): starts at $10,000 per year MySQL Standard Edition Subscription (1-4 socket server): starts at $2,000 per year MySQL Standard Edition Subscription (5+ socket server): starts at $4,000 per year MySQL Classic Edition (only available for ISVs/OEMs)

We do not have any information about MySQL features

MySQL has the following typical customers:

2-10, 11-50, 51-200, 201-500, 501-1 000, 1 001+

We do not have any information about what languages MySQL supports

MySQL supports the following devices:

We do not have any information about what integrations MySQL has

MySQL offers the following support options:

Email/Help Desk, FAQs/Forum, Knowledge Base, Phone Support, 24/7 (Live rep), Chat

Related categories

See all software categories found for MySQL.