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.

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

报告相同问题?

悬赏问题

  • ¥15 什么设备可以研究OFDM的60GHz毫米波信道模型
  • ¥15 不知道是该怎么引用多个函数片段
  • ¥15 pip install后修改模块路径,import失败,需要在哪里修改环境变量?
  • ¥15 爬取1-112页所有帖子的标题但是12页后要登录后才能 我使用selenium模拟登录 账号密码输入后 会报错 不知道怎么弄了
  • ¥30 关于用python写支付宝扫码付异步通知收不到的问题
  • ¥50 vue组件中无法正确接收并处理axios请求
  • ¥15 隐藏系统界面pdf的打印、下载按钮
  • ¥15 基于pso参数优化的LightGBM分类模型
  • ¥15 安装Paddleocr时报错无法解决
  • ¥15 python中transformers可以正常下载,但是没有办法使用pipeline