Managing MySQL Database

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

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: **

Loading comments...