How do i start and stop mysql?

Question

Each Bitnami stack includes a control script that lets you easily stop, start and restart services.

Table of Contents Show

The Startup/Shutdown Screen
On Linux start/stop/restart from the command line:
On macOS Big Sur, Sierra & OSX to start/stop/restart MySQL post 5.7 from the command line:
On OS X to start/stop/restart MySQL pre 5.7 from the command line:
Restart the service
Reinstall the service
Verify the my.ini config file
Verify the Network Service permissions
Check for missing default files
How do I start MySQL?
How do I turn off MySQL?
How do I start MySQL from command line?
How do I stop a MySQL script?

Obtain the status of a service:

$ sudo /opt/bitnami/ctlscript.sh status

Call it without any service name arguments to start all services:

$ sudo /opt/bitnami/ctlscript.sh start

Or use it to restart a single service, such as Apache only, by passing the service name as argument:

$ sudo /opt/bitnami/ctlscript.sh restart apache

Use this script to stop all services:

$ sudo /opt/bitnami/ctlscript.sh stop

Restart the services by running the script without any arguments:

$ sudo /opt/bitnami/ctlscript.sh restart

To stop/start MySQL using MySQL Workbench:

Select Server > Startup/Shutdown from the top menu
A tab will open showing whether the server is stopped or started. Click either Stop Server or Start Server as required.

Here are screenshots for the above steps.

Top Menu

Select Server > Startup/Shutdown from the top menu of MySQL Workbench:

Selecting the “Startup/Shutdown” option from the “Server” menu.

The Startup/Shutdown Screen

A tab will open showing whether the server is stopped or started. Click either Stop Server or Start Server as required:

The “Administration – Startup/Shutdown” screen allows you to stop and start the MySQL server with a click of a button.

Note that stopping the MySQL server will close all current connections, and no applications will be able to use the server until it has been started again.

To restart, start or stop MySQL or mariadb database servers from the command line, type the following at the shell prompt…

On Linux start/stop/restart from the command line:

 /etc/init.d/mysqld start

 /etc/init.d/mysqld stop

 /etc/init.d/mysqld restart

Some Linux flavors offer the service command too

 service mysqld start

 service mysqld stop

 service mysqld restart

or

 service mysql start

 service mysql stop

 service mysql restart

On macOS Big Sur, Sierra & OSX to start/stop/restart MySQL post 5.7 from the command line:

sudo launchctl load -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist

sudo launchctl unload -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist

On OS X to start/stop/restart MySQL pre 5.7 from the command line:

 sudo /usr/local/mysql/support-files/mysql.server start

 sudo /usr/local/mysql/support-files/mysql.server stop

 sudo /usr/local/mysql/support-files/mysql.server restart

Last updated on: 2021-03-11

Authored by: Uriel Amar

This article describes the process of resolving the following MySQL® for Windows® error:

MySQL service on local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

The solution varies depending on your version of MySQL. Attempt the solutions in the order of the following sections.

Restart the service

Restart the MySQL service by running the following command:

mysqld --initialize

You need to log in as root or use sudo -i to run this command.

Reinstall the service

Log in as root and reinstall the MySQL service by running the following commands:

mysqld --install
mysqld --initialize

Verify the my.ini config file

Certain versions of MySQL add invalid hex values at the beginning of the my.ini configuration file. Deleting the first three hex values using a hex editor should resolve this issue. This occurs because of an issue with a script line. The line specifies that each file must have a unique ID, which then appends the byte order to mark the text file.

If you have a backup of the original my.ini file, you can copy the contents of this file and manually paste them onto the current my.ini to resolve this issue.

Verify the Network Service permissions

You might need to verify that the Network Service has the proper permissions. Use the steps in this section to verify these permissions are correct:

Right-click the Data folder.
Select Properties.
Select the Security tab.
Click Advanced.
Click Change Permissions….
Click Add….
Enter NETWORK SERVICE.
Click Check Names.
Click OK.
Select Full Control.

Check for missing default files

It’s possible that default files are missing. Use the steps in this section to check for this missing default files:

Open the command prompt.

Go to the MySQL *bin* and run the following command:

mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini" --standalone --console

If it specifies a missing default folder, you should create a new default file.

Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License

See license specifics and DISCLAIMER

How do I start MySQL?

Set Up a MySQL Database on Windows.

In the Windows Command Prompt, run the command: mysql -u userName -p..

Enter your password when prompted..

How do I turn off MySQL?

Stop the MySQL Server.

IMPORTANT: Do not stop the MySQL server if the rest of the STA application is running..

Open a terminal session on the STA server, and log in as the Oracle user..

Stop the MySQL server: $ STA stop mysql..

Verify the server is not running: $ STA status mysql. You should see: mysql is shutdown..

How do I start MySQL from command line?

Launch the MySQL Command-Line Client. To launch the client, enter the following command in a Command Prompt window: mysql -u root -p . The -p option is needed only if a root password is defined for MySQL. Enter the password when prompted.