novaBBS - alt.os.linux.ubuntu - Re: MySQL problem

MySQL problem

<20240220215441.a52210ec19420f2f0a7f1cf7@gmail.com>

https://www.novabbs.com/computers/article-flat.php?id=3855&group=alt.os.linux.ubuntu#3855

copy link Newsgroups: alt.os.linux.mint alt.os.linux.ubuntu alt.os.linux.mageia

Path: i2pn2.org!i2pn.org!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: pinner...@gmail.com (pinnerite)
Newsgroups: alt.os.linux.mint,alt.os.linux.ubuntu,alt.os.linux.mageia
Subject: MySQL problem
Date: Tue, 20 Feb 2024 21:54:41 +0000
Organization: A noiseless patient Spider
Lines: 55
Message-ID: <20240220215441.a52210ec19420f2f0a7f1cf7@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: dont-email.me; posting-host="e9b12e2e9753c5c4f1363029c8fd363a";
logging-data="2856866"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18NPmAXvjuO6IIY1d21jKy7IQHi23nf5Xs="
Cancel-Lock: sha1:C2eTyFC4sb7nHrXJTuivXxaZGT8=
X-Newsreader: Sylpheed 3.7.0 (GTK+ 2.24.33; x86_64-pc-linux-gnu)

by: pinnerite - Tue, 20 Feb 2024 21:54 UTC

I wanted to add a user to a table used by mythtv.

I wanted to add:

by entering:
mysql> CREATE USER 'mythtv'@'albury' IDENTIFIED BY 'mythtv';

I now have:

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

--
Linux Mint 21.1 kernel version 5.15.0-94-generic Cinnamon 5.6.8
AMD Phenom II x4 955 CPU 16Gb Dram 2TB Barracuda

Re: MySQL problem

<tp9BN.268345$vFZa.138380@fx13.iad>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=3856&group=alt.os.linux.ubuntu#3856

copy link Newsgroups: alt.os.linux.mint alt.os.linux.ubuntu alt.os.linux.mageia

Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!panix!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!fx13.iad.POSTED!not-for-mail
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
Thunderbird/102.13.0
Reply-To: Nic@none.invalid
Subject: Re: MySQL problem
Content-Language: en-US
Newsgroups: alt.os.linux.mint,alt.os.linux.ubuntu,alt.os.linux.mageia
References: <20240220215441.a52210ec19420f2f0a7f1cf7@gmail.com>
From: Nic...@none.invalid (Nic)
Organization: Arm Chair Observer
In-Reply-To: <20240220215441.a52210ec19420f2f0a7f1cf7@gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 56
Message-ID: <tp9BN.268345$vFZa.138380@fx13.iad>
X-Complaints-To: abuse(at)newshosting.com
NNTP-Posting-Date: Tue, 20 Feb 2024 22:08:25 UTC
Date: Tue, 20 Feb 2024 17:08:25 -0500
X-Received-Bytes: 3734

by: Nic - Tue, 20 Feb 2024 22:08 UTC

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'.

Re: MySQL problem

<ur38d0$2nejq$1@dont-email.me>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=3857&group=alt.os.linux.ubuntu#3857

copy link Newsgroups: alt.os.linux.mint alt.os.linux.ubuntu alt.os.linux.mageia

