Question

Ubuntu 12.04 MySQL permissions

Posted June 3, 2014 2.9k views
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?

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.

7 answers
I'm guessing MySQL is running out of memory and crashing. What's the output of the following command?
grep -i "oom" /var/log/syslog

grep -i "oom" /var/log/dmesg
Is there anything in /var/log/mysql.err What's the exact error you get when you are denied access?
Sorry guys I have to wait for error to happen :)
Database error. Nothing in mysql.err
Is there anything in /var/log/syslog?
I ran this command: grep -i "mysql" /var/log/syslog

Is there anything suspicious here?

Jun 5 12:14:24 imagionary /etc/mysql/debian-start[1119]: Upgrading MySQL tables if necessary.
Jun 5 12:14:24 imagionary /etc/mysql/debian-start[1122]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Jun 5 12:14:24 imagionary /etc/mysql/debian-start[1122]: Looking for 'mysql' as: /usr/bin/mysql
Jun 5 12:14:24 imagionary /etc/mysql/debian-start[1122]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
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
Jun 5 12:14:24 imagionary /etc/mysql/debian-start[1133]: Checking for insecure root accounts.
Jun 5 12:14:24 imagionary /etc/mysql/debian-start[1138]: Triggering myisam-recover for all MyISAM tables
Submit an Answer