Boston Linux & UNIX was originally founded in 1994 as part of The Boston Computer Society. We meet on the third Wednesday of each month, online, via Jitsi Meet.

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Discuss] mysql/mariadb



Looks like that MariaDB server was set up to only accept connections
from localhost - it's intended to support only applications running on
the same computer. So it will only accept connections from 127.0.0.1
or perhaps 127.*.*.* - IPv4 reserves the entire 127 block for loopback
connections. IPv6 has only one loopback address, ::1. localhost is
normally set to be 127.0.0.1 in your hosts file.

On Mon, Jun 26, 2017 at 11:03 AM, dan moylan <jdm at moylan.us> wrote:
>
> david writes:
>> On 06/25/2017 03:53 PM, dan moylan wrote:
>>> running on an intel nuc pentium
>
>>> moylan ~[263] uname -a
>>> Linux arcturus 4.11.6-201.fc25.x86_64 #1 SMP Tue Jun 20 20:21:11
>>> UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
>
>>> root ~[144] mysql -u root -p
>>> Enter password:
>>> ERROR 1045 (28000): Access denied for user 'root'@'localhost'
>>> (using password: YES)
>
>>> i've googled for this problem and found no solutions.  i may
>>> remember incorrectly, but i don't believe this has been a
>>> problem in the past.
>
>>> any suggestions as to how to set the root password and get
>>> the mysql prompt?
>
>> Try 192.168.1.1 instead of localhost.
>
> did that:
>
> moylan ~[268] mysql -u root -h192.168.1.17 -p
> Enter password:
> ERROR 1130 (HY000): Host 'arcturas' is not allowed to connect to this MariaDB server
>
> now why would that be?
>
> ole dan
>
> j. daniel moylan
> 84 harvard ave
> brookline, ma 02446-6202
> 617-777-0207 (cel)
> jdm at moylan.us
> www.moylan.us
> [no html pls]
> _______________________________________________
> Discuss mailing list
> Discuss at blu.org
> http://lists.blu.org/mailman/listinfo/discuss



BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org