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
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Mysql 8.0 root password

  • 06-09-2019 08:53PM
    #1
    veryangryman
    Registered Users, Registered Users 2 Posts: 5,751 ✭✭✭


    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

  • #2
    The_B_Man
    Registered Users, Registered Users 2, Paid Member Posts: 7,994 ✭✭✭The_B_Man
    Something about sandwiches


    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