The Ultimate Guide to High Availability with MariaDB

odd message in my /var/log/message file

hello -

i finally figured out to do:

grep  mysqld   /var/log/messages ;

and i see LOTS of the following mesage:

Jun 13 12:10:02 MYNAME mysqld: 2019-06-13 12:10:02 140023410034432 [Warning] Access denied for user 'root'@'localhost' (using password: YES)

i am surprised that the root user is getting so many warning messages. i do see SOME messages other than warnings:

Jun 13 12:06:22 myname mysqld: 2019-06-13 12:06:22 140023945005248 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Jun 13 12:06:22 myname mysqld: 2019-06-13 12:06:22 140023945005248 [Note] InnoDB: Waiting for purge to start
Jun 13 12:06:22 myname mysqld: 2019-06-13 12:06:22 140023945005248 [Note] InnoDB: 5.7.26 started; log sequence number 35414426330
Jun 13 12:06:22 myname mysqld: 2019-06-13 12:06:22 140023069234944 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Jun 13 12:06:22 myname mysqld: 2019-06-13 12:06:22 140023945005248 [Note] Plugin 'FEEDBACK' is disabled.
Jun 13 12:06:22 myname mysqld: 190613 12:06:22 server_audit: MariaDB Audit Plugin version 1.4.5 STARTED.
Jun 13 12:06:23 myname mysqld: 190613 12:06:22 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-06-13 12:06:23 140023945005248 [Note] Reading of all Master_info entries succeded
Jun 13 12:06:23 myname mysqld: 2019-06-13 12:06:23 140023945005248 [Note] Added new Master_info '' to hash table
Jun 13 12:06:23 myname mysqld: 2019-06-13 12:06:23 140023945005248 [Note] /usr/sbin/mysqld: ready for connections.
Jun 13 12:06:23 myname mysqld: Version: '10.2.24-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 0  MariaDB Server

yet when i look in my /.my.cnf file i see the following:

[client]
user=root
pass=SUPERSECRETPASSWOrD

Server version: 10.2.24-MariaDB MariaDB Server Linux edwardsmark.info 3.10.0-957.12.2.el7.x86_64 #1 SMP Tue May 14 21:24:32 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux

apologies for all these frantic questions - i am ON VACATION and trying to switch hotel rooms. horrible timing.

Answer Answered by Mark Edwards in this comment.

this worked: (finally)

set  global  server_audit_events          = 'CONNECT,QUERY,TABLE'  ;
set  global  server_audit_logging          = 'ON'  ;
set global server_audit_file_rotate_size  =  100000000 ;
SHOW GLOBAL VARIABLES LIKE 'server_audit%';


 grep  DROP    /var/lib/mysql/server_audit.log ;
 tail -f    /var/lib/mysql/server_audit.log ;

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.