Bug #8899 Please give exact literal examples.

• Submitted: 2 Mar 2005 18:57
• Modified: 2 Mar 2005 19:58
• Reporter: [ name withheld ]
• Status: Not a Bug
• Category: MySQL Server: Documentation
• Severity: S4 (Feature request)
• CPU Architecture: Any

[2 Mar 2005 18:57] [ name withheld ]

Description:
I would be really really nice if you would give a literal example of how to grant permission to create a database, rather than just saying "To use CREATE DATABASE, you need the CREATE privilege on the database."

Patrick
[e-mail]

How to repeat:
Just view your documentation. There are not nearly enough literal examples.

Suggested fix:
Add more literal examples.

[2 Mar 2005 19:58] MySQL Verification Team

Could you please read the Manual, chapter:

http://dev.mysql.com/doc/mysql/en/mysql-database-administration.html

where you will find:

5.4. General Security Issues

    5.4.1. General Security Guidelines
    5.4.2. Making MySQL Secure Against Attackers
    5.4.3. Startup Options for mysqld Concerning Security
    5.4.4. Security Issues with LOAD DATA LOCAL

5.5. The MySQL Access Privilege System

    5.5.1. What the Privilege System Does
    5.5.2. How the Privilege System Works
    5.5.3. Privileges Provided by MySQL
    5.5.4. Connecting to the MySQL Server
    5.5.5. Access Control, Stage 1: Connection Verification
    5.5.6. Access Control, Stage 2: Request Verification
    5.5.7. When Privilege Changes Take Effect
    5.5.8. Causes of Access denied Errors
    5.5.9. Password Hashing in MySQL 4.1

5.6. MySQL User Account Management

    5.6.1. MySQL Usernames and Passwords
    5.6.2. Adding New User Accounts to MySQL
    5.6.3. Removing User Accounts from MySQL
    5.6.4. Limiting Account Resources
    5.6.5. Assigning Account Passwords
    5.6.6. Keeping Your Password Secure
    5.6.7. Using Secure Connections

Thank you for the bug report.