• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Email Me
  • GitHub
  • Instagram
  • LinkedIn
  • Twitter
  • YouTube
madbray.com

madbray.com

The WP Experiment

  • Home
  • Blog
  • Shop
  • Contact
  • About

MySQL80 Service Started and Then Stopped: FIXED

September 1, 2021 by Brad May 27 Comments

The Problem

When you start the MySQL80 service, it immediately stops and gives the following error:

The MySQL80 service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

“The MySQL80 service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.”

The solution I came across was ridiculously simple but took me a while to find, so I thought I would make another resource online to hopefully save you some time and trouble. I found a lot of sites that mentioned installing MySQL as a service using mysqld –install and then running mysqld –initialize , but I wouldn’t start there.

The Solution

Somehow the my.ini config file can get HEX characters added to the beginning of the file. At least on Windows servers, this causes the MySQL service to fail when it tries to start. The solution is to remove these HEX characters and then start the service again.

Since HEX characters aren’t visible if you’re using a regular text editor, like the built-in Notepad, you’ll have to install another program.

The solution I found was mentioned at https://docs.rackspace.com/support/how-to/how-to-resolve-mysql-service-starting-and-stopping-unexpectedly/

Steps to Fix MySQL80 Service

When you open your my.ini config file (on Windows, found in C:\ProgramData\MySQL\MySQL Server 8.0 –> you might have a different server version number), you don’t immediately notice the HEX characters unless you view it with a HEX viewer.

Using Notepad++

One of the simplest ways to get a HEX view of your my.ini file is to use Notepad++ and run the “HEX-Editor” plugin. If you’re not already using Notepad++ for all your text editor needs…you should be. Download Notepad++ here.

Once you’re running Notepad++, you can add the HEX-Editor plugin. In Notepad++, click Plugins -> Plugins Admin… -> search for “HEX”. You’ll see “HEX-Editor” as one of the plugins you can install. Select it and click Install.

Notepad++ should close, install the plugin, then restart. Once you have it open again, open your my.ini config file in Notepad++, click Plugins -> HEX-Editor -> View in HEX.

Remove the HEX Characters

When I viewed my.ini in HEX view, I had 3 HEX characters before the initial “#” symbol that I saw when I viewed my.ini in a regular text editor like Notepad (or Notepad++ without HEX view turned on).

Select any leading HEX characters and press “Delete” on your keyboard. I don’t remember specifically, but you may also be able to right-click on your selection and click Delete. Either way, make those HEX characters disappear and then save your file. The config file should start with the “#” symbol.

Have a Party

Now that you’ve removed the HEX characters and saved your my.ini config file again, you should be able to start the MySQL80 service again. Then you should celebrate and have a cup of coffee.

Note: This may also apply to other versions of MySQL, but the one I specifically encountered this with was MySQL version 8.0.26.

Leave a Comment

I hope this helps you. I thanked God when I came across this fix! It saved me a day of reinstalling and restoring data ๐Ÿ™‚

Reach out to me directly or leave a comment below if you need any help or have any questions.

Share this:

  • Twitter
  • Facebook

Reader Interactions

