<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
On 05/28/2011 06:07 PM, Ramon Hofer wrote:
<blockquote cite="mid:4DE11DB4.40000@bluewin.ch" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
On 05/28/2011 02:01 AM, Nick Morrott wrote:
<blockquote
cite="mid:BANLkTi=ttQUHb94k+-aBOWt2oOJe5XhsLA@mail.gmail.com"
type="cite">
<pre wrap="">On 27 May 2011 22:59, Ramon Hofer <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="mailto:ramonhofer@bluewin.ch"><ramonhofer@bluewin.ch></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi all
I'm trying to install MythTV Backend on Debian Squeeze.
After installing the base system with SSH access I install mysql-server.
There's no problem. I can reboot and there's no error message.
But when I simply change the bind-address to the system's IP address and
then reboot I get an error message when mysqld should be started.
</pre>
</blockquote>
<pre wrap="">>From your syslog, it looks like networking is starting /after/ mysqld.
This is causing mysqld to fail to bind to the as-yet-unconfigured IP
address. When you restart mysqld, networking is up and mysqld can bind
successfully as the configured IP address has now been acquired.
The second issue (logging in to the database from the command line)
seems to be due to incomplete mysql access permissions - not user
permissions to the files on disk, but rather the user access control
to the database. Read through:
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.mythtv.org/wiki/MythTV-HOWTO#Modifying_access_to_the_MySQL_database_for_multiple_systems">http://www.mythtv.org/wiki/MythTV-HOWTO#Modifying_access_to_the_MySQL_database_for_multiple_systems</a>
and update your DB as necessary for your local network,
Cheers,
Nick
</pre>
</blockquote>
<br>
I tried the following without success:<br>
<br>
$ sudo apt-get install mysql-server <br>
Change the bind-address in /etc/mysql/my.cnf to the physical
address (192.168.1.6). <br>
$ sudo /etc/init.d/mysql restart <br>
<br>
$ mysql -u root -p <br>
Enter password: <br>
Welcome to the MySQL monitor. Commands end with ; or \g. <br>
Your MySQL connection id is 98 <br>
Server version: 5.1.49-3 (Debian) <br>
<br>
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights
reserved. <br>
This software comes with ABSOLUTELY NO WARRANTY. This is free
software, <br>
and you are welcome to modify and redistribute it under the GPL v2
license <br>
<br>
Type 'help;' or '\h' for help. Type '\c' to clear the current
input statement. <br>
<br>
mysql> CREATE DATABASE IF NOT EXISTS mythconverg; <br>
Query OK, 1 row affected, 1 warning (0.00 sec) <br>
<br>
mysql> GRANT ALL ON mythconverg.* TO <a moz-do-not-send="true"
rel="nofollow" href="mailto:mythtv@192.168.1.6">mythtv@192.168.1.6</a>
IDENTIFIED BY "mythtv"; <br>
Query OK, 0 rows affected (0.00 sec) <br>
<br>
mysql> FLUSH PRIVILEGES; <br>
Query OK, 0 rows affected (0.00 sec) <br>
<br>
mysql> GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO <a
moz-do-not-send="true" rel="nofollow"
href="mailto:mythtv@192.168.1.6">mythtv@192.168.1.6</a>
IDENTIFIED BY "mythtv"; <br>
Query OK, 0 rows affected (0.00 sec) <br>
<br>
mysql> FLUSH PRIVILEGES; <br>
Query OK, 0 rows affected (0.00 sec) <br>
<br>
mysql> ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8
COLLATE utf8_general_ci; <br>
Query OK, 1 row affected (0.00 sec) <br>
<br>
mysql> exit <br>
<br>
<br>
I have no problem connecting via telnet on port 3306. <br>
<br>
But I can't login <br>
<br>
$ mysql -u mythtv -p -h 192.168.1.6 <br>
Enter password: <br>
ERROR 1045 (28000): Access denied for user 'mythtv'@'192.168.1.6'
(using password: YES) <br>
<br>
$ mysql -u root -p -h 192.168.1.6 <br>
Enter password: <br>
ERROR 1045 (28000): Access denied for user 'root'@'192.168.1.6'
(using password: YES) <br>
<br>
<br>
Also adding my user and mythtv user to the mysql group doesn't
help.<br>
<br>
I really got stuck and have no clue how to continue :-(<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
mythtv-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://www.mythtv.org/mailman/listinfo/mythtv-users">http://www.mythtv.org/mailman/listinfo/mythtv-users</a>
</pre>
</blockquote>
<br>
I finally was able to resolve the problem with the help from the
mythtv-users IRC channel:<br>
<br>
I had to change the bind-address to 0.0.0.0 and straighten
conflicting/extraneous permissions with phpmyadmin.<br>
Now the mythtv users look as follows in phpmyadmin:<br>
<br>
mythtv % Yes ALL PRIVILEGES Yes <br>
mythtv localhost Yes ALL PRIVILEGES Yes<br>
<br>
<br>
Cheers<br>
Ramon<br>
</body>
</html>