Initializing database


PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:

'/usr/bin/mysqladmin' -u root password 'new-password'
'/usr/bin/mysqladmin' -u root -h  password 'new-password'

Alternatively you can run:
'/usr/bin/mysql_secure_installation'

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.

Please report any problems at http://mariadb.org/jira

The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

Database initialized
MySQL init process in progress...
2018-10-10 18:16:32 0 [Note] mysqld (mysqld 10.3.10-MariaDB-1:10.3.10+maria~bionic) starting as process 101 ...
2018-10-10 18:16:32 0 [Note] WSREP: Read nil XID from storage engines, skipping position init
2018-10-10 18:16:32 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
2018-10-10 18:16:32 0 [Note] WSREP: wsrep_load(): Galera 25.3.24(r3825) by Codership Oy <info@codership.com> loaded successfully.
2018-10-10 18:16:32 0 [Note] WSREP: CRC-32C: using hardware acceleration.
2018-10-10 18:16:32 0 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat'
2018-10-10 18:16:32 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1
2018-10-10 18:16:32 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 192.168.192.3; base_port = 4567; cert.log_conflicts = no; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.
2018-10-10 18:16:32 0 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 00000000-0000-0000-0000-000000000000:-1
2018-10-10 18:16:32 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
2018-10-10 18:16:32 0 [Note] WSREP: wsrep_sst_grab()
2018-10-10 18:16:32 0 [Note] WSREP: Start replication
2018-10-10 18:16:32 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
2018-10-10 18:16:32 0 [Note] WSREP: protonet asio version 0
2018-10-10 18:16:32 0 [Note] WSREP: Using CRC-32C for message checksums.
2018-10-10 18:16:32 0 [Note] WSREP: backend: asio
2018-10-10 18:16:32 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2018-10-10 18:16:32 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2018-10-10 18:16:32 0 [Note] WSREP: restore pc from disk failed
2018-10-10 18:16:32 0 [Note] WSREP: GMCast version 0
2018-10-10 18:16:32 0 [Note] WSREP: (9d923d46, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2018-10-10 18:16:32 0 [Note] WSREP: (9d923d46, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2018-10-10 18:16:32 0 [Note] WSREP: EVS version 0
2018-10-10 18:16:32 0 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer 'maria-0:,maria-1:'
2018-10-10 18:16:32 0 [Note] WSREP: (9d923d46, 'tcp://0.0.0.0:4567') connection established to 9d923d46 tcp://192.168.192.3:4567
2018-10-10 18:16:32 0 [Warning] WSREP: (9d923d46, 'tcp://0.0.0.0:4567') address 'tcp://192.168.192.3:4567' points to own listening address, blacklisting
2018-10-10 18:16:32 0 [Note] WSREP: (9d923d46, 'tcp://0.0.0.0:4567') connection established to 7e4bd57b tcp://192.168.192.2:4567
2018-10-10 18:16:32 0 [Note] WSREP: (9d923d46, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
2018-10-10 18:16:32 0 [Note] WSREP: declaring 7e4bd57b at tcp://192.168.192.2:4567 stable
2018-10-10 18:16:32 0 [Note] WSREP: Node 7e4bd57b state prim
2018-10-10 18:16:32 0 [Note] WSREP: view(view_id(PRIM,7e4bd57b,2) memb {
        7e4bd57b,0
        9d923d46,0
} joined {
} left {
} partitioned {
})
2018-10-10 18:16:32 0 [Note] WSREP: save pc into disk
MySQL init process in progress...
2018-10-10 18:16:33 0 [Note] WSREP: gcomm: connected
2018-10-10 18:16:33 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2018-10-10 18:16:33 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2018-10-10 18:16:33 0 [Note] WSREP: Opened channel 'my_wsrep_cluster'
2018-10-10 18:16:33 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2
2018-10-10 18:16:33 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2018-10-10 18:16:33 0 [Note] WSREP: Waiting for SST to complete.
2018-10-10 18:16:33 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 9de40a1c-ccb8-11e8-b4b2-67e86775fd47
2018-10-10 18:16:33 0 [Note] WSREP: STATE EXCHANGE: got state msg: 9de40a1c-ccb8-11e8-b4b2-67e86775fd47 from 0 (4d68cc172901)
2018-10-10 18:16:33 0 [Note] WSREP: STATE EXCHANGE: got state msg: 9de40a1c-ccb8-11e8-b4b2-67e86775fd47 from 1 (eee67952e2ab)
2018-10-10 18:16:33 0 [Note] WSREP: Quorum results:
        version    = 4,
        component  = PRIMARY,
        conf_id    = 1,
        members    = 1/2 (joined/total),
        act_id     = 6,
        last_appl. = -1,
        protocols  = 0/9/3 (gcs/repl/appl),
        group UUID = 7bb894eb-ccb8-11e8-a775-ff8d1a593fee
2018-10-10 18:16:33 0 [Note] WSREP: Flow-control interval: [23, 23]
2018-10-10 18:16:33 0 [Note] WSREP: Trying to continue unpaused monitor
2018-10-10 18:16:33 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 6)
2018-10-10 18:16:33 2 [Note] WSREP: State transfer required:
        Group state: 7bb894eb-ccb8-11e8-a775-ff8d1a593fee:6
        Local state: 00000000-0000-0000-0000-000000000000:-1
2018-10-10 18:16:33 2 [Note] WSREP: New cluster view: global state: 7bb894eb-ccb8-11e8-a775-ff8d1a593fee:6, view# 2: Primary, number of nodes: 2, my index: 1, protocol version 3
2018-10-10 18:16:33 2 [Warning] WSREP: Gap in state sequence. Need state transfer.
2018-10-10 18:16:33 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '192.168.192.3' --datadir '/var/lib/mysql/'   --parent '101'  ''  '''
2018-10-10 18:16:34 2 [Note] WSREP: Prepared SST request: rsync|192.168.192.3:4444/rsync_sst
2018-10-10 18:16:34 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2018-10-10 18:16:34 2 [Note] WSREP: REPL Protocols: 9 (4, 2)
2018-10-10 18:16:34 2 [Note] WSREP: Assign initial position for certification: 6, protocol version: 4
2018-10-10 18:16:34 0 [Note] WSREP: Service thread queue flushed.
2018-10-10 18:16:34 2 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (7bb894eb-ccb8-11e8-a775-ff8d1a593fee): 1 (Operation not permitted)
         at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will be unavailable.
2018-10-10 18:16:34 0 [Note] WSREP: Member 1.0 (eee67952e2ab) requested state transfer from '*any*'. Selected 0.0 (4d68cc172901)(SYNCED) as donor.
2018-10-10 18:16:34 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 6)
2018-10-10 18:16:34 2 [Note] WSREP: Requesting state transfer: success, donor: 0
2018-10-10 18:16:34 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 7bb894eb-ccb8-11e8-a775-ff8d1a593fee:6
MySQL init process in progress...
MySQL init process in progress...
2018-10-10 18:16:35 0 [Note] WSREP: (9d923d46, 'tcp://0.0.0.0:4567') connection to peer 9d923d46 with addr tcp://192.168.192.3:4567 timed out, no messages seen in PT3S
2018-10-10 18:16:35 0 [Note] WSREP: (9d923d46, 'tcp://0.0.0.0:4567') turning message relay requesting off
2018-10-10 18:16:35 0 [Note] WSREP: 0.0 (4d68cc172901): State transfer to 1.0 (eee67952e2ab) complete.
2018-10-10 18:16:35 0 [Note] WSREP: Member 0.0 (4d68cc172901) synced with group.
WSREP_SST: [INFO] Joiner cleanup. rsync PID: 163 (20181010 18:16:36.177)
MySQL init process in progress...
WSREP_SST: [INFO] Joiner cleanup done. (20181010 18:16:36.702)
2018-10-10 18:16:36 0 [Note] WSREP: SST complete, seqno: 6
2018-10-10 18:16:36 0 [Note] InnoDB: Using Linux native AIO
2018-10-10 18:16:36 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-10-10 18:16:36 0 [Note] InnoDB: Uses event mutexes
2018-10-10 18:16:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-10-10 18:16:36 0 [Note] InnoDB: Number of pools: 1
2018-10-10 18:16:36 0 [Note] InnoDB: Using SSE2 crc32 instructions
2018-10-10 18:16:36 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2018-10-10 18:16:36 0 [Note] InnoDB: Completed initialization of buffer pool
2018-10-10 18:16:36 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-10-10 18:16:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1673121
MySQL init process in progress...
2018-10-10 18:16:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2018-10-10 18:16:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-10-10 18:16:37 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-10-10 18:16:37 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-10-10 18:16:37 0 [Note] InnoDB: Waiting for purge to start
2018-10-10 18:16:37 0 [Note] InnoDB: 10.3.10 started; log sequence number 1673130; transaction id 21
2018-10-10 18:16:37 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-10-10 18:16:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-10 18:16:37 0 [Warning] 'proxies_priv' entry '@% root@4d68cc172901' ignored in --skip-name-resolve mode.
2018-10-10 18:16:37 0 [Note] WSREP: Signalling provider to continue.
2018-10-10 18:16:37 0 [Note] WSREP: SST received: 7bb894eb-ccb8-11e8-a775-ff8d1a593fee:6
2018-10-10 18:16:37 0 [Note] InnoDB: Buffer pool(s) load completed at 181010 18:16:37
2018-10-10 18:16:37 0 [Note] WSREP: 1.0 (eee67952e2ab): State transfer from 0.0 (4d68cc172901) complete.
2018-10-10 18:16:37 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 6)
2018-10-10 18:16:37 0 [Note] WSREP: Member 1.0 (eee67952e2ab) synced with group.
2018-10-10 18:16:37 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 6)
2018-10-10 18:16:37 2 [Note] WSREP: Synchronized with group, ready for connections
2018-10-10 18:16:37 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2018-10-10 18:16:37 0 [Note] Reading of all Master_info entries succeded
2018-10-10 18:16:37 0 [Note] Added new Master_info '' to hash table
2018-10-10 18:16:37 0 [Note] mysqld: ready for connections.
Version: '10.3.10-MariaDB-1:10.3.10+maria~bionic'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  mariadb.org binary distribution
ERROR 1396 (HY000) at line 8: Operation CREATE USER failed for 'root'@'%'