Skip navigation links

The world's most popular open source database

Login | Register

Developer Zone
Downloads
Documentation

MySQL Server
MySQL Enterprise
MySQL Workbench
MySQL Cluster
MySQL Connectors
Topic Guides
Expert Guides
Other Docs
Archives
About

Documentation Library
- Table of Contents

Search manual:

Security in MySQL

Preface and Legal Notices »

Section Navigation [Toggle]

Security in MySQL

Security in MySQL

Abstract

This is the MySQL Security Guide extract from the MySQL 5.1 Reference Manual.

Document generated on: 2012-11-19 (revision: 33136)

Table of Contents [+/-]

Preface and Legal Notices

1. Security

2. General Security Issues [+/-]

2.1. Security Guidelines

2.2. Keeping Passwords Secure [+/-]

2.2.1. End-User Guidelines for Password Security
2.2.2. Administrator Guidelines for Password Security
2.2.3. Passwords and Logging
2.2.4. Password Hashing in MySQL
2.2.5. Implications of Password Hashing Changes in MySQL 4.1 for Application Programs

2.3. Making MySQL Secure Against Attackers

2.4. Security-Related mysqld Options and Variables

2.5. How to Run MySQL as a Normal User

2.6. Security Issues with LOAD DATA LOCAL

2.7. Client Programming Security Guidelines

3. Postinstallation Setup and Testing [+/-]

3.1. Unix Postinstallation Procedures [+/-]

3.1.1. Problems Running mysql_install_db
3.1.2. Starting and Stopping MySQL Automatically
3.1.3. Starting and Troubleshooting the MySQL Server

3.2. Securing the Initial MySQL Accounts

4. The MySQL Access Privilege System [+/-]

4.1. Privileges Provided by MySQL
4.2. Privilege System Grant Tables
4.3. Specifying Account Names
4.4. Access Control, Stage 1: Connection Verification
4.5. Access Control, Stage 2: Request Verification
4.6. When Privilege Changes Take Effect
4.7. Causes of Access-Denied Errors

5. MySQL User Account Management [+/-]

5.1. User Names and Passwords

5.2. Adding User Accounts

5.3. Removing User Accounts

5.4. Setting Account Resource Limits

5.5. Assigning Account Passwords

5.6. Using SSL for Secure Connections [+/-]

5.6.1. Basic SSL Concepts
5.6.2. Configuring MySQL for SSL
5.6.3. Using SSL Connections
5.6.4. SSL Command Options
5.6.5. Setting Up SSL Certificates and Keys for MySQL

5.7. Connecting to MySQL Remotely from Windows with SSH

5.8. SQL-Based MySQL Account Activity Auditing

6. Frequently Asked Questions about Security

Copyright © 1997, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices

Top / Previous / Next / Up / Table of Contents

Developer Zone
Documentation
Developer Articles
News & Events
Forums
Lists
Bugs
Worklog
Planet MySQL
Labs

Downloads
MySQL Community Server
MySQL Proxy
MySQL Cluster
MySQL Workbench
MySQL Connectors
Archives

Documentation
MySQL Reference Manuals
MySQL Workbench
Expert Guides
Topic Guides
MySQL Cluster
Other Documents
About
Archives

About MySQL
Contact Us
How to Buy
Partners
Job Opportunities
Site Map

Legal
Legal Policies
Your Privacy Rights
Terms of Use
Trademark Policy
Contributor Agreement

© 2012, Oracle Corporation and/or its affiliates