Ubuntu 12.04 MySQL permissions

  • Posted June 3, 2014

I have a strange problem. Every now and the access to the mysql database is forbidden. I can’t login even as root. If I reboot ubuntu server everything is back to normal. Sometimes just couple of hours, sometimes almost for two weeks. Anyone knows what is the issue here?


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

I ran this command: grep -i “mysql” /var/log/syslog
<br> <br>Is there anything suspicious here? <br> <br>Jun 5 12:14:24 imagionary /etc/mysql/debian-start[1119]: Upgrading MySQL tables if necessary. <br>Jun 5 12:14:24 imagionary /etc/mysql/debian-start[1122]: /usr/bin/mysql_upgrade: the ‘–basedir’ option is always ignored <br>Jun 5 12:14:24 imagionary /etc/mysql/debian-start[1122]: Looking for ‘mysql’ as: /usr/bin/mysql <br>Jun 5 12:14:24 imagionary /etc/mysql/debian-start[1122]: Looking for ‘mysqlcheck’ as: /usr/bin/mysqlcheck <br>Jun 5 12:14:24 imagionary /etc/mysql/debian-start[1122]: This installation of MySQL is already upgraded to 5.5.37, use --force if you still need to run mysql_upgrade <br>Jun 5 12:14:24 imagionary /etc/mysql/debian-start[1133]: Checking for insecure root accounts. <br>Jun 5 12:14:24 imagionary /etc/mysql/debian-start[1138]: Triggering myisam-recover for all MyISAM tables

Is there anything in <code>/var/log/syslog</code>?

Database error. Nothing in mysql.err

Sorry guys I have to wait for error to happen :)

Is there anything in <code>/var/log/mysql.err</code> What’s the exact error you get when you are denied access? <br>


I’m guessing MySQL is running out of memory and crashing. What’s the output of the following command? <br><pre>grep -i “oom” /var/log/syslog <br>grep -i “oom” /var/log/dmesg</pre>