Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)

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.

1 Like

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

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

#
# 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

1 Like

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

1 Like