Re: [Discuss] mysql/mariadb

2017-06-26 Thread Greg Rundlett (freephile)
As Joe Polcari pointed to, the trick is to start the server with the option to skip the grant tables. mysqld_safe --skip-grant-tables & Then you just login without any password. (mysql -u root) Set the root password. (exit) Stop the server. Start it normally. Greg Rundlett

Re: [Discuss] mysql/mariadb

2017-06-26 Thread John Abreau
OK, I gave it a try and it didn't work. The following got it working. FYI, mysql --version shows mysql Ver 15.1 Distrib 10.1.21-MariaDB, for Linux (x86_64) using EditLine wrapper sudo systemctl stop mariadb sudo mysqld_safe & mysql -u root set password for 'root'@'localhost' =

Re: [Discuss] mysql/mariadb

2017-06-26 Thread Rich Braun
There is a difference between "localhost" and "socket" access. Probably if you're running a new installation, you want to access root by the mysql.sock file on the server. mysql -u root -p -S /tmp/mysql.sock That file is placed in a location that depends on your particular distro. Look for it

Re: [Discuss] mysql/mariadb

2017-06-26 Thread Joe Polcari
Check the section on Recovering the password https://www.howtoforge.com/setting-changing-resetting-mysql-root-passwords On 6/26/17, 12:21 PM, "Discuss on behalf of dan moylan" wrote: > >john abreau writes: >> On Sun, Jun 25,

Re: [Discuss] mysql/mariadb

2017-06-26 Thread dan moylan
john abreau writes: > On Sun, Jun 25, 2017 at 3: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

Re: [Discuss] mysql/mariadb

2017-06-26 Thread Eric Chadbourne
What is "arcturus" GNU/Linux? Do they have documentation? Set up is usually straight forward with Ubuntu. sudo dpkg-reconfigure mysql-server-5.5 REF: https://help.ubuntu.com/14.04/serverguide/mysql.html Thanks, [Eric Chadbourne](http://erics.website)

Re: [Discuss] mysql/mariadb

2017-06-26 Thread Shirley Márquez Dúlcey
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

Re: [Discuss] mysql/mariadb

2017-06-26 Thread dan moylan
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

Re: [Discuss] mysql/mariadb

2017-06-26 Thread John Abreau
Here's what a google search turned up: https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password On Sun, Jun 25, 2017 at 3:53 PM, dan moylan wrote: > > running on an intel nuc pentium > > moylan ~[263] uname -a > Linux arcturus

Re: [Discuss] mysql/mariadb

2017-06-26 Thread David Kramer
Try 192.168.1.1 instead of localhost. 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