[debian-mysql] Bug#739970: MYSQL-SERVER bug while installing. Debian wheezy newest mysql server

[Evgeni Golov]

Hi Ludwig,

shot hint: using the reportbug tool (https://wiki.debian.org/reportbug)
helps Debian to gather relevant information about your system and
makes it easier to solve bugs :)

On Mon, Feb 24, 2014 at 02:27:54PM +0100, Ludwig Jaffe wrote:
> package: mysql-server
> version: debian wheezy latest mysql-server

I guess you mean 5.5.35+dfsg-0+wheezy1? :)

> Problem:
> mysql-server did not install correctly. Asked for root database
> password, but was not able to set it. Retried a lot, purged whole mysql:
> apt-get purge mysql-server, mysql-common, mysql-client, apt-get autoremove,
> apt-get clean
> .
> Also removed
> rm -rf /etc/mysql
> rm -rf /var/lib/mysql
> 
> I had no war relevant databases here.
> 
> --
> Now I reinstalled using apt-get install
> mysql-server, mysql-common, mysql-client

In all those steps, did you also install/remove the mysql-*-5.5 packages?

> Also had problems with setting the root name of database.
> Did it by hand mysqld -skip-auth-tables or the like using a howto on the
> web.
> Here it could not write to user.frm or name.frm or the like.
> 
> then I had SUCCESS:
> 
> I fixed the problem by changig the rights from root:root to see below.
> (please check if the rights are too generous.)
> The server is deployed in intranet and the users are inable to attack
> the IT infrastructure, so the danger is low, though)

/var/lib/mysql and everything below are usually owned by mysql:mysql on
a fresh install (this is done in the post-installation script of the
mysql-server-5.5) package. The rights are set to 700.

Do you know what can have changed the rights on your machine?

> I am looking forward to see a fixed mysql-server debian package.
> 
> And BTW: THANKS FOR DEBIAN! KEEP UP DOING ALL THE GOOD WORK!

:)

Regards
Evgeni