Could not connect: Connection using old (pre-4.1.1) authentication protocol
来源:互联网 发布:sqlserver数据库迁移 编辑:程序博客网 时间:2024/05/18 03:46
同事总结,主要是发现问题,解决问题。发现问题很重要。
Could not connect: Connection using old (pre-4.1.1) authentication protocol 报错
其实只要进数据库
set old_passwords=0;
show variables like '%password%';
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('uplooking');
这样就可以了
关键在于发现问题:php连数据库
<?php
$link = mysql_connect('localhost', 'root', 'uplooking') ;
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>
参考链接:
http://see.sl088.com/wiki/MySQL_4.1%E4%B9%8B%E5%90%8E%E7%9A%84%E5%93%88%E5%B8%8C%E5%8A%A0%E5%AF%86%E9%97%AE%E9%A2%98
0 0
- Could not connect: Connection using old (pre-4.1.1) authentication protocol
- mysql_connect(): Connection using old (pre-4.1.1) authentication protocol refused
- ERROR 2049 (HY000): Connection using old (pre-4.1.1)
- mysqlnd cannot connect to MySQL 4.1+ using old authentication
- MySQL 4.1+ using old authentication
- mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
- mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication问题解决
- mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
- php连接MySQL时产生错误:mysqlnd cannot connect to MySQL 4.1+ using old authentication
- Warning: mysql_connect(): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
- mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
- mysql_connect(): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication.
- mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication错误解决办法
- Warning: mysql_connect(): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
- php 5.3:connection failed:SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using old auth
- QWSSocket::connectToLocalFile could not connect:: Connection refused
- 在万网虚拟主机上连接数据库出错mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
- mysql connect Error,Client does not support authentication protocol requested
- warning: Missing file: XXX is missing from working copy 警告错误解决
- 我的第一篇文章
- xshell端口转发,plsql连接远程oracle
- ViewPager(2):ViewPager与Fragment一起使用
- android容联云IM初始化介绍及简单登陆修改
- Could not connect: Connection using old (pre-4.1.1) authentication protocol
- 实战录 | 基于redis的分布式HA调度器解决方案
- Auto property synthesis will not synthesize property ‘delegate’;it will be implemented by its superc
- android之Intent的七大属性
- C++第三次作业
- ccah-500 第42题 want to set and enforce a block size of 128MB for all new files written to the cluster
- C# 程序员最常犯的 10 个错误
- OPenCV floodfill 泛洪填充的使用方法
- 第三章 DispatcherServlet详解 ——跟开涛学SpringMVC