vicidial.org

When I try to log into phpMyAdmin on the DB server using cron and password I get the following error:

#2002 Cannot log in to the MySQL server

Perhaps you should try the root user and password instead.

I found the solution to this problem:

In order to be able to log in as root without a password I changed the following line in srv/www/htdocs/phpMyAdmin/config.inc.php from $cfg['Servers'][$i]['AllowNoPassword'] = false; to $cfg['Servers'][$i]['AllowNoPassword'] = true;

I also had to change $cfg['Servers'][$i]['host'] = 'localhost'; to $cfg['Servers'][$i]['host'] = '127.0.0.1';

so you made it possible to use phpMyAdmin without root? i would consider that a serious security violation. it's much better to add a password to root.

Quite right. I changed it back to no password login = false. I can now still login with cron. So the issue was actually also localhost instead of 127.0.0.1.

Which can also be handled via a permission command inside mysql itself (giving that host permission for that user). Although, we've never had that problem ... we have had to add a mysql pass to lock down and change the cron pass of course.

We've also had to (recently) add the reload priv to the cron user to allow backups, which is odd.