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)
: [EMAIL PROTECTED] ; mysql -u mythtv -pmythtv -hmoktoo mythconverg
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
: [EMAIL PROTECTED] ; mysql -u mythtv -pmythtv -h192.168.0.33 mythconverg
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
: [EMAIL PROTECTED] ; 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 |
+--------+-------------+
[EMAIL PROTECTED] glandix $ mysql -u mythtv -h 192.168.0.2 -p
- SUCCESS
[EMAIL PROTECTED] glandix $ mysql -u mythtv -h smeg -p
- SUCCESS
[EMAIL PROTECTED] glandix $ mysql -u mythtv -h smeg.slacknet.local -p
- SUCCESS
[EMAIL PROTECTED] 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
[EMAIL PROTECTED] 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)
[EMAIL PROTECTED] glandix $ mysql -u mythtv -h smeg.slacknet.local -p
- SUCCESS
[EMAIL PROTECTED] glandix $ mysql -u mythtv -h smeg -p
- SUCCESS
[EMAIL PROTECTED] glandix $ mysql -u mythtv -h 192.168.0.2 -p
- SUCCESS
[EMAIL PROTECTED] glandix $ mysql -u mythtv -h localhost -p
- FAILED (as expected, due to no localhost entry)
-g-
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
