Managing MySQL Database

Database management is done by Database Administrators (DBAs) who:

• Maintain the infrastructure of the database
  
• Maintain the storage of the database
  
• Stop and start the database
  
• Backup and restore the database
  
• Tune the database for optimum performance
  
• Grants to and revokes permissions from other users as needed
  

Database developers and end users don't need to perform these tasks. We will have a brief look at a few of the DBA tasks.

Starting MySQL Server:

• MySQL Server binary mysqld is used to start the database server.
  root access is required.
  root$ /usr/bin/safe_mysqld &
  
• To get database instance started at server boot:
  Edit file /etc/rc.local and add below line in the file:
  /etc/init.d/mysqld start
  
• Process mysqld is core process of MySQL Server.
  

Shutting down MySQL Server:

Done using administrators tasks binary mysqladmin
root$ /usr/bin/mysqladmin -u root -p shutdown
Enter password: **