The Ultimate Guide to High Availability with MariaDB

Comments - MariaDB Galera Cluster - Known Limitations

4 years, 3 months ago Testing User A Test
Re: MariaDB root password cannot be synced between cluster nodes

Your statement, ' Your initial `mysql -u root -p` before you restarted was executed as a non-root user', seems not true. I login the system as 'root' OS user. Then I issued the command, 'mysql -u root -p'.

  1. mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 15 Server version: 10.4.12-MariaDB MariaDB Server

Copyright © 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

No password required!. The process was owned by 'root'.

  1. ps -ef|grep mysql mysql 4404 1 7 16:27 ? 00:00:41 /usr/sbin/mysqld --wsrep_start_position=5772dcbb-98b8-11ea-94f8-037e8c2f9cc3:95 root 4719 4568 0 16:35 pts/1 00:00:00 mysql -u root -p root 4741 4182 0 16:35 pts/0 00:00:00 grep --color=auto mysql
 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.