php - SQLSTATE [HY000] [1698]

Question

我怎样才能克服这个错误？

Error: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select count(*) as aggregate from users where email = email@gmail.com

我正在使用 Ubuntu

请帮忙

Answer 1

首先以root身份登录:

$ sudo mysql -u root

然后创建或更改非根用户(如果需要，使用“127.0.0.1”而不是“localhost”):

CREATE USER 'admin'@'localhost' IDENTIFIED BY 'adminspassword';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost';
FLUSH PRIVILEGES;

退出并重启:

exit
$sudo service mysql restart
$sudo service apache2 restart

并编辑 .env 文件:

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3630
DB_DATABASE=yourdbname
DB_USERNAME=admin
DB_PASSWORD=adminspassword