mirko1
By:
mirko1

Ubuntu 12.04 MySQL permissions

June 3, 2014 2.1k 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?
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
Have another answer? Share your knowledge.