Every database engine is safe, while it has been well configured and the minimum security controls have been applied, as well as the appropriate permits at server and tool level. Additionally, the stored data must be regulated to validate the efficiency of the motor.
Your MySQL database will be safe if you set it up correctly. It is also important to choose the right tool to work with it, with which you can streamline your workflow and gain access to administration. Many of my colleagues use dbForge Studio mysql gui for mac tools https://www.devart.com/dbforge/mysql/studio/ . Since there is a full-fledged graphical interface here that helps you create and execute queries, as well as automate the management of database objects.
I agree with the other replies
You can also do a google search for
MySQL security
It has some built in security features and there are some plugins you can install to increase security
You should also look at MariaDB which is an updated version of MySQL developed by the original developers of MySQL
Business Development Analyst at MTS - Logistics Center
0
0
First thing is compatibility and mysql has a good compatibility with several things
Second its known and has a good support and guidance
About security it has a good security
Advice, you have to secure OS , network, application layer, database and then you get strong security
Yes, My advise is to hire a expert for it. He will better analyse the needs and give you proper security option or there are many cause conflicts later on.
Programmer Analyst IV at University of Southern California
0
0
Yes, mySQL is really secure, if you configure them properly. First of all there are lot of online guides available on "how to secure mysql installation". We use it to store patient information and hence have to make it HIPAA compliant as well. Also look for the data encryption in MYSQL.
MySQL includes several components and plugins that implement security features:
1) Plugins for authenticating attempts by clients to connect to MySQL Server.
2) A password validation component for implementing password strength policies of passwords.
3) Plugins that provide secure storage for sensitive information.
4) MySQL Audit ((MySQL Enterprise Edition only), implemented using a server plugin, uses the open MySQL Audit API to enable standard, policy-based monitoring and logging of connection and query activity executed on specific MySQL servers. Designed to meet the Oracle audit specification, MySQL Enterprise Audit provides an out of box, easy to use auditing and compliance solution for applications that are governed by both internal and external regulatory guidelines.
5) A user-defined function enables applications to add their own message events to the audit log.
6) MySQL Enterprise Firewall (MySQL Enterprise Edition only), an application-level firewall that enables database administrators to permit or deny SQL statement execution based on matching against whitelists of accepted statement patterns. This helps harden MySQL Server against attacks such as SQL injection or attempts to exploit applications by using them outside of their legitimate query workload characteristics.
7) MySQL Enterprise Data Masking and De-Identification (MySQL Enterprise Edition only), implemented as a plugin library containing a plugin and a set of user-defined functions. Data masking hides sensitive information by replacing real values with substitutes. MySQL Enterprise.
8) Data Masking and De-Identification functions enable masking existing data using several methods such as obfuscation (removing identifying characteristics), generation of formatted random data, and data replacement or substitution.
here is list of some overlooked security holes in MySql:
update the password plugin;
password for the root account
root accounts that are accessible from outside the host;
remove anonymous-user
remove test database and privileges
These simple step is the beginning in Hardening MySql installation.
Hasini, What do you mean? Have you experienced any security issue? How are you using MySQL (any back-end language) If so, like any other language it depends on you to create a good code and apply security suggestions to it to prevent attacks etc...
With over 2.5 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.