Linux restart MySQL command

Source: Internet
Author: User

First, the starting mode

1. Start with service: Service mysqld start

2. Start with mysqld script:/etc/inint.d/mysqld start

3. Use Safe_mysqld to start:safe_mysqld&

Second, stop

1. Start with service: Service mysqld stop

2. Start with mysqld script:/etc/inint.d/mysqld stop

3, mysqladmin shutdown

Third, restart

1. Start with service: Service mysqld restart

2. Start with mysqld script:/etc/inint.d/mysqld restart
Question Editor Summary


How to start/stop/restart MySQL
First, the starting mode

1. Start with service: Service mysqld start

2. Start with mysqld script:/etc/inint.d/mysqld start

3. Use Safe_mysqld to start:safe_mysqld&

Second, stop

1. Start with service: Service mysqld stop

2. Start with mysqld script:/etc/inint.d/mysqld stop

3, mysqladmin shutdown

Third, restart

1. Start with service: Service mysqld restart

2. Start with mysqld script:/etc/inint.d/mysqld restart

When I first started to learn MySQL, I brought it with Redhat. What's the start/rc.d/init.d/start
This is very simple, but later the more learning, the system comes with MySQL, some versions are too low, some with
The low version of MySQL that you want the Web service to install


Later I learned to install MySQL in tar, my MySQL installed in the/usr/local/mysql directory


Have encountered many problems. The most common are:
ERROR 2002:can ' t connect to local MySQL server through socket


'/tmp/mysql.sock ' (111)


Workaround:
[Email protected] mysql]#/usr/local/mysql/bin/mysqladmin-u root/
>-s/var/lib/mysql/mysql.sock password ' your.passwd '
or make a connection.
Ln-s/var/lib/mysql/mysql.sock/tmp
In fact, the hint can not find/tmp/mysql.sock sometimes not the/tmp directory does not have this file, is the boot
The order is wrong, I've met
Common several start-up methods, themselves also not remember very clearly, if you are sure TMP under has mysql.sock this
Files you might want to try a few other commands.
/usr/local/mysql/bin/mysql-u root-p
/usr/local/mysql/bin/mysqld--user=mysql&
/usr/local/mysql/bin/mysqld--user=root&
/usr/local/mysql/bin/mysqld_safe--user=root&
/usr/local/mysql/bin/mysqld_safe--user=mysql&
/usr/local/mysql/bin/safe_mysqld--uer=root& (note that safe_mysqld and Mysqld_safe are different,& that MySQL runs in the background) I'll get an error.
Stopping server from PID file
/usr/local/mysql/data/localhost.localdomain.pid
060304 11:46:21 Mysqld Ended
This is a permissions issue, my MySQL directory belongs to the root user, also belongs to the root group, switch to Mysqld_safe boot is no problem,
You just have to pay attention to these few mysql,safe_mysqld,mysqld_safe,mysqld,mysqladmin. Try More
Several times
In fact, sometimes MySQL has started normally, check whether MySQL starts the command
Ps-aux | grep mysqld
You'll see something like this
MySQL 6394 0.0 1.5 10528 992 PTS/3 S 16:16 0:00
/usr/local/mysql/
MySQL 6395 0.0 1.5 10528 992 PTS/3 S 16:16 0:00
/usr/local/mysql/
MySQL 6396 0.0 1.5 10528 992 PTS/3 S 16:16 0:00
/usr/local/mysql/
Root 6422 0.0 1.1 2408 732 PTS/3 S 16:20 0:00 grep
Mysql


See if MySQL is listening on the port command
Netstat-tl | grep MySQL
You'll see something like this
TCP 0 0 *:mysql *:* LISTEN

MySQL forgot password

Mysql->bin directory under Mysqld--skip-grant-tables

Linux restart MySQL command

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.