Path: i2pn2.org!i2pn.org!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: lws4...@gmail.com (Jonathan N. Little)
Newsgroups: alt.os.linux.mint,alt.os.linux.ubuntu,alt.os.linux.mageia
Subject: Re: MySQL problem
Date: Tue, 20 Feb 2024 17:17:02 -0500
Organization: LITTLE WORKS STUDIO
Lines: 71
Message-ID: <ur38d0$2nejq$1@dont-email.me>
References: <20240220215441.a52210ec19420f2f0a7f1cf7@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Injection-Date: Tue, 20 Feb 2024 22:17:04 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="ba6f4c805202f7fa5dafa3faecad4b03";
logging-data="2865786"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+SYxU/GCIWxWKTy1s3mJ4BN6eHSpq3d0c="
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101
Firefox/91.0 SeaMonkey/2.53.18.1
Cancel-Lock: sha1:38PrLeQQP+t4C5K5tw3TdeFC4Ps=
X-Dan: Yes Dan this is a Winbox
In-Reply-To: <20240220215441.a52210ec19420f2f0a7f1cf7@gmail.com>
X-Face: o[H8T0h*NGH`K`P)s+4PmYlcy|GNl`~+L6Fi.m:%15m[c%{C7V-ump|WiCYPkQ+hFJhq;XW5^1Rg_El'"fE$~AcYW$Pq\yeh9K_-dJqlQ5\y2\;[yw5DYCtOtsf_.TUy}0U\oL^>[3Y#{AP2^o'bG`bwj`]]UNpCxY\(~xK9b+uZKxrb*4-rkD+

by: Jonathan N. Little - Tue, 20 Feb 2024 22:17 UTC

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
>

Okay I am assuming mythtv need to have all permissions on mythtv
database and be accessible from a device on your LAN |192.168.1.0.

GRANT ALL ON MythTV_DB.* to 'MythTV_DB_User'@'192.168.1.%' IDENTIFIED BY
'MythTV_User_Password' WITH GRANT OPTION

So since it looks like you are using "mythtv" for all three, DB, User
and Password use below:

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

Re: MySQL problem

<ur38hj$2nejq$2@dont-email.me>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=3858&group=alt.os.linux.ubuntu#3858

copy link Newsgroups: alt.os.linux.mint alt.os.linux.ubuntu alt.os.linux.mageia

Path: i2pn2.org!i2pn.org!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: lws4...@gmail.com (Jonathan N. Little)
Newsgroups: alt.os.linux.mint,alt.os.linux.ubuntu,alt.os.linux.mageia
Subject: Re: MySQL problem
Date: Tue, 20 Feb 2024 17:19:30 -0500
Organization: LITTLE WORKS STUDIO
Lines: 19
Message-ID: <ur38hj$2nejq$2@dont-email.me>
References: <20240220215441.a52210ec19420f2f0a7f1cf7@gmail.com>
<ur38d0$2nejq$1@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Injection-Date: Tue, 20 Feb 2024 22:19:31 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="ba6f4c805202f7fa5dafa3faecad4b03";
logging-data="2865786"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+U1FadY/iyxQZdNbbhEorrmooATTC52HU="
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101
Firefox/91.0 SeaMonkey/2.53.18.1
Cancel-Lock: sha1:gvYynAdJjqcNIxUs3M/vNxde9iU=
X-Face: o[H8T0h*NGH`K`P)s+4PmYlcy|GNl`~+L6Fi.m:%15m[c%{C7V-ump|WiCYPkQ+hFJhq;XW5^1Rg_El'"fE$~AcYW$Pq\yeh9K_-dJqlQ5\y2\;[yw5DYCtOtsf_.TUy}0U\oL^>[3Y#{AP2^o'bG`bwj`]]UNpCxY\(~xK9b+uZKxrb*4-rkD+
In-Reply-To: <ur38d0$2nejq$1@dont-email.me>
X-Dan: Yes Dan this is a Winbox

by: Jonathan N. Little - Tue, 20 Feb 2024 22:19 UTC

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

Re: MySQL problem

<op.2jgpqa2pa3w0dxdave@hodgins.homeip.net>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=3859&group=alt.os.linux.ubuntu#3859

copy link Newsgroups: alt.os.linux.mint alt.os.linux.ubuntu alt.os.linux.mageia

Path: i2pn2.org!i2pn.org!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: dwhodg...@nomail.afraid.org (David W. Hodgins)
Newsgroups: alt.os.linux.mint,alt.os.linux.ubuntu,alt.os.linux.mageia
Subject: Re: MySQL problem
Date: Tue, 20 Feb 2024 17:50:24 -0500
Organization: A noiseless patient Spider
Lines: 49
Message-ID: <op.2jgpqa2pa3w0dxdave@hodgins.homeip.net>
References: <20240220215441.a52210ec19420f2f0a7f1cf7@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed; delsp=yes
Content-Transfer-Encoding: 8bit
Injection-Info: dont-email.me; posting-host="212d43178ae7ae5c2947a4e74f9625a6";
logging-data="2878259"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18SB0jF+Nwpsu4c3EQCCIO1KWNfrDyU9hc="
User-Agent: Opera Mail/12.16 (Linux)
Cancel-Lock: sha1:Cp2ieGE7laz/fy4NBXwMeLIHpxU=

by: David W. Hodgins - Tue, 20 Feb 2024 22:50 UTC

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

Re: MySQL problem

<ur45of$2vuft$1@dont-email.me>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=3860&group=alt.os.linux.ubuntu#3860

copy link Newsgroups: alt.os.linux.mint alt.os.linux.ubuntu alt.os.linux.mageia

Path: i2pn2.org!i2pn.org!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: nos...@needed.invalid (Paul)
Newsgroups: alt.os.linux.mint,alt.os.linux.ubuntu,alt.os.linux.mageia
Subject: Re: MySQL problem
Date: Wed, 21 Feb 2024 01:38:06 -0500
Organization: A noiseless patient Spider
Lines: 42
Message-ID: <ur45of$2vuft$1@dont-email.me>
References: <20240220215441.a52210ec19420f2f0a7f1cf7@gmail.com>
<tp9BN.268345$vFZa.138380@fx13.iad>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Injection-Date: Wed, 21 Feb 2024 06:38:08 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="8793e88784abf669263759ea515a7153";
logging-data="3144189"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+no06Wwuv0DdBvxTScVcNQKv9Ew1kKux0="
User-Agent: Ratcatcher/2.0.0.25 (Windows/20130802)
Cancel-Lock: sha1:a8TWah+CqBXVxbMnPL14l59Vomc=
Content-Language: en-US
In-Reply-To: <tp9BN.268345$vFZa.138380@fx13.iad>
X-Mozilla-News-Host: news://nntp.aioe.org

by: Paul - Wed, 21 Feb 2024 06:38 UTC

On 2/20/2024 5:08 PM, Nic wrote:

> 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'.

Alan has at least two options. There is Freeview satellite and
there is OTA from Crystal Palace. He is likely recording from
Crystal Palace.

*******

Sometimes a directional antenna cuts down on OTA multipath problems.
This works a little better than a rabbit ears.

[Picture] Combo VHF/UHF antenna (Gray-Hoverman, Narod, added VHF elements)

https://i.postimg.cc/SxsBtCQq/tv-antenna.gif

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

Paul

Re: MySQL problem

<20240221102113.41a84c88c8676e907d3ed706@gmail.com>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=3861&group=alt.os.linux.ubuntu#3861

copy link Newsgroups: alt.os.linux.mint alt.os.linux.ubuntu alt.os.linux.mageia

Path: i2pn2.org!i2pn.org!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: pinner...@gmail.com (pinnerite)
Newsgroups: alt.os.linux.mint,alt.os.linux.ubuntu,alt.os.linux.mageia
Subject: Re: MySQL problem
Date: Wed, 21 Feb 2024 10:21:13 +0000
Organization: A noiseless patient Spider
Lines: 62
Message-ID: <20240221102113.41a84c88c8676e907d3ed706@gmail.com>
References: <20240220215441.a52210ec19420f2f0a7f1cf7@gmail.com>
<op.2jgpqa2pa3w0dxdave@hodgins.homeip.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: dont-email.me; posting-host="813bf4f3a35bdfb887ed34d307e32c8f";
logging-data="3227550"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19DMvoeZzYBWn5rYAUBtcagRb7L4WigTs4="
Cancel-Lock: sha1:14lNrnlCGoQDMhPfTA7WufSvoQI=
X-Newsreader: Sylpheed 3.7.0 (GTK+ 2.24.33; x86_64-pc-linux-gnu)

by: pinnerite - Wed, 21 Feb 2024 10:21 UTC

On Tue, 20 Feb 2024 17:50:24 -0500
"David W. Hodgins" <dwhodgins@nomail.afraid.org> wrote:

> 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

Thank you David. That isreally helpful.

Regards, Alan

--
Linux Mint 21.1 kernel version 5.15.0-94-generic Cinnamon 5.6.8
AMD Phenom II x4 955 CPU 16Gb Dram 2TB Barracuda

Re: MySQL problem

<20240221103543.24c178907dd6ae44ef5c142c@gmail.com>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=3862&group=alt.os.linux.ubuntu#3862

copy link Newsgroups: alt.os.linux.mint alt.os.linux.ubuntu alt.os.linux.mageia

Path: i2pn2.org!i2pn.org!news.chmurka.net!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: pinner...@gmail.com (pinnerite)
Newsgroups: alt.os.linux.mint,alt.os.linux.ubuntu,alt.os.linux.mageia
Subject: Re: MySQL problem
Date: Wed, 21 Feb 2024 10:35:43 +0000
Organization: A noiseless patient Spider
Lines: 70
Message-ID: <20240221103543.24c178907dd6ae44ef5c142c@gmail.com>
References: <20240220215441.a52210ec19420f2f0a7f1cf7@gmail.com>
<tp9BN.268345$vFZa.138380@fx13.iad>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: dont-email.me; posting-host="813bf4f3a35bdfb887ed34d307e32c8f";
logging-data="3235181"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+jNNbabWDA4PrL6wSicgAA+piQnefrzYA="
Cancel-Lock: sha1:6Qolhemy8q3J6PUnD+B0CdpLa1Y=
X-Newsreader: Sylpheed 3.7.0 (GTK+ 2.24.33; x86_64-pc-linux-gnu)

by: pinnerite - Wed, 21 Feb 2024 10:35 UTC

On Tue, 20 Feb 2024 17:08:25 -0500
Nic <Nic@none.invalid> wrote:

> 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'.

Thank you but I think there must have been a phaae difference between
sending my question and your receipt of it.

Alan :)

