fails to connect to mysql database

[Hans Halvorson]

# sudo apt-get install mythtv-database

Failed to connect to database: Access denied for user 'root'@'dell.local' (using password: YES) at -e line 5, <> line 1.
Failed to create database (incorrect admin username/password?)
It's also possible that mysql-server wasn't running. After install
is completed, you will need to make sure mysql-server is running
and that you supplied correct information. Try:
sudo dpkg-reconfigure mythtv-database

# sudo dpkg-reconfigure mythtv-database

Failed to connect to database: Access denied for user 'root'@'dell.local' (using password: YES) at -e line 5, <> line 1.
Failed to create database (incorrect admin username/password?)
It's also possible that mysql-server wasn't running. After install
is completed, you will need to make sure mysql-server is running
and that you supplied correct information. Try:
sudo dpkg-reconfigure mythtv-database

[Hans Halvorson (hans.halvorson)]

Further information:

Gutsy repositories

mythtv-database 0.20.1+fixes13837
mysql-server 5.0.45-1

[Mario Limonciello (superm1)]

Hi, Thanks for your report.

Have you followed what it told you, to reconfigure mythtv-database? If
you have changed your root password (as it sounds you did), you will
need to provide that information when reconfiguring mythtv-database.

Mario

[Hans Halvorson (hans.halvorson)]

Yes, I did dpkg-reconfigure, during which process I gave a new root
password -- the same password I gave as root for mysql-server. But I
still get the same error message.

Thanks,
Hans

At Sun, 29 Jul 2007 22:41:43 +0000,
Mario Limonciello wrote:
>
> Hi, Thanks for your report.
>
> Have you followed what it told you, to reconfigure mythtv-database? If
> you have changed your root password (as it sounds you did), you will
> need to provide that information when reconfiguring mythtv-database.
>
> Mario
>
> --
> fails to connect to mysql database
> https://bugs.launchpad.net/bugs/129137
> You received this bug notification because you are a direct subscriber
> of the bug.

[Mario Limonciello (superm1)]

Have you verified that the password worked from the normal mysql command line?

mysql -u root

[Hans Halvorson (hans.halvorson)]

Yes, I can log into mysql with

# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.0.45-Debian_1-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Thanks,
Hans

At Mon, 30 Jul 2007 00:38:25 +0000,
Mario Limonciello wrote:
>
> Have you verified that the password worked from the normal mysql command
> line?
>
> mysql -u root
>
> --
> fails to connect to mysql database
> https://bugs.launchpad.net/bugs/129137
> You received this bug notification because you are a direct subscriber
> of the bug.

[Hans Halvorson (hans.halvorson)]

Here's the latest output:

john@dell $ sudo dpkg-reconfigure mythtv-database
Failed to execute SQL: GRANT ALL PRIVILEGES ON mythconverg.* TO
mythtv@localhost IDENTIFIED BY <mythtv sql password>\nAccess denied for user 'root'@'dell.local' to database 'mythconverg' at -e line 8, <> line 1.

Thanks,
Hans

At Mon, 30 Jul 2007 00:38:25 +0000,
Mario Limonciello wrote:
>
> Have you verified that the password worked from the normal mysql command
> line?
>
> mysql -u root
>
> --
> fails to connect to mysql database
> https://bugs.launchpad.net/bugs/129137
> You received this bug notification because you are a direct subscriber
> of the bug.

[Hans Halvorson (hans.halvorson)]

Am I the only person having this problem?

I even tried changing the root password for mysql, and then reconfiguring mythtv-database. Still exactly the same problem:

keller@dell:/etc/mysql/conf.d$ sudo dpkg-reconfigure mythtv-database
Failed to connect to database: Host 'dell.local' is not allowed to connect to this MySQL server at -e line 5, <> line 1.
Failed to create database (incorrect admin username/password?)
It's also possible that mysql-server wasn't running. After install
is completed, you will need to make sure mysql-server is running
and that you supplied correct information. Try:
sudo dpkg-reconfigure mythtv-database

[Hans Halvorson (hans.halvorson)]

OK, it is now working. I don't know what exactly changed, but I removed/purged all mythtv components and all mysql-server components, and then I reinstalled.

Can you please close this bug? Thanks.