I am having serious problems to get up and running with mysql OSX. I installed homebrew, php and supposedly mysql.
When I run brew services list, I see the following:
Name Status User Plist
dnsmasq started root /Library/LaunchDaemons/homebrew.mxcl.dnsmasq.plist
mysql@5.7 started sidney /Users/sidney/Library/LaunchAgents/homebrew.mxcl.mysql@5.7.plist
nginx started root /Library/LaunchDaemons/homebrew.mxcl.nginx.plist
php started root /Library/LaunchDaemons/homebrew.mxcl.php.plist
but once I try:
mysql -uroot
mysql -u root -p
They all give me the following error:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
I also tried:
mysql_secure_installation
but I see the following in process of entering the password:
Securing the MySQL server deployment.
Enter password for user root:
Error: Access denied for user 'root'@'localhost'
How can I fix mysql on my mac?