--
Linux Mint 21.1 kernel version 5.15.0-94-generic Cinnamon 5.6.8
AMD Phenom II x4 955 CPU 16Gb Dram 2TB Barracuda

Re: MySQL problem

<20240221103649.815da7047387bc34cb2b9095@gmail.com>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=3863&group=alt.os.linux.ubuntu#3863

copy link Newsgroups: alt.os.linux.mint alt.os.linux.ubuntu alt.os.linux.mageia

Path: i2pn2.org!i2pn.org!news.samoylyk.net!nyheter.lysator.liu.se!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: pinner...@gmail.com (pinnerite)
Newsgroups: alt.os.linux.mint,alt.os.linux.ubuntu,alt.os.linux.mageia
Subject: Re: MySQL problem
Date: Wed, 21 Feb 2024 10:36:49 +0000
Organization: A noiseless patient Spider
Lines: 31
Message-ID: <20240221103649.815da7047387bc34cb2b9095@gmail.com>
References: <20240220215441.a52210ec19420f2f0a7f1cf7@gmail.com>
<ur38d0$2nejq$1@dont-email.me>
<ur38hj$2nejq$2@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: dont-email.me; posting-host="813bf4f3a35bdfb887ed34d307e32c8f";
logging-data="3235181"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18Op+pAdzE9YD39KqCeZF9CWkScl4qc+H8="
Cancel-Lock: sha1:GDXkxkwtVxFNdqd+4PhcL0skaqk=
X-Newsreader: Sylpheed 3.7.0 (GTK+ 2.24.33; x86_64-pc-linux-gnu)

