Educator

Introduction to MySQL

• MySQL is an open-source RDBMS commonly used with PHP applications that operates using a client-server model.
• The MySQL RDBMS itself acts as a server to which MySQL ‘clients’ connect in order to issue commands on the database.
• A MySQL server can contain multiple databases, each of which can contain multiple tables.
• MySQL has a user privilege system to control access to the server.
• When a MySQL server is first installed it contains a root user account that allows you to initially login to the server.
• MySQL Monitor is a MySQL client program that provides a command-line interface for interacting with a MySQL server.
• The MySQL Monitor client program can be invoked using the command (with hostname & username replaced with appropriate values):

  mysql –h hostname –u username -p

• Commands entered using MySQL Monitor must be terminated with a semicolon.
• exit can be typed to end the MySQL Monitor program.
• The GRANT SQL command is used to create database users & grant them privileges. It has the format:

  GRANT privileges
  ON objects
  TO ‘username’@’hostname’
  IDENTIFIED BY ‘password’

• In a GRANT command values must be provided for:
  • privileges - the type of privileges to grant to the user
  • objects - the database objects on which to grant the privileges
  • username - the username for the account being created
  • hostname - the host(s) from which the user is allowed to connect
  • password - the password for the account being created
• Database objects are specified in the format databaseName.tableName, and the wilcard character, *, can be used for either the database name or the table name.
• Additional Resources:
  • MySQL Website
  • MySQL Monitor Reference
  • SQL Command Reference - GRANT