[opensuse-factory] MariaDB 10.1.25 openSUSE package - unable to set root password ..
MariaDB 10.1.25 openSUSE package - unable to set root password even with "skip-grant-tables" and "FLUSH PRIVILEGES;" --- 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)]> use mysql; Database changed MariaDB [mysql]> update user set password=PASSWORD("Andre@Verwijs1969") where User='root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 3 Changed: 0 Warnings: 0 MariaDB [mysql]> SELECT User, Host, HEX(authentication_string) FROM mysql.user; +------+------------+-------------------------------------------+ | User | Host | HEX(authentication_string) | +------+------------+-------------------------------------------+ | root | localhost | | | root | 127.0.0.1 | | | root | ::1 | | | | localhost | | | | linux-rd8q | | +------+------------+-------------------------------------------+ 5 rows in set (0.00 sec) root password authentication_string doesn't get updated within mysql database.... tips are welcome... ----- ____________________________________________________ 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-... Sent from the opensuse-factory mailing list archive at Nabble.com. -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
Verwijs wrote:
MariaDB 10.1.25 openSUSE package - unable to set root password even with "skip-grant-tables" and "FLUSH PRIVILEGES;"
--- 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)]> use mysql; Database changed
MariaDB [mysql]> update user set password=PASSWORD("Andre@Verwijs1969") where User='root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 3 Changed: 0 Warnings: 0
So, your update didn't update anything.
MariaDB [mysql]> SELECT User, Host, HEX(authentication_string) FROM mysql.user; +------+------------+-------------------------------------------+ | User | Host | HEX(authentication_string) | +------+------------+-------------------------------------------+ | root | localhost |
FYI, my mariadb instances all have empty "authentication_string", for all users. -- Per Jessen, Zürich (13.1°C) http://www.dns24.ch/ - free dynamic DNS, made in Switzerland. -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
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-... Sent from the opensuse-factory mailing list archive at Nabble.com. -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
participants (2)
-
Per Jessen
-
Verwijs