by: pinnerite - Wed, 21 Feb 2024 10:36 UTC

On Tue, 20 Feb 2024 17:19:30 -0500
"Jonathan N. Little" <lws4art@gmail.com> wrote:

> 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

Thank you,

Alan

--
Linux Mint 21.1 kernel version 5.15.0-94-generic Cinnamon 5.6.8
AMD Phenom II x4 955 CPU 16Gb Dram 2TB Barracuda

Re: MySQL problem

<ur7t7a$3ve4f$1@dont-email.me>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=3864&group=alt.os.linux.ubuntu#3864

copy link Newsgroups: alt.os.linux.mint alt.os.linux.ubuntu alt.os.linux.mageia

Path: i2pn2.org!i2pn.org!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: TJ...@noneofyour.business (TJ)
Newsgroups: alt.os.linux.mint,alt.os.linux.ubuntu,alt.os.linux.mageia
Subject: Re: MySQL problem
Date: Thu, 22 Feb 2024 11:36:56 -0500
Organization: A noiseless patient Spider
Lines: 42
Message-ID: <ur7t7a$3ve4f$1@dont-email.me>
References: <20240220215441.a52210ec19420f2f0a7f1cf7@gmail.com>
<tp9BN.268345$vFZa.138380@fx13.iad> <ur45of$2vuft$1@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Thu, 22 Feb 2024 16:36:58 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="273bd47c7458f20ca02e3305ba5ae6ec";
logging-data="4176015"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18knkgvx2B3x25om1gXByc2Vpm2d6OE/1k="
User-Agent: Mozilla Thunderbird
Cancel-Lock: sha1:6OzeMpjT1drEos543XJX1HQJWW0=
Content-Language: en-US
In-Reply-To: <ur45of$2vuft$1@dont-email.me>

by: TJ - Thu, 22 Feb 2024 16:36 UTC

On 2024-02-21 01:38, Paul wrote:
> 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

I have an old ATSC tuner on a PCI card, but I was never able to figure
out how to make mythTV work with it. I did manage to make it work
somewhat with Kaffeine, but it never worked well. I think my hardware at
the time was just too old and slow.

I have better hardware now, and that might make the difference, but
quite frankly, for me it's just too much trouble. I bought a
PVR/converter box on Amazon that will record for me on a USB device,
which I can later play back using the PVR, or on a Linux box with vlc.

I'm not too far from the various transmitters, and use a flat antenna
that's about the size of a sheet of common office paper. It comes with
an optional amplifier that's powered by a usb source. It does a great
job, but as with all indoor antennas, placement is key. It can work well
in one spot, but move it even a few inches from that spot, and it won't.

(BTW, also using this post to test Usenet operation of the latest
Thunderbird update candidate for Mageia)

"It's not just a computer -- it's your ass." -- Cal Keegan

computers / alt.os.linux.ubuntu / Re: MySQL problem

Subject	Author
MySQL problem	pinnerite
Re: MySQL problem	Nic
Re: MySQL problem	Paul
Re: MySQL problem	TJ
Re: MySQL problem	pinnerite
Re: MySQL problem	Jonathan N. Little
Re: MySQL problem	Jonathan N. Little
Re: MySQL problem	pinnerite
Re: MySQL problem	David W. Hodgins
Re: MySQL problem	pinnerite