Mailinglist Archive: opensuse-factory (649 mails)

< Previous Next >
[opensuse-factory] Re: MariaDB 10.1.25 openSUSE package - unable to set root password ..
thanks for reply

so no password set to ....

but i think i found something.
By default marriadb uses "unix_socket" authentication plugin to set
passwords
this should be "mysql_native_password" so

switch database..
use mysatabase;

first see witch plugin is set..
SELECT user, plugin FROM user;

set it to "mysql_native_password"
UPDATE user SET plugin="mysql_native_password";

set new password...
update user set authentication_string=password('My@Password'),
plugin='mysql_native_password' where user='root';

result:

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 6
Server version: 10.1.25-MariaDB openSUSE package
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

MariaDB [(none)]> SELECT User, Host, HEX(authentication_string) FROM
mysql.user;
+------+------------+-------------------------------------------------------------------------------------------------------------------------------------------------+
| User | Host | HEX(authentication_string)


|
+------+------------+-------------------------------------------------------------------------------------------------------------------------------------------------+
| root | localhost |
2A36424341304439423741313533304141353235354643323436313441464437333933463745414242
|
| root | 127.0.0.1 |
2A36424341304439423741313533304141353235354643323436313441464437333933463745414242
|
| root | ::1 |
2A36424341304439423741313533304141353235354643323436313441464437333933463745414242
|
| | localhost |


|
| | linux-rd8q |


|
+------+------------+-------------------------------------------------------------------------------------------------------------------------------------------------+
5 rows in set (0.00 sec)






-----
____________________________________________________
Dank U..
Thank You..
My Twitter Page:
http://twitter.com/OpenSimFan
My Facebook page (be my friend, please )
http://www.facebook.com/andre.verwijs
My Google+ page (follow me please )
André Verwijs - Google+ .
--
View this message in context:
http://opensuse.14.x6.nabble.com/MariaDB-10-1-25-openSUSE-package-unable-to-set-root-password-tp5093379p5093407.html
Sent from the opensuse-factory mailing list archive at Nabble.com.
--
To unsubscribe, e-mail: opensuse-factory+unsubscribe@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse-factory+owner@xxxxxxxxxxxx

< Previous Next >
This Thread
References