Securing User Account Details with MySQL

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.

Comments:

Post a Comment:
Comments are closed for this entry.
About

Get the latest updates on products, technology, news, events, webcasts, customers and more.

Twitter


Facebook

Search

Archives
« July 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
       
Today