PHP Cannot Connect to MySQL After Update

English Applications
1

Hello,

Upgraded using Yast earlier today which changed MySQL to version 5.6.36 and now PHP no longer connects to MySQL at all. Even phpMyAdmin cannot connect!

MySQL is running, although I restarted it and rebooted from good measure. It is possible to use MySQL interactively, select databases and run queries, so MySQL itself is working.

PHP Fails at connection:

$link = mysql_connect("localhost", $user, $pass);
if (!$link) die( "Error connecting to database: ".mysql_error());

This worked just yesterday before the upgrade but now mysql_error() returns “Permission denied”.

WTH is going on? I never had a MySQL or PHP upgrade fail via Yast and I don’t see a way to roll back, nor do I know if it is PHP or MySQL’s fault.

Please help. This is urgent, my work is stalled.

Thanks in advance,

2

Probably this?
http://lists.opensuse.org/opensuse/2017-05/msg00322.html
PS: there’s also a bug report here:
http://bugzilla.opensuse.org/show_bug.cgi?id=1038740

3

Talk about landing on a fresh bug! That was it.

Thank you so much!!!

4

I am facing this bug on 42.1 and 42.2.

To make things easier for who is looking for a solution:
It’s a permission problem in /var/run/mysqld.
"But resetting the umask in mysql-system-helper regarding to the instructions there makes it work after the next reboot and manually setting /var/run/mysqld to mode 755 works immediately. "