Start mysql database operation under linux system

This article mainly talks about starting the mysql database operation under the Linux system. Interested friends can learn more.

{mysql} represents the installation directory of mysql
How to start/stop/restart MySQL
1. Startup method
1. Use service to start: service mysqld start
2. Use mysqld Script startup: /etc/inint.d/mysqld start
If mysqld cannot be found under /etc/inint.d/, you can go to the mysql installation directory, {mysql}/init.d/mysqld start
3. Use safe_mysqld to start: safe_mysqld&
2. Stop
1. Use service to start: service mysqld stop
2. Use the mysqld script to start: /etc/inint.d/mysqld stop
If /etc/inint If mysqld cannot be found under .d/, you can go to the mysql installation directory, {mysql}/init.d/mysqld stop
3. mysqladmin shutdown
3. Restart
1. Use service to start: service mysqld restart
　2. Use the mysqld script to start: /etc/inint.d/mysqld restart
If mysqld cannot be found under /etc/inint.d/, you can go to the mysql installation directory, {mysql}/init.d/ mysqld restart
Question edit summary
How to start/stop/restart MySQL
1. Start method
1. Use service to start: service mysqld start
2. Use mysqld script to start: /etc/ inint.d/mysqld start
　3. Start using safe_mysqld: safe_mysqld&
2. Stop
1. Start using service: service mysqld stop
2. Start using the mysqld script: /etc/inint.d /mysqld stop
3. mysqladmin shutdown
3. Restart
1. Use service to start: service mysqld restart
2. Use mysqld script to start: /etc/inint.d/mysqld restart
When I first started learning mysql, I used the one that comes with redhat. What is startup/rc.d/init.d/ start
This is very simple, but the more I learn later, some of the mysql that comes with the system are too low version, and some are related to the web service I want to install. The lower version of mysql required
Later I learned to install mysql using tar. My mysql was installed in the /usr/local/mysql directory and I encountered many problems when starting it. The most common ones are:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)
Solution:
[root@test 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, when it says that /tmp/mysql.sock cannot be found, sometimes it is not because there is no such file in the /tmp directory, but because the startup
command is wrong. I encountered I don’t remember the common startup methods very clearly. If you are sure that there is a file like mysql.sock under tmp, you might as well try some 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 is different from mysqld_safe, & means mysql is running in the background) Mine will report an error
　STOPPING server from pid file
　/usr/local/mysql/data/localhost.localdomain.pid
　060304 11:46:21 mysqld ended
This is a permission issue. My mysql directory belongs to the root user and the root group. If I use mysqld_safe to start, it will be no problem.
Everyone just needs to pay attention to these 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 will see something similar to the following
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
Check whether mysql is listening on the port command
netstat -tl | grep mysql
You will see something similar to the following
tcp 0 0 *:mysql *:* LISTEN

Related tutorials:
mysql video tutorial

The above is the detailed content of Start mysql database operation under linux system. For more information, please follow other related articles on the PHP Chinese website!