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.
- To get database instance started at server boot:
Edit file /etc/rc.local and add below line in the file:
- Process mysqld is core process of MySQL Server.
Shutting down MySQL Server:
Done using administrators tasks binary mysqladmin
/usr/bin/mysqladmin -u root -p shutdown
Enter password: **