(phpmyadmin error)Login without a password is forbidden by configuration (see AllowNoPassword) in ub...

1.Go to /etc/phpmyadmin/config.inc.php and open it your favorite editor. 

2.Search for below line of code 

//$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

code lines will be looks like :-

if (!empty($dbname)) {
 //More code here
/* Uncomment the following to enable logging in to passwordless accounts, * after taking note of the associated security risks. */ // $cfg['Servers'][$i]['AllowNoPassword'] = TRUE; /* Advance to next server for rest of config */ $i++; }

And    uncomment the    //$cfg[‘Servers’][$i][‘AllowNoPassword’] = TRUE; (just remove “//” from start) to make login in phpmyadmin with password 

/* Uncomment the following to enable logging in to passwordless accounts,
 * after taking note of the associated security risks. */
 $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

Note :-If you are using older version of php then may be there is another same line of code so you need to uncomment also these lines like 

if (!empty($dbname)) {
  // other configuration options  $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;  $i++; } // another code found here $cfg['Servers'][$i]['AllowNoPassword'] = TRUE; 

3.Save your file and done try to login your phpmyadmin without password. If you still have issue try to restart your apache services by following command. For more    How to restart apache ubuntu  

sudo service apache2 restart

4.If you still facing issue you need reinstall mysql again by running following command through terminal. For more    How to install mysql?  

sudo apt-get install mysql-server mysql-common mysql-client

And run your phpmyadmin and login without password now you are done you have fixed error    Login without a password is forbidden by configuration (see AllowNoPassword) in ubuntu .

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值