问题
Login without a password is forbidden by configuration (see AllowNoPassword)
我尝试更改以下行
$cfg['Servers'][$i]['AllowNoPassword'] = false;
到
$cfg['Servers'][$i]['AllowNoPassword'] = true;
但是,仍然没有成功。我想知道如何更改root密码,以便我能够访问phpmyadmin,并创建数据库。
答案1
通过直接登录到数据库来更改mysql root密码( mysql -h your_host -u root
然后运行)
SET PASSWORD FOR root@localhost = PASSWORD('yourpassword');
确保将新密码设置为phpmyadmin的config.inc.php
,
$cfg['Servers'][$i]['password'] = 'yourpassword';否则,phpmyadmin可能无法工作,
Access denied for user 'user'@'localhost' (using password: YES)