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

Linux 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!