BLU Discuss list archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Discuss] mysql/mariadb
- Subject: [Discuss] mysql/mariadb
- From: mark at buttery.org (Shirley Márquez Dúlcey)
- Date: Mon, 26 Jun 2017 11:09:48 -0400
- In-reply-to: <20170626150314.GA24238@aldeberon>
- References: <20170626150314.GA24238@aldeberon>
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
- References:
- [Discuss] mysql/mariadb
- From: jdm at moylan.us (dan moylan)
- [Discuss] mysql/mariadb
- Prev by Date: [Discuss] mysql/mariadb
- Next by Date: [Discuss] mysql/mariadb
- Previous by thread: [Discuss] mysql/mariadb
- Next by thread: [Discuss] mysql/mariadb
- Index(es):