Over the past years, MySQL has proven to be one of the most secured database management system. However, following the recent updates and the newly released version 5.7, some security improvements have been made. You were probably not aware of these loop holes in the past!

But before you consider upgrading or to continue with the current version of the MySQL you are running, here are some security improvements you should be aware of:

1. MySQL now enables DBAs to establish a policy for automatic password expiration: Any user who connects to the server using an account for which the password is past its permitted lifetime must change the password & Administrators can now lock and unlock accounts for better control over who can log in.

2. By default, all MySQL deployments installed using mysqld --initialize are secure. However, it is important to take note of the following changes: Installation creates no anonymous-user accounts. and Installation creates no database and The installation process creates only a single account, , automatically generates a random password for this account, and marks the password expired. The MySQL administrator must connect as using the random password and assign a new password.

3. In the new MySQL 5.7, mysql_ssl_rsa_setup utility can be invoked manually to create SSL and RSA key and certificate files and all servers (whether compiled using OpenSSL or yaSSL), if not configured for SSL explicitly, attempt to enable SSL automatically at startup if they find the requisite SSL files in the data directory.

Other improvements to be noted in the new update includes Globalization Features, Master Dump Features, Group Replication Performance Tables, New feature that allows Multi-Source Replication amongst several other improvements.

In addition to these improvements, some features however have been deprecated so it is advisable to expect some things to become impossible in the new version!

MySQL so far is still one of largest database management system globally with over 70% of companies or more running on the system. To become a recognized & certified MySQL DBA, there is an online training on the course available here http:///1Hm5iz1 at a quite affordable price considering it's flexibility and convenient learning method. Register for free today on e-Training Institute e-Learning website today to start your professional IT training. With over 400+ professional courses & certifications including but not limited to Oracle training & certifications, ITIL training & certifications, ICDL, RedHat, Big Data & Hadoop amonsgt several others. You can click here to discover appropriate training & certifications suitable for your career path.

In the event where you might need further clarifications or have any questions, suggestions or opinions as regards the content of this post, please do not hesitate to share your concerns in the comment section below. I sincerely do hope you find this article useful and informative. Remember to take note of the new security improvements in the new MySQL 5.7 & be certain an upgrade to the new version is a good decision for you!

etraininginst:

You were probably not aware of these loop holes in the past!

The hacked my zera school management app