# Access denied for user 'UNKNOWN\_MYSQL\_USER'@'localhost' (using password: NO) **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [November 26, 2018, 2:18am UTC](https://forums.percona.com/t/access-denied-for-user-unknown-mysql-user-localhost-using-password-no/6703 "2018-11-26T02:18:55Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Lijo](https://avatars.discourse-cdn.com/v4/letter/l/b3f665/32.png) [@Lijo](https://forums.percona.com/u/Lijo)\ **Post date:** [November 26, 2018, 2:18am UTC](https://forums.percona.com/t/access-denied-for-user-unknown-mysql-user-localhost-using-password-no/6703/1 "2018-11-26T02:18:55Z")
we are trying to bring up the percona xtradbcluster, whil;e bootstrapping the first node by this command: /etc/init.d/mysql bootstrap-pxc we got output in terminal: \* Bootstrapping Percona XtraDB Cluster database server mysqld [OK] But in log file ( /var/log/mysqld.log) we are getting this error: Access denied for user ‘UNKNOWN\_MYSQL\_USER’@‘localhost’ (using password: NO) please find me solution. ---
**Author:** ![lookman](https://avatars.discourse-cdn.com/v4/letter/l/e99b99/32.png) [@lookman](https://forums.percona.com/u/lookman)\ **Post date:** [July 31, 2021, 2:11am UTC](https://forums.percona.com/t/access-denied-for-user-unknown-mysql-user-localhost-using-password-no/6703/2 "2021-07-31T02:11:00Z")
im facing also this issue i have 2 node , the first Bootstrapping node was succesfully running next when i tried on node 2 i got this messasge from /var/log/mysqld.log ```auto Version: '5.7.34-37-57-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Percona XtraDB Cluster (GPL), Release rel37, Revision 99b8607, WSREP version 31.51, wsrep_31.51 2021-07-31T01:53:32.034039Z 2 [Note] WSREP: Initialized wsrep sidno 2 2021-07-31T01:53:32.034100Z 2 [Note] WSREP: Auto Increment Offset/Increment re-align with cluster membership change (Offset: 1 -> 1) (Increment: 1 -> 1) 2021-07-31T01:53:32.034124Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-31T01:53:32.034173Z 2 [Note] WSREP: Assign initial position for certification: 0, protocol version: 4 2021-07-31T01:53:32.034342Z 0 [Note] WSREP: Service thread queue flushed. 2021-07-31T01:53:32.043386Z 2 [Note] WSREP: Synchronized with group, ready for connections 2021-07-31T01:53:32.043472Z 2 [Note] WSREP: Setting wsrep_ready to true 2021-07-31T01:53:32.043485Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-31T01:53:33.036955Z 11 [Note] Access denied for user **'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)** ``` my config ```auto # # The Percona XtraDB Cluster 5.7 configuration file. # # # * IMPORTANT: Additional settings that can override those from this file! # The files must end with '.cnf', otherwise they'll be ignored. # Please make any edits and changes to the appropriate sectional files # included below. # [client] port = 3306 #socket = /var/run/mysqld/mysqld.sock [mysqld] server-id = 101 #bind-address = 10.100.150.101 datadir = /var/lib/mysql socket = /var/run/mysqld/mysqld.sock log-error = /var/log/mysqld.log #pid-file = /var/run/mysqld/mysqld.pid default_storage_engine = InnoDB # BINARY LOGGING # log_bin = /var/lib/mysql/mysql-bin expire-logs-days = 3 sync-binlog = 1 slave-compressed-protocol = ON binlog_format = row relay_log_recovery = ON relay-log = /var/lib/mysql/slave-relay.log relay-log-index = /var/lib/mysql/slave-relay-log.index relay-log-info-file = /var/lib/mysql/relay-log.info log-slave-updates # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # CACHES AND LIMITS # tmp-table-size = 32M max-heap-table-size = 32M query-cache-type = 0 query-cache-size = 0 max-connections = 15000 thread-cache-size = 50 open-files-limit = 65535 table-definition-cache = 4096 table-open-cache = 4096 # INNODB # innodb-flush-method = O_DIRECT innodb-log-files-in-group = 2 innodb-log-file-size = 512M innodb-flush-log-at-trx-commit = 1 innodb-file-per-table = 1 innodb-buffer-pool-size = 28G # pmm slowquery# log_output=file #slow_query_log=ON #long_query_time=1 #slow_query_log_use_global_control=all innodb_monitor_enable=all userstat=on # Path to Galera library # Path to Galera library wsrep_provider = /usr/lib/galera3/libgalera_smm.so wsrep_cluster_address = gcomm://172.18.80.100,172.18.80.101 wsrep_slave_threads = 8 wsrep_log_conflicts innodb_autoinc_lock_mode = 2 wsrep_node_address = 172.18.80.101 wsrep_cluster_name = DR wsrep_node_name = Prod-mysql02-DR pxc_strict_mode = PERMISSIVE wsrep_sst_method = xtrabackup-v2 wsrep_sst_auth = sstuser:exeik3Maiye1Tee [mysqldump] quick quote-names max_allowed_packet = 500M !includedir /etc/mysql/conf.d/ !includedir /etc/mysql/percona-xtradb-cluster.conf.d/ ``` sync data from node 1 was stopped because those error , OS = Ubuntu 18.04.5 LTS fyi : on node 1 already has data that i got from innobackupex , the user sstuser already existing on that data really appreaciate your help , regards, lookman ---
**Author:** ![lookman](https://avatars.discourse-cdn.com/v4/letter/l/e99b99/32.png) [@lookman](https://forums.percona.com/u/lookman)\ **Post date:** [August 13, 2021, 1:12am UTC](https://forums.percona.com/t/access-denied-for-user-unknown-mysql-user-localhost-using-password-no/6703/3 "2021-08-13T01:12:53Z")
i know was the problem is , on node 2 i need to get the original file/folder mysql from the origin node that i get the backup , i just get copied all file from the original source put it on node 2 and node 3, sync data from node 1 to node 2 n node 3 are succesfully i do it this one by one after node 2 finish next sync to node 3 without failing