Error-Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead

By
Hi Guys,

Error Description :

Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.

  1. shutdown unexpectedly
  2. This may be due to a blocked port, missing dependencies
  3. improper privileges, a crash, or a shutdown by another method

Solution: Do not afraid, it's a pretty simple solution.


  1. Go to mysql/data/ or (xampp\mysql\data\) 
  2. Delete all random files (except the actual database folders) ( in xampp/mysq/bin/ib_logfile1,ib_logfile0,ibdata1,aria_log_control,mysql.pid)
  3. Restart Apache and MySQL.
      hope you will get better solution.

Cheers!






Comments

  1. Adnan Zaheer6 July 2020 at 09:03

    thank for saving my time
    excellent

    ReplyDelete
  2. Paulo17 September 2020 at 20:51

    Thank You!!!! The unique solution in internet that works!

    ReplyDelete
  3. WiseChoice Real Properties25 February 2021 at 13:05

    I experienced similar situation when running xampp
    Try this: Shut down xampp (apache etc), then edit \xampp\mysql\bin\my.ini and replace key_buffer to key_buffer_size
    Hope it helps.

    - Its worth trying !

    ReplyDelete
  4. Tijana Vujanac10 December 2021 at 05:15

    Thanks! It worked for me!

    ReplyDelete
  5. Flaming Computers14 January 2022 at 20:06

    Thanks, it worked here

    ReplyDelete
  6. Rashmi Sharma15 April 2024 at 02:29

    Thanks it is working fine for me

    ReplyDelete

Post a Comment