This will helps when you forget MySQL root password and not able to access MySQL service on the server. Here are the steps to reset MySQL password : root@server [~] /etc/init.d/mysqld stop Now start MySQL server without password: root@server [~] mysqld_safe –skip-grant-tables & root@server [~] mysql After that you can get the mysql prompt then […]
See MoreCategory: MYSQL
Script to automatically start mysql
The following script is used to start mysql automatically when it is failed or stopped on the server. You can set 2 min cron “*/2 * * * * /bin/sh /root/automysqlstart.sh” and it restart the mysql automatically. #!/bin/bash #Checking whether MySQL is alive or not if mysqladmin ping | grep -q “alive”; then echo “MySQL is up” […]
See More
You must be logged in to post a comment.