ERROR 1396 failed to add cmon user

Follow

Nick Loudaros

• November 05, 2018 09:49

Trying to install CC (several times), i get the following error.
=> Enter the CMON user password again: => Creating the MySQL cmon user ...
ERROR 1396 (HY000) at line 7: Operation CREATE USER failed for 'cmon'@'127.0.0.1'
Failed to add cmon user! ...

Any ideas?

0

• Official comment

  

  Johan

  • November 05, 2018 10:07

  Hi,
  
  ERROR 1396  indicates the 'cmon' user exists already on 127.0.0.1 (obviously the install script fails to detect this).
  
  Can you try and do:
  
  mysql -uroot -p
  
  # at the mysql> prompt execute:
  DROP USER 'cmon'@'127.0.0.1';
  DROP USER 'cmon'@'localhost';

  # or:
  DELETE FROM mysql.user WHERE user='cmon';
  FLUSH PRIVILEGES;
  
  and try the installation script again?
  
  BR

  johan

  Comment actions Permalink

Please sign in to leave a comment.