MySQL 5.6 not writing any logs

  • We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We have enabled the error, general & slow logging in the config file, but the logs are not being written even in case of errors. The below is a snippet from the ‘my.ini’ file:

     

     
    # Commented lines aren’t included
    [mysqld]
    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    log_error = "C:\Program Files\MySQL\MySQL Server 5.6\Log\error.log"
    slow_query_log = 1
    slow_query_log_file = "C:\mysql_logs\mysql_slow.log"
    long_query_time = 2

    The MySQL is not directly managed, rather it is managed by Plesk Obsidian version 18.0.56 Update #4 ( Web Abmin Edition), as it was installed as a component of Plesk. As a result, we are unable to change any permissions to folder, such as providing ‘Full’ permission for the MySQL account through the mysql command line. We have given Full permissions through the Windows NTFS folder permission but still not working.

    mysql2

     

    The troubleshooting steps tried by us are :

    1. Checked whether the intended log file is present in the path before mentioning it in the my.ini file.

    2. Restarted the mysql services after modifying the config fil.e

    3. Checked the permissions to the folder in which the intended log file path resides, after coming across this link. The logs are not writing even after giving full permission as mentioned above.

    4. Replaced the entry for the file path by removing the double quotes , replacing with single quotes, checking for any inadvertent spaces.

    5. We have also added SET global general_log = 1; but logs are still not being written.

    6. After every changes to the ‘my.ini’ we have restarted the MySQL service and checked.

    Please assist us in resolving the issue. If any further information required then do let me know.

    Thank you.

     

     

Viewing post 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply