Advertisement
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,998 ✭✭✭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