MySQL - Explain how can you start and shutdown MySQL server

Start and shutdown MySQL server.

Start MySQL Server
Command prompt:
Set the mysql directory and type:
./bin/mysqld_safe &
This will ensure that the process runs in the background.

Shutdown MySQL Server
Command prompt:
./bin/mysqladmin -u root -p shutdown
This will shut down sql server completely as root user.
MySQL - Tools that are available for managing MySQL Server
Tools that are available for managing MySQL Server - mysqld - MySQL server daemon. It is used to start the mysql server.....
MySQL - Purpose of "mysql" command-line interface
Purpose of mysql command-line interface - Mysql or mysql monitor is a Command line interface used to manage mysql’s data objects like databases, tables etc..
MySQL - What is "mysqld"?
What is mysqld? - Mysqld is a daemon server program typically used to start and stop mysql server. It runs in the background......
Post your comment