I wanted to add a user to a table used by mythtv.
This is what I had before b___d it. +-----------+--------+-----------------------+-------------------------------------------+
| host | user | plugin | authentication_string |
+-----------+--------+-----------------------+-------------------------------------------+
| % | mythtv | mysql_native_password | *F21923DEF11A5686509E3D9DD4C1F5E3AA7D1172 |
| localhost | mythtv | mysql_native_password | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+-----------+--------+-----------------------+-------------------------------------------+
I wanted to add:
+------------+--------+-----------------------+-------------------------------------------+
| host | user | plugin | authentication_string |
+------------+--------+-----------------------+-------------------------------------------+
|192.168.1.% | mythtv | mysql_native_password | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+------------+--------+-----------------------+-------------------------------------------+
by entering:
mysql> CREATE USER 'mythtv'@'albury' IDENTIFIED BY 'mythtv';
I now have:
+-----------+--------+-----------------------+------------------------------------------------------------------------+
| host | user | plugin | authentication_string |
+-----------+--------+-----------------------+------------------------------------------------------------------------+
| % | mythtv | mysql_native_password | *F21923DEF11A5686509E3D9DD4C1F5E3AA7D1172 |
ZUNlVAD. | mythtv | caching_sha2_password | $A$005$a22dS "XjVzi1k.nfGtLdjcUSHinJ3XhopdDalbSDpvnQU4ge69 |
| localhost | mythtv | mysql_native_password | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+-----------+--------+-----------------------+------------------------------------------------------------------------+
I need to get rid of the middle record but I cannot get the syntax right.
I tried::
mysql> DROP USER 'mythtv'@'192.168.1.5' WHERE host=("ZUNlVAD.");
mysql> DROP USER 'mythtv' WHERE AUTHENTICATION_STRING="$A$005$a22dS"XjVzi1k.nfGtLdjcUSHinJ3XhopdDalbSDpvnQU4ge69";
mysql> DROP USER 'mythtv' WHERE AUTHENTICATION_STRING="($A$005$a22dS"XjVzi1k.nfGtLdjcUSHinJ3XhopdDalbSDpvnQU4ge69)";
mysql> DROP USER 'mythtv' WHERE HOST<> "%" and host <> "LOCALHOST";
but I just get rebukes.
Can anybody help?
TIA
Alan
I wanted to add a user to a table used by mythtv.
This is what I had before b___d it. +-----------+--------+-----------------------+-------------------------------------------+
| host | user | plugin | authentication_string |
+-----------+--------+-----------------------+-------------------------------------------+
| % | mythtv | mysql_native_password | *F21923DEF11A5686509E3D9DD4C1F5E3AA7D1172 |
| localhost | mythtv | mysql_native_password | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+-----------+--------+-----------------------+-------------------------------------------+
I wanted to add:
+------------+--------+-----------------------+-------------------------------------------+
| host | user | plugin | authentication_string |
+------------+--------+-----------------------+-------------------------------------------+
|192.168.1.% | mythtv | mysql_native_password | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+------------+--------+-----------------------+-------------------------------------------+
by entering:
mysql> CREATE USER 'mythtv'@'albury' IDENTIFIED BY 'mythtv';
I now have:
+-----------+--------+-----------------------+------------------------------------------------------------------------+
| host | user | plugin | authentication_string |
+-----------+--------+-----------------------+------------------------------------------------------------------------+
| % | mythtv | mysql_native_password | *F21923DEF11A5686509E3D9DD4C1F5E3AA7D1172 |
ZUNlVAD. | mythtv | caching_sha2_password | $A$005$a22dS "XjVzi1k.nfGtLdjcUSHinJ3XhopdDalbSDpvnQU4ge69 |
| localhost | mythtv | mysql_native_password | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+-----------+--------+-----------------------+------------------------------------------------------------------------+
I need to get rid of the middle record but I cannot get the syntax right.
I tried::
mysql> DROP USER 'mythtv'@'192.168.1.5' WHERE host=("ZUNlVAD.");
mysql> DROP USER 'mythtv' WHERE AUTHENTICATION_STRING="$A$005$a22dS"XjVzi1k.nfGtLdjcUSHinJ3XhopdDalbSDpvnQU4ge69";
mysql> DROP USER 'mythtv' WHERE AUTHENTICATION_STRING="($A$005$a22dS"XjVzi1k.nfGtLdjcUSHinJ3XhopdDalbSDpvnQU4ge69)";
mysql> DROP USER 'mythtv' WHERE HOST<> "%" and host <> "LOCALHOST";
but I just get rebukes.
Can anybody help?
TIA
Alan
GRANT ALL ON mythtv.* to 'mythtv'@'192.168.1.%' IDENTIFIED BY 'mythtv'
WITH GRANT OPTION;
FLUSH PRIVILEGES;
I wanted to add a user to a table used by mythtv.
This is what I had before b___d it. +-----------+--------+-----------------------+-------------------------------------------+
| host | user | plugin | authentication_string |
+-----------+--------+-----------------------+-------------------------------------------+
| % | mythtv | mysql_native_password | *F21923DEF11A5686509E3D9DD4C1F5E3AA7D1172 |
| localhost | mythtv | mysql_native_password | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+-----------+--------+-----------------------+-------------------------------------------+
I wanted to add:
+------------+--------+-----------------------+-------------------------------------------+
| host | user | plugin | authentication_string |
+------------+--------+-----------------------+-------------------------------------------+
|192.168.1.% | mythtv | mysql_native_password | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+------------+--------+-----------------------+-------------------------------------------+
by entering:
mysql> CREATE USER 'mythtv'@'albury' IDENTIFIED BY 'mythtv';
I now have:
+-----------+--------+-----------------------+------------------------------------------------------------------------+
| host | user | plugin | authentication_string |
+-----------+--------+-----------------------+------------------------------------------------------------------------+
| % | mythtv | mysql_native_password | *F21923DEF11A5686509E3D9DD4C1F5E3AA7D1172 |
ZUNlVAD. | mythtv | caching_sha2_password | $A$005$a22dS "XjVzi1k.nfGtLdjcUSHinJ3XhopdDalbSDpvnQU4ge69 |
| localhost | mythtv | mysql_native_password | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+-----------+--------+-----------------------+------------------------------------------------------------------------+
I need to get rid of the middle record but I cannot get the syntax right.
I tried::
mysql> DROP USER 'mythtv'@'192.168.1.5' WHERE host=("ZUNlVAD.");
mysql> DROP USER 'mythtv' WHERE AUTHENTICATION_STRING="$A$005$a22dS"XjVzi1k.nfGtLdjcUSHinJ3XhopdDalbSDpvnQU4ge69";
mysql> DROP USER 'mythtv' WHERE AUTHENTICATION_STRING="($A$005$a22dS"XjVzi1k.nfGtLdjcUSHinJ3XhopdDalbSDpvnQU4ge69)";
mysql> DROP USER 'mythtv' WHERE HOST<> "%" and host <> "LOCALHOST";
but I just get rebukes.
Here in the US we have something called Over The Air Broadcast,
where you can use an old rabbit ear antenna and get depending on your distance from the transmitter 30-40 channels. It is what is called
'cut the cable'.
On Tue, 20 Feb 2024 16:54:41 -0500, pinnerite <pinnerite@gmail.com> wrote:
I wanted to add a user to a table used by mythtv.
This is what I had before b___d it. +-----------+--------+-----------------------+-------------------------------------------+
| host | user | plugin | authentication_string |
+-----------+--------+-----------------------+-------------------------------------------+
| % | mythtv | mysql_native_password | *F21923DEF11A5686509E3D9DD4C1F5E3AA7D1172 |
| localhost | mythtv | mysql_native_password | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+-----------+--------+-----------------------+-------------------------------------------+
I wanted to add:
+------------+--------+-----------------------+-------------------------------------------+
| host | user | plugin | authentication_string |
+------------+--------+-----------------------+-------------------------------------------+
|192.168.1.% | mythtv | mysql_native_password | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+------------+--------+-----------------------+-------------------------------------------+
by entering:
mysql> CREATE USER 'mythtv'@'albury' IDENTIFIED BY 'mythtv';
I now have:
+-----------+--------+-----------------------+------------------------------------------------------------------------+
| host | user | plugin | authentication_string |
+-----------+--------+-----------------------+------------------------------------------------------------------------+
| % | mythtv | mysql_native_password | *F21923DEF11A5686509E3D9DD4C1F5E3AA7D1172 |
ZUNlVAD. | mythtv | caching_sha2_password | $A$005$a22dS "XjVzi1k.nfGtLdjcUSHinJ3XhopdDalbSDpvnQU4ge69 |
| localhost | mythtv | mysql_native_password | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+-----------+--------+-----------------------+------------------------------------------------------------------------+
I need to get rid of the middle record but I cannot get the syntax right.
I tried::
mysql> DROP USER 'mythtv'@'192.168.1.5' WHERE host=("ZUNlVAD.");
mysql> DROP USER 'mythtv' WHERE AUTHENTICATION_STRING="$A$005$a22dS"XjVzi1k.nfGtLdjcUSHinJ3XhopdDalbSDpvnQU4ge69";
mysql> DROP USER 'mythtv' WHERE AUTHENTICATION_STRING="($A$005$a22dS"XjVzi1k.nfGtLdjcUSHinJ3XhopdDalbSDpvnQU4ge69)";
mysql> DROP USER 'mythtv' WHERE HOST<> "%" and host <> "LOCALHOST";
but I just get rebukes.
DROP is used to delete a table, database, or index.
To delete an authorization, use REVOKE. https://www.techonthenet.com/mysql/grant_revoke.php
Regards, Dave Hodgins
On 2/20/24 4:54 PM, pinnerite wrote:
I wanted to add a user to a table used by mythtv.
This is what I had before b___d it. +-----------+--------+-----------------------+-------------------------------------------+
| host | user | plugin | authentication_string |
+-----------+--------+-----------------------+-------------------------------------------+
| % | mythtv | mysql_native_password | *F21923DEF11A5686509E3D9DD4C1F5E3AA7D1172 |
| localhost | mythtv | mysql_native_password | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+-----------+--------+-----------------------+-------------------------------------------+
I wanted to add:
+------------+--------+-----------------------+-------------------------------------------+
| host | user | plugin | authentication_string |
+------------+--------+-----------------------+-------------------------------------------+
|192.168.1.% | mythtv | mysql_native_password | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+------------+--------+-----------------------+-------------------------------------------+
by entering:
mysql> CREATE USER 'mythtv'@'albury' IDENTIFIED BY 'mythtv';
I now have:
+-----------+--------+-----------------------+------------------------------------------------------------------------+
| host | user | plugin | authentication_string |
+-----------+--------+-----------------------+------------------------------------------------------------------------+
| % | mythtv | mysql_native_password | *F21923DEF11A5686509E3D9DD4C1F5E3AA7D1172 |
ZUNlVAD. | mythtv | caching_sha2_password | $A$005$a22dS "XjVzi1k.nfGtLdjcUSHinJ3XhopdDalbSDpvnQU4ge69 |
| localhost | mythtv | mysql_native_password | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+-----------+--------+-----------------------+------------------------------------------------------------------------+
I need to get rid of the middle record but I cannot get the syntax right.
I tried::
mysql> DROP USER 'mythtv'@'192.168.1.5' WHERE host=("ZUNlVAD.");
mysql> DROP USER 'mythtv' WHERE AUTHENTICATION_STRING="$A$005$a22dS"XjVzi1k.nfGtLdjcUSHinJ3XhopdDalbSDpvnQU4ge69";
mysql> DROP USER 'mythtv' WHERE AUTHENTICATION_STRING="($A$005$a22dS"XjVzi1k.nfGtLdjcUSHinJ3XhopdDalbSDpvnQU4ge69)";
mysql> DROP USER 'mythtv' WHERE HOST<> "%" and host <> "LOCALHOST";
but I just get rebukes.
Can anybody help?
TIA
Alan
Here in the US we have something called Over The Air Broadcast, where
you can use an old rabbit ear antenna and get depending on your distance from the transmitter 30-40 channels. It is what is called 'cut the cable'.
Jonathan N. Little wrote:
Oh I was assuming you previously set to the mysql db first:
USE mysql;
GRANT ALL ON mythtv.* to 'mythtv'@'192.168.1.%' IDENTIFIED BY 'mythtv'
WITH GRANT OPTION;
FLUSH PRIVILEGES;
--
Take care,
Jonathan
-------------------
LITTLE WORKS STUDIO
http://www.LittleWorksStudio.com
If all your OTA stations are in the UHF band, a basic Gray-Hoverman is enough.
Not having to support VHF frequencies, makes antennas a lot simpler.
https://www.pinterest.com/pin/1196337389367787/
Some of the more interesting home antennas, used coat hanger wire and foil for a ground plane 🙂 Just about anything that conducts, will pick up a signal at 200MHz, so even if you lack any sort of construction skills,
the antenna will still pick something up.
The adjustable part of the rabbit ears, is mainly for VHF. If you shorten
the ears, that shifts reception a bit higher in frequency. The loop near
the core of the device, is more intended for UHF.
Instead of rabbit ears, this will work. The RadioShack double-bow-tie.
You can tell from the feet on it, it wasn't really meant for outdoors.
Some of the facets of construction might fool you into thinking that
(it uses rivets, like a real antenna).
https://img0.etsystatic.com/000/0/5583309/il_570xN.120479388.jpg
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 482 |
Nodes: | 16 (3 / 13) |
Uptime: | 61:54:52 |
Calls: | 9,569 |
Calls today: | 3 |
Files: | 13,663 |
Messages: | 6,143,525 |