ubuntuBSD

unable to start MySQL

Bug #1574298 reported by Jon Boden on 2016-04-24

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	ubuntuBSD	Triaged	High	e1z0

Bug Description

The beginning of /etc/init.d/mysql has this hack:

# this script is buggy on ubuntuBSD, disable it for now...
exit 0

It had to be added because without it, this script would hang forever trying to start MySQL.

Some help would be needed to debug this problem.

Jon Boden (jon-8) on 2016-04-24

Changed in ubuntubsd:
importance:	Undecided → High

Jon Boden (jon-8) on 2016-04-30

Changed in ubuntubsd:
status:	New → Triaged

Revision history for this message

e1z0 (eizo) wrote on 2016-05-05:

/etc/init.d/mysql patch Edit (721 bytes, text/plain)

Fix for the following error (as root):
mysql_install_db --user=mysql
/usr/bin/mysqladmin -u root password 'new-password'

The service patch is also included

Changed in ubuntubsd:
assignee:	nobody → e1z0 (eizo)
status:	Triaged → Fix Committed

Revision history for this message

Jon Boden (jon-8) wrote on 2016-05-07:

Hi Justinas

It's great that you found the cause of this!

So the problem is that MySQL wasn't correctly initialized for user 'mysql', and then you can either run it as root (with the patch you provided) or fix it manually with mysql_install_db?

I did some research and found that mysql_install_db is not used in the package anymore. Perhaps this is the root of the problem? Maybe there's some bug in the new method? (debian_create_root_user.sql)

https://anonscm.debian.org/cgit/pkg-mysql/mysql-5.6.git/commit/?id=0be41c858eca27d582612fe52ed04715023a8377

https://anonscm.debian.org/cgit/pkg-mysql/mysql-5.6.git/tree/debian/additions/debian_create_root_user.sql?id=0be41c858eca27d582612fe52ed04715023a8377