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
https://eQuality-Tech.
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' = password(
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 und
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, 2017 at 3:53 PM, dan moylan wrote:
>
>>> running on an intel nuc pen
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 -p
>> Enter pass
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)
_
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 h
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 (
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 4.11.6-201.fc25.x86_64 #1
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 10
10 matches
Mail list logo