2018-12-02, 11:37
When you first install MySQL, it asks you to set up a password for the root user as part of the initial configuration. That user/password combo is what you need to use to log into the MySQL command line. Note that the MySQL 'root' user is nothing to do with any *nix 'root' user.
To login to the command line you should use
If you can't remember the password you will have to reconfigure the MySQL package. I don't know how to do this on a Mac, but on a Debian based Linux system I would do it with
To login to the command line you should use
mysql -u root -p where root is the root user for mysql (as set up when you first installed it). Type in the password when prompted and you should be good to go.If you can't remember the password you will have to reconfigure the MySQL package. I don't know how to do this on a Mac, but on a Debian based Linux system I would do it with
sudo dpkg-reconfigure mysql-server-5.6.35 . It should then ask for a new password.
