• 

  Chris Young

  • December 12, 2012 20:30

  This may seem trivial, I am still becoming more acquainted with Galera and MySQL - but could you also do the following command to change passwords for root and cmon respectively?

   

  mysqladmin –u root –p’password’ password NEWPASSWORD

  mysqladmin –u cmon –p’password’ password NEWPASSWORD

  I'm just trying to think of ways to be able to do this with less keystrokes and want to make sure that these two operations (The ones you listed) and the ones I just listed, do the same thing.

  Thank you,

  Chris

  0

  Comment actions Permalink
• 

  tom

  • July 18, 2013 11:08

  Hello,

  ~/s9s-admin/ccadmin# ./s9s_change_passwd --cmon -i1 -ncmon2
  
  load opts 1
  
  ERROR 1045 (28000): Access denied for user 'cmon'@'localhost' (using password: YES)
  
  ERROR 1045 (28000): Access denied for user 'cmon'@'localhost' (using password: YES)
  
  ERROR 1045 (28000): Access denied for user 'cmon'@'localhost' (using password: YES)
  
  ERROR 1045 (28000): Access denied for user 'cmon'@'localhost' (using password: YES)
  
  ERROR 1045 (28000): Access denied for user 'cmon'@'localhost' (using password: YES)
  
  ERROR 1045 (28000): Access denied for user 'cmon'@'localhost' (using password: YES)
  
  ERROR 1045 (28000): Access denied for user 'cmon'@'localhost' (using password: YES)

  Failed: load opts failed

  0

  Comment actions Permalink
• 

  Johan

  • July 18, 2013 15:09

  Hi,

  have you pulled the latest?

  It is connecting to:

  CMON_DB_HOST=127.0.0.1

  and that is granted by default if you have used the deployment package.

  Best regards

  Johan

  0

  Comment actions Permalink
• 

  Viktor B.

  • May 21, 2015 13:58

  the git command is incorrect. You are missing a "clone" command

  git clone git://github.com/severalnines/s9s-admin.git

  cd s9s-admin/ccadmin/

  you should change the default password to new secure passwords, default cmon password is 'cmon' no quotes

  ./s9s_change_passwd --cmon -i1 -p <current cmon password> -n <new cmon password>

  Also, change database roots password. Dont get it confused with the system's root, but just as important.  the default password for dbs root is 'password' yep... no joke, no quotes 

  ./s9s_change_passwd --root -i1 -p <cmon password> -o <old root password> -n <new root password>

   

  0

  Comment actions Permalink
• 

  Steven

  • October 01, 2015 16:44

  Will changing the password for the cluster cause any interruption?

  0

  Comment actions Permalink
• 

  Johan

  • October 01, 2015 16:59

  Hi,

  No, but i recommend that you stop cmon before changing.
  
  Also, i will revise this script.

  If you can I would rather see that you do:

  UPDATE mysql.user SET password=PASSWORD('NEW_PASS') WHERE user='USER'

  FLUSH PRIVILEGES;

  ** Change user 'cmon' password 
  
  If you have change the password for USER='cmon', then change on the CONTROLLER and on the DB NODES.

  If you have many clusters in one cmon controller you must issue the UPDATE/FLUSH on all nodes.

  Update the /etc/cmon.d/cmon_X.cnf files and /etc/cmon.cnf file and change:

  mysql_password='NEWPASS'

  ** Change user 'root' password
  
  If you have change the password for USER='root', then change on the CONTROLLER and on the DB NODES.

  Update the /etc/cmon.d/cmon_X.cnf file (matching the cluster)  and /etc/cmon.cnf file and change:

  monitored_mysql_root_password='NEWPASS'

  IF you use GALERA, then you want to edit my.cnf on the DB NODEs and make sure "wsrep_sst_auth" is set correctly.

  Also do a SET GLOBAL wsrep_sst_auth=root:NEWPASS

  Finally start the cmon process again:

  service cmon start

   

   

   

   

  0

  Comment actions Permalink
• 

  Steven

  • October 01, 2015 18:53

  ok,  just one clarifcation.

  i am changing my root password and i understand that part  for ** Change user 'root' password onward

   

  but for changing root do i need to do this? or does the set global cover it?

  If you can I would rather see that you do:

  UPDATE mysql.user SET password=PASSWORD('NEW_PASS') WHERE user='USER'

  FLUSH PRIVILEGES;

  0

  Comment actions Permalink
• 

  Johan

  • October 01, 2015 19:27

  You need to do on all nodes (if you are using galera it should be enough on only one node as it will be distributed):

  UPDATE mysql.user SET password=PASSWORD('NEW_PASS') WHERE user='root'

  FLUSH PRIVILEGES;

  If you are using Galera:

   SET GLOBAL wsrep_sst_auth=root:NEWPASS

  And set in my.cnf

  wsrep_sst_auth=root:NEWPASS

  And in /etc/cmon.cnf or in /etc/cmon.d/cmon_X.cnf  (X depending on which of the cmon.cnf files that are matching your cluster), set:

  monitored_mysql_root_password='NEWPASS'

   

   

  0

  Comment actions Permalink

Please sign in to leave a comment.