Commands to start the MySQL service in Linux

Restarting the Linux server with the reboot command causes the MySQL service to terminate, which means that the MySQL service is not started. The MySQL service must be restarted or the database MySQL error will be reported when you start JBoss.

The command is as follows:

Step one: Install MySQL and set the installation path for MySQL:

mysql_install_db--user=mysql--datadir=/home/ems/tmp/mysql/data

Command description: The above db-user=mysql, is my MySQL username is mysql,--datadir=/home/ems/tmp/mysql/data equals to the right of the database is the storage path.

Step Two:

Mysqld_safe--datadir=/home/ems/tmp/mysql/data--pid-file=/home/ems/tmp/mysql/asbams_dev85-85.pid--socket=/home/ Ems/tmp/mysql/mysql.sock--bind-address=135.252.247.85--port=3306 &

Command description: asbams_dev85-85 in Data--pid-file=asbams_dev85-85.pid is (hostname-host port number meaning) that is asbams_dev85 is host 85 is the port number.

Commands to start the MySQL service in Linux