dongsan6889 2017-05-17 18:33
浏览 37
已采纳

我正在尝试访问Phpmyadmin并查看和创建数据库,但我无法登录[重复]

This question already has an answer here:

I am working to get access to phpmyadmin by using Xampp on my windows 10. I am unable to login. I have tried many things which includes:

1) delete "ib_logfile0" and ib_logfile1 2) Restarting machine 3) Changing username and password and trying that in the below code 4) making 'AllowNoPassword' true and false both in below code. 5) checking skype and all ports

I am confused now what can I do. I am new to php and mysql and don't know much of codes. I am attaching my Xampp interface also below: enter image description here

Code in my config.inc.php

    /* Authentication type and info */
    $cfg['Servers'][$i]['auth_type']    = 'cookie';
    $cfg['Servers'][$i]['user']         = 'root';
    $cfg['Servers'][$i]['password']     = '';
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    $cfg['Servers'][$i]['AllowNoPassword'] = true;
    $cfg['Lang'] = '';

    /* Bind to the localhost ipv4 address and tcp */
    $cfg['Servers'][$i]['host'] = '127.0.0.1';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';

    /* User for advanced features */
    $cfg['Servers'][$i]['controluser']  = 'root';   
    $cfg['Servers'][$i]['controlpass']  = '';

enter image description here

</div>
  • 写回答

1条回答 默认 最新

  • donglefu6195 2017-05-17 18:52
    关注

    Please define the new port number in mysql configuration when you change from default port no 3306. From the xampp panel I could see that the port of mysql is 3307. Or in phpmyadmin: In configuration change host as '127.0.0.1:3307'

    If default port is not changed in configuration of my.ini(mysql configuration file), you have to mention the port no. in every mysql connection request.

    Hope it helps.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥16 Qphython 用xlrd读取excel报错
  • ¥15 单片机学习顺序问题!!
  • ¥15 ikuai客户端多拨vpn,重启总是有个别重拨不上
  • ¥20 关于#anlogic#sdram#的问题,如何解决?(关键词-performance)
  • ¥15 相敏解调 matlab
  • ¥15 求lingo代码和思路
  • ¥15 公交车和无人机协同运输
  • ¥15 stm32代码移植没反应
  • ¥15 matlab基于pde算法图像修复,为什么只能对示例图像有效
  • ¥100 连续两帧图像高速减法