Public bug reported:
I was building a docker container with Ubuntu 22.04 including MySQL 8.0
yesterday. At first everything was fine, the containers bash shell runs
as root and I could connect to the database via the mysql command.
But then I was running a CGI script via the Apache web server running
with user www-data, I received the following error message in the Apache
logs:
```
Can't connect to database, DBI:mysql:host=localhost;port=3306;database=mysql,
Reason: Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (13)
```
Important to note is the 13 at end of the error message, it means:
"Permission denied". Normally it is 2 for "File or directory not found"
when to database is not running.
It took me some time to find that the directory /var/run/mysqld has a
permission of:
```
drwx------ 1 mysql mysql 4096 Apr 26 06:52 mysqld
```
Nobody else then root can reach the socket file to access the database.
After changing the directory permissions to 0755 everything works fine.
Please repair this.
** Affects: gearman-mysql-udf
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1970597
Title:
Installation of MySQL 8.0 with Ubuntu 22.04 (jammy)
To manage notifications about this bug go to:
https://bugs.launchpad.net/gearman-mysql-udf/+bug/1970597/+subscriptions
--
Mailing list: https://launchpad.net/~enterprise-support
Post to : [email protected]
Unsubscribe : https://launchpad.net/~enterprise-support
More help : https://help.launchpad.net/ListHelp
