• databases
• /
• mysql
• /
• administration

• Immutable Page
• Comments
• Discussion
• Info
• Attachments
• More Actions ▼
  • Raw Text
  • Print View
  • Delete Cache
  • Like Pages
  • Local Site Map
  • Copy Page
  • Package Pages
  • Load
  • Save
• User (login)

MySQL Administration

Adding a database for a student project

CREATE DATABASE buusername_db;

Giving a user control over a database

GRANT ALL PRIVILEGES ON buusername_db.* TO 'buusername'@'localhost' IDENTIFIED BY 'some_pass';

FLUSH PRIVILEGES;