MySQL 8.0 Triggers Current_User not working
Since I cant get the right user inside the trigger using current_user() and user() but works fine on Stored Procedure. What I did is I create a Stored Procedure and call it inside the trigger.

Stored Procedure

CREATE DEFINER=`root`@`localhost` PROCEDURE `insert_log`()
BEGIN
    INSERT INTO audit_trail 
    values( aud_no, 
           ( SELECT user_acc_id 
             from user_accounts 
             where user_username = REPLACE( user(), '@localhost', '')), 
           ( SELECT user_fname 
             from user 
             where user_id = ( SELECT user_acc_id 
                               from user_accounts 
                               where user_username = REPLACE( user(), '@localhost', ''))), 
           current_date(), 
           current_time(), 
           "logs in and out"); 
END


Trigger

CREATE DEFINER=`root`@`localhost` TRIGGER `user_log_AFTER_INSERT` AFTER INSERT ON `user_log` FOR EACH ROW BEGIN
        CALL insert_log();
END