Comments

  1. JR says

    October 29, 2021 at 3:18 am

    This procedure save my career. LoL
    Thanks OP.

    Reply
    • Brad May says

      October 30, 2021 at 10:36 pm

      Hey JR! I’m glad that helped you!

      Reply
  2. Jason says

    January 21, 2022 at 1:08 am

    Thank you so, so much! You literally saved many game servers tonight!

    Reply
    • Brad May says

      January 21, 2022 at 6:19 am

      Great! Glad that helped. Happy gaming!

      Reply
  3. Lucien says

    January 21, 2022 at 5:57 pm

    Thank you!

    Reply
    • Brad May says

      January 21, 2022 at 6:05 pm

      You’re welcome!

      Reply
  4. Anthony says

    January 24, 2022 at 8:49 pm

    Very helpful! Thanks!

    Reply
    • Brad May says

      January 24, 2022 at 9:40 pm

      Awesome! Glad I could help.

      Reply
  5. Veeru says

    February 1, 2022 at 6:25 am

    very helpful thanks a lot

    Reply
    • Brad May says

      February 1, 2022 at 6:41 am

      Glad this helped you!

      Reply
  6. Elkhan says

    March 24, 2022 at 2:24 am

    Yessss this is my solution thank you thank you thank yoouuuuuu

    Reply
    • Brad May says

      March 24, 2022 at 1:02 pm

      Glad it helped you too!

      Reply
  7. John says

    April 20, 2022 at 7:59 am

    This is very helpful. Thank you very much. you saved my day!!

    Reply
    • Brad May says

      April 20, 2022 at 8:03 am

      So glad this helped you! ๐Ÿ™‚

      Reply
  8. Venkat says

    April 30, 2022 at 5:44 pm

    Genius, God Bless you. You saved me.

    Reply
    • Brad May says

      May 1, 2022 at 5:31 pm

      To God be the glory Glad this helped you!

      Reply
  9. Nabil says

    June 11, 2022 at 4:43 am

    i opened the ini file but i just dont know what to delete can you please help

    Reply
    • Nabil says

      June 11, 2022 at 4:47 am

      my file looks fine (no hex before #) yet i still cant start the service, im so lonely and depressed

      Reply
      • Brad May says

        June 13, 2022 at 3:19 am

        Hi Nabil,

        I’m sorry this fix didn’t work for you. I’m not sure what the problem could be. If you’d like to message me directly, click the Contact link on this site, or feel free to leave another comment. It would be helpful to know the error message you’re receiving, too.

        Thanks,
        Brad

        Reply
  10. Gustaf says

    July 31, 2022 at 5:25 am

    Thank you very much, may god always bless you

    Reply
    • Brad May says

      July 31, 2022 at 6:42 pm

      You’re welcome! God bless you, too!

      Reply
  11. Peter says

    August 1, 2022 at 12:31 pm

    Thank You!
    I would never have found it!

    Reply
    • Brad May says

      August 1, 2022 at 8:25 am

      Yeah, such a sneaky issue ๐Ÿ™‚ I’m glad it helped you, too!

      Reply
  12. jimmy says

    October 1, 2022 at 12:13 am

    this doesnt work for me, i got the same error message. i dont have problem with this file.
    appreciate anyones help. have been trying but to no avail. my previous fix was uninstall and reinstall.

    Reply
    • Brad May says

      November 7, 2022 at 4:35 pm

      Hi Jimmy, I’d need some more information. Feel free to comment here or reach out to me directly on the Contact form on this site.

      Reply
  13. Femi says

    November 16, 2022 at 5:52 am

    I’m having problems deleting the hex characters..the main characters are moving along with the hex making it difficult for me to delete

    Reply
    • Brad May says

      November 16, 2022 at 9:48 am

      You should be able to select the leading Hex characters on the right side of the screen (under the “Dump” column), right-click, Delete.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Join the WP Experiment

Top Rated Stuff

  • madbray.com coffee mug Coffee Mug - The Official Coffee Vessel $15.80
  • hand me a burrito t-shirt "hand me a burrito" t-shirt $27.40
  • Another Official Coffee Vessel $18.10

Connect With Me

  • Email
  • GitHub
  • Instagram
  • LinkedIn
  • Twitter
  • YouTube

Recent Posts

  • How to Turn Off AT&T DNS Error Assist
  • Android 12 Update: How to Choose Browser to Open Links
  • Easy Fix: Act! “Access to the path is denied”
  • How to Fix: Veeam Backup & Replication Agent Install Failed
  • ClickBank Account Disabled After Completing Profile: How to Fix

Footer

Popular Posts

  • How to Turn Off AT&T DNS Error Assist
  • Android 12 Update: How to Choose Browser to Open Links
  • Easy Fix: Act! “Access to the path is denied”
  • How to Fix: Veeam Backup & Replication Agent Install Failed
  • ClickBank Account Disabled After Completing Profile: How to Fix

Tags

access denied Android asterisk at&t backup beach branch change chan_sip cisco 7960 clickbank cmd command prompt database electric guitar encryption Essentialism firefox freepbx genesis google docs Greg McKeown growth internet mailchimp mysql online business passwords pjsip plugins remote desktop res_pjsip security sip siteground sunrise survey monkey veeam web hosting Windows WordPress WordPress development worship practice

Topics

  • Faith (7)
    • Bible Verses (1)
  • Musings (8)
  • Online Business (7)
  • Projects (4)
  • Technology (19)
  • Uncategorized (1)
  • WordPress (6)
    • Development (1)

Copyright © 2023 ยท Kreativ Pro On Genesis Framework ยท Proudly running on WordPress

Here from Fortnite? ~~~~~ Dismiss