[mythtv-users] How do I removed existing mysql database and start over?

[Bruce Markey]

First of all, this is myTHTV.org, If you want authoratative
info for mysql, you would be best served by mySQL.org...

Mark Knecht wrote:
...
> mark at gandalf ~ $ mysql -u mythtv -h 192.168.1.2 -p mythconverg
> Enter password:
> ERROR 1045: Access denied for user: 'mythtv at gandalf' (Using password: YES)
> mark at gandalf ~ $

Which says that you connected to the server process but it
does not allow access for "mythtv" [sic] for a connection from
host "gandalf" [sic]. "gandalf" is not a remote IP connection
and it is not "localhost".

> mysql> SELECT Host,User,Password FROM user;
> +-------------+--------+------------------+
> | Host        | User   | Password         |
> +-------------+--------+------------------+
> | localhost   | root   | 4849c7517ff2d641 |
> | gandalf     | root   |                  |
> | localhost   |        |                  |
> | gandalf     |        |                  |
> | localhost   | mythtv | 0476fc026afffe24 |
> | 192.168.1.% | mythtv | 0476fc026afffe24 |
> +-------------+--------+------------------+

Do you see " | gandalf     | mythtv | 0476fc026afffe24 |"?

Most likely you've been assuming that the IP wildcard will match
for the IP of the local connection but it does not. Notice that
"root" and "" both have entries for "gandalf" and "localhost".

mysql> SELECT Host,User,Password FROM user where user = 'mythtv';
+-------------+--------+------------------+
| Host        | User   | Password         |
+-------------+--------+------------------+
| 192.168.0.% | mythtv | 0476fc026afffe24 |
| nordtv      | mythtv | 0476fc026afffe24 |
| localhost   | mythtv | 0476fc026afffe24 |
+-------------+--------+------------------+
3 rows in set (0.00 sec)

mysql> quit
Bye
: bjm at nordtv ;

If I dropped the entry for "nordtv" I could connect from any other
host on the subnet but not make a local connection when logged into
"nordtv".

--  bjm