Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Mysql 8.0 root password

Options
  • 06-09-2019 8:53pm
    #1
    veryangryman
    Registered Users Posts: 5,576 ✭✭✭


    Getting alot of thing after setting up mysql on windows 10. To access my Database ill need root password, but i dont know what it is.
    C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -u root -p
Enter password: ****
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

    Videos on youtube show using the my.ini file but that seems to only be from versions around the 5.6 level. Said file does not exist on 8.0

    Thoughts on a way to get this and start using it?


Comments

  • Options
    #2
    The_B_Man
    Registered Users Posts: 7,865 ✭✭✭The_B_Man


    Try without a password. Leave out the -p switch.

    If that fails, just reset the root password.
    Google how to do it but basically u restart the server in a kind of safe mode with no password and then login and set a new password.


Advertisement