Data Access and Security in MySQL

Data Access and Security in MySQL - module S161

MySQL provides facilities to control the access to data which it holds. This is necessary to prevent unauthorised alteration or viewing of information, and also to ensure that applications are robustly written to maintain data integrity.

This topic is presented on public course MySQL

Background information

Some modules are available for download as a sample of our material or under an Open Training Notes License for free download from http://www.training-notes.co.uk.

Topics covered in this module

The MySQL Security Model.
Login accounts, Access Right, Privilege Types.
A Straightforward Example.
Operating System level security - Ownerships and Permissions.
Worked Example - setting up MySQL as an ISP.
Configuraton files and command line options.
Running multiple daemons on one system through mysqld_multi.
MySQL GUIs.

Complete learning

If you are looking for a complete course and not just a information on a single subject, visit our Listing and schedule page.

Well House Consultants specialise in training courses in Python, Perl, PHP, and MySQL. We run Private Courses throughout the UK (and beyond for longer courses), and Public Courses at our training centre in Melksham, Wiltshire, England. It's surprisingly cost effective to come on our public courses - even if you live in a different country or continent to us.

We have a technical library of over 600 books on the subjects on which we teach. These books are available for reference at our training centre. Also available is the Opentalk Forum for discussion of technical questions.