Securing User Account Details with MySQL
- by Antoinette O'Sullivan
Keeping user account details secure is always at the forefront of a Database Administrator's mind. However, users want to get up and running as soon as possible without complex login procedures.
You can learn more about this and many other topics in the MySQL for Database Administrator course.
For example, MySQL 5.6.6 introduced a new utility: mysql_config_editor, which makes secure access via MySQL client applications much easier to establish, while still providing a good measure of security.
The mysql_config_editor stores a user's authentication details in an encrypted login file called mylogin.cnf. This login file is readable and writable for the user who invokes the utility, and invisible to everyone else. You can use it to collect all your hard-to-remember server locations and paswords safe in the knowledge that your passwords are never invoked using clear text.
The MySQL for Database Administrators course is a 5-day instructor-led course which is available as a:
Training-on-Demand: Start training within 24 hours of registration, following lecture material at your own pace through streaming video and booking time on a lab environment to suit your schedule.
Live-Virtual Event: Attend a live event from your own desk, choosing from a selection of events on the schedule to suit different timezones.
In-Class Event: Travel to an education center to attend this course. Below is a selection of the events already on the schedule.
Location
Date
Delivery Language
Brisbane, Australia
18 August 2014
English
Brussels, Belgium
25 August 2014
English
Sao Paulo, Brazil
2 June 2014
Brazilian Portuguese
Cairo, Egypt
28 September 2014
Arabic
London, England
14 July 2014
English
Belfast, Ireland
15 September 2014
English
Dublin, Ireland
29 September 2014
English
Rome, Italy
16 June 2014
Italian
Seoul, Korea
9 June 2014
Korean
Petaling Jaya, Malaysia
16 June 2014
English
Utrecht, Netherlands
25 August 2014
English
Edinburgh, Scotland
26 June 2014
English
Madrid, Spain
6 October 2014
Spanish
Tunis, Tunisia
27 October 2014
French
Istanbul, Turkey
14 July 2014
Turkish
To register for an event, request an additional event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.
To read more about MySQL security, consult the MySQL Reference Manual - http://dev.mysql.com/doc/refman/5.6/en/security.html.