/usr/local/mysql/bin/mysql Verfourteen point one fourDistrib5.7.3-m13,forLinux(x86_64)using EditLinewrapper
[root@lnmp~]#/bin/cp/usr/local/mysql/support files/mysql.server/etc/init.d/mysqld # Copy mysql.server to the startup item
[root@lnmp~]#/etc/init.d/mysqld start # Start the MYSQL database
StartingMySQL....SUCCESS!
[root@lnmp~]#Netstat - tunlp | grep 3306 # Check whether the MySQL database port 3306 is enabled
tcpzerozero:::three thousand three hundred and six:::*LISTENone thousand seven hundred and seventy-three/mysqld
[root@lnmp~]#/etc/init.d/mysqld stop # Stop the MySQL database
ShuttingdownMySQL..SUCCESS!
[root@lnmp~]#Netstat - tunlp | grep 3306 # Check whether the default port 3306 of MySQL is closed
Note: You can add/usr/local/mysql/bin to PATH.In this way, you can directly enter mysql or mysqladmin without entering the full path. Statement: This article is original by BYRD (based on Centos6.4 X64 and mysql5.7.3), and reprinting without permission is prohibited!SourceByrd's Weblog-https://note.t4x.org/database/mysql-commands-summary/
Statement: unless otherwise specifiedByrd's BlogThe content is original. Reproduction without permission is prohibited!For details, please readCopyright Statement!