brew在mac os上安装mysql(brew install mysql on macOS)

 我试图在mac os 10.6上使用Homebrew brew install mysql 5.1.52通过brew install mysql 5.1.52 。 
 
 一切顺利，我也成功与mysql_install_db 。 
 但是当我尝试使用以下方式连接到服务器时： 
 
/usr/local/Cellar/mysql/5.1.52/bin/mysqladmin -u root password 'mypass'
 
 我得到： 
 
/usr/local/Cellar/mysql/5.1.52/bin/mysqladmin: connect to server at 'localhost' 
failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'
 
 我也尝试mysqladmin or mysql using -u root -proot访问mysqladmin or mysql using -u root -proot ， 
 但是它没有使用或不使用密码。 
 
 这是一个全新的安装在一个全新的机器，据我所知，新的安装必须可访问没有root密码。 我也试过： 
 
/usr/local/Cellar/mysql/5.1.52/bin/mysql_secure_installation
 
 但我也得到了 
 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I'm trying to setup up MySQL on mac os 10.6 using Homebrew by brew install mysql 5.1.52.
 
Everything goes well and I am also successful with the mysql_install_db.
 However when I try to connect to the server using:
 
/usr/local/Cellar/mysql/5.1.52/bin/mysqladmin -u root password 'mypass'
 
I get: 
 
/usr/local/Cellar/mysql/5.1.52/bin/mysqladmin: connect to server at 'localhost' 
failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'
 
I've tried to access mysqladmin or mysql using -u root -proot as well,
 but it doesn't work with or without password. 
 
This is a brand new installation on a brand new machine and as far as I know the new installation must be accessible without a root password. I also tried:
 
/usr/local/Cellar/mysql/5.1.52/bin/mysql_secure_installation
 
but I also get 
 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

原文：https://stackoverflow.com/questions/4359131