A question can only have one accepted answer. Are you sure you want to replace the current answer with this one?
You previously marked this answer as accepted. Are you sure you want to unaccept it?
Write for DigitalOcean
You get paid, we donate to tech non-profits.
Find and meet other developers in your city.
Contribute to Open Source
How to connect my mysql database from remote Tableau server ?
Add comments here to get more clarity or context around a question. To answer a question, use the “Answer” field below.
You can type !ref in this text area to quickly search our full set of tutorials, documentation &
marketplace offerings and insert the link!
Please help me to install mysql 3.24 or version below 4 on ubuntu 16.04 as the
the software is not supporting version 5 or above. a detailed installation help me
more because am newbie to database world..
I have a Ubuntu 16.04.x server, where I installed MySQL.
Works great and everything, but I would like MySQL to be restarted if it, for any reason stops.
First of all, i know this isn't a very good solution, because there is a reason that the MySQL proccess stops. But I also have a Ubuntu 14.04.x server which has been running for over a year, where it happend 2 times. In these cases it would be really nice to get it up and running again. I have my logs to see why it went down.
So to the actual thing I need help with:
I found this script, that claims to be able to restart MySQL if it stops:
I have made a file called mysqlfix.sh in /root/
if [[ ! "$(/usr/sbin/service mysql status)" =~ "start/running" ]]
echo " The MySQL service on the server has been stopped. It has now been restarted." | mail -s " MySQL has been restarted" firstname.lastname@example.org
sudo service mysql start
Then made sure that it can run:
chmod +x mysqlfix.sh
Then added a cron job(crontab -e) that checks it every minute:
chmod +x mysqlfix.sh
This seems to be working on Ubuntu 14.04.x. But not on my new Ubuntu 16.04 server.
It sends me an E-mail every minute with the "The MySQL has been restarted" message.
This makes me think that the if statement is wrong. But I haven't been able to find what is wrong with it.
I have just created a droplet with Ubuntu 16.04, and installed LAMP separately using available tutorials.
Unfortunately, when I open my.cnf the only items in this ate the following.
I am having trouble connecting databases with razorsql.
I want to help step by step.