doutui6241 2014-05-20 13:30
浏览 24

IIS + PHP - 无法使用旧身份验证连接到MySQL 4.1+

I'm with a big problem here. I'm integrating an interface I've done using Codeigniter with an external Mysql Database. The thing is that I'm getting "Cannot connect to MySQL 4.1+ using old authentication" error. Yes, I've looked over the internet and found steps to solve it once we have admin rights to the database. The thing is that I have a ready-only access.

Can I do something to connect to this database? Just to let you know, I'm not using a Linux Server, I'm using a Windows Server with IIS, and to be honest, I'm not very used to it.

These are the parameters I'm using to try to connect:

$db['otrs']['hostname'] = 'test.test.lan';
$db['otrs']['username'] = 'otrs';
$db['otrs']['password'] = 'otrs';
$db['otrs']['database'] = 'otrs';
$db['otrs']['dbdriver'] = 'mysql';
$db['otrs']['dbprefix'] = '';
$db['otrs']['pconnect'] = TRUE;
$db['otrs']['db_debug'] = TRUE;
$db['otrs']['cache_on'] = FALSE;
$db['otrs']['cachedir'] = '';
$db['otrs']['char_set'] = 'utf8';
$db['otrs']['dbcollat'] = 'utf8_general_ci';
$db['otrs']['swap_pre'] = '';
$db['otrs']['autoinit'] = TRUE;
$db['otrs']['stricton'] = FALSE;

If you need more info, just let me know.

Thank you very much!

  • 写回答

1条回答 默认 最新

  • dongmoxin7111 2014-05-20 14:27
    关注

    1/ - Did you check that the database accept external connexions (<> localhost) ? 2/ - Did you check that your MySQL version is compatible with CodeIgniter ?

    Pascal

    评论

报告相同问题?

悬赏问题

  • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?
  • ¥20 怎么用dlib库的算法识别小麦病虫害
  • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
  • ¥15 java写代码遇到问题,求帮助
  • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
  • ¥15 有了解d3和topogram.js库的吗?有偿请教
  • ¥100 任意维数的K均值聚类
  • ¥15 stamps做sbas-insar,时序沉降图怎么画
  • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
  • ¥15 关于#Java#的问题,如何解决?