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

[gLaNDix (Jesse Kaufman)]

On Jun 1, 2005, at 4:26 PM, Bruce Markey wrote:
> Well, you never gave him a correct answer and appearantly still
> don't know. How long should he continue wasting his time here
> when the authoratative info can be found in seconds at mysql.org?

guess you should've stepped up ages ago and given the correct one than 
letting us waste our time then  ... besides, in your scenario, wouldn't 
video card issues be better served by going to places like htpcnews.com 
or avsforum.com?  cable-related stuff (like cable cards and other 
technology) should stay in cable-related lists ... and heaven forbid 
anyone ask for help getting lirc setup with their remote (at the stages 
before myth is actually involved) ... it happens ... people go off 
topic ... some people try  to help, rather than bitching about a thread 
being too off-topic ... excuse me for attempting to help

>
> Then "kryten" would not be a local connection and 'smeg%' != 'smeg'
> as a match for a specific hostname.

smeg% is a wildcard ... matches smeg followed by anything, just like 
192.168.0.%\


> If there is not an entry for the string used as the hostname in
> a Unix scoket connection, access will be denied.
>
> mysql> delete from user where User='mythtv' and Host='moktoo';
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> flush privileges;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> SELECT Host,User,Password FROM user where user = 'mythtv';
> +-------------+--------+------------------+
> | Host        | User   | Password         |
> +-------------+--------+------------------+
> | 192.168.0.% | mythtv | 0476fc026afffe24 |
> | localhost   | mythtv | 0476fc026afffe24 |
> +-------------+--------+------------------+
> 2 rows in set (0.00 sec)
>
> : bjm at moktoo ; mysql -u mythtv -pmythtv -hmoktoo mythconverg
> ERROR 1045: Access denied for user: 'mythtv at moktoo' (Using password: 
> YES)
> : bjm at moktoo ; mysql -u mythtv -pmythtv -h192.168.0.33 mythconverg
> ERROR 1045: Access denied for user: 'mythtv at moktoo' (Using password: 
> YES)
> : bjm at moktoo ; mysql -u mythtv -pmythtv -hlocalhost mythconverg
> Reading table information for completion of table and column names
> ...
> mysql>

sorry, but here are my results:

mysql> SELECT User,Host FROM user;
+--------+-------------+
| User   | Host        |
+--------+-------------+
| mythtv | 192.168.0.% |
|        | localhost   |
| iCook  | localhost   |
| mythtv | localhost   |
| pma    | localhost   |
| root   | localhost   |
|        | smeg        |
| root   | smeg        |
+--------+-------------+

glandix at smeg glandix $ mysql -u mythtv -h 192.168.0.2 -p
- SUCCESS

glandix at smeg glandix $ mysql -u mythtv -h smeg -p
- SUCCESS

glandix at smeg glandix $ mysql -u mythtv -h smeg.slacknet.local -p
- SUCCESS

glandix at smeg glandix $ mysql -u mythtv -h localhost -p
- SUCCESS

as you can see, i was successfully able to connect w/ -hsmeg, 
-hsmeg.slacknet.local, -h192.168.0.2, and -hlocalhost with only the 
192.168.0.% and localhost entries in the user table ...


just for fun, i changed the 192.168.0.% user to smeg% and deleted the 
mythtv at localhost user so i have the following:

mysql> SELECT User,Host FROM user;
+--------+-----------+
| User   | Host      |
+--------+-----------+
|        | localhost |
| iCook  | localhost |
| pma    | localhost |
| root   | localhost |
|        | smeg      |
| root   | smeg      |
| mythtv | smeg%     |
+--------+-----------+
7 rows in set (0.00 sec)


glandix at smeg glandix $ mysql -u mythtv -h smeg.slacknet.local -p
- SUCCESS

glandix at smeg glandix $ mysql -u mythtv -h smeg -p
- SUCCESS

glandix at smeg glandix $ mysql -u mythtv -h 192.168.0.2 -p
- SUCCESS

glandix at smeg glandix $ mysql -u mythtv -h localhost -p
- FAILED (as expected, due to no localhost entry)

-g-