How to automatically start mysql after server reboot linux machine

If we want mysql server to start automatically on reboot

Issue the below command:

chkconfig --level 345 mysqld on

Reboot the machine and check now.

MySQL Daemon failed to start

When try to start the mysql database getting the below error:

"MySQL Daemon failed to start"

Try with the command mysql as below and check for the error

Here we get the error " Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' "

To resolve this error check the my.conf file under /etc folder

Here in my case bind address is different from my host ip address so I changed it to my host ip address and tried to start mysql again

mysql server on linux

1. Checking the status of mysql server

Open the terminal and run the below command to check the status of the mysql server

2. Starting mysql server

Run the below command to start the mysql server

3. Setting a password for mysql root user

To set the password for linux root user run the below command

4. Connecting to the mysql server as a root user

5. Granting privileges to mysql server to connect remotely

6. Binding ip address and port no for mysql server

Under /etc modify my.cnf file as below