MySQL 数据库连接失败 SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13)
来源:互联网 发布:斐波那契java 编辑:程序博客网 时间:2024/06/05 06:09
CentOS6.5x64 安装禅道6.2,生成配置文件,数据库连接失败
数据库连接失败 SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13)
root,密码肯定没有错(命令行可以登录),用的127.0.0.1
PHP安装正常,MySQL配置正确,PHP的PDO、MySQL扩展正确,使用
<?php$link=mysql_connect('localhost','root','password');if ($link)echo "successfu";elseecho "Faile";mysql_close();?>
php代码能够正确连接数据库,但是安装禅道过程中始终连不上MySQL数据库Can't connect to MySQL server on '127.0.0.1' (13),各种原因分析无果,最后仔细阅读my.cnf文件,发现mysqld中有配user=mysql的信息,如下:
[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid
将user=mysql该为user=root 后重启mysqld服务后安装一切正常,官方参数解释:
mysqld程序在启动后将在给定UNIX/Linux账户下执行; mysqld必须从root账户启动才能在启动后切换到另一个账户下执行; mysqld_safe脚本将默认使用–user=mysql选项来启动mysqld程序。
具体参数请参考:MySQL配置参数详解
0 0
- MySQL 数据库连接失败 SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13)
- MySQL 数据库连接失败 SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13)
- MySQL Centos7 数据库连接失败 SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13)
- SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'XXX' (13)
- SQLSTATE[HY000] [2003] Can't connect to MySQL server on '*.*.*.*' (13)
- SQLSTATE[HY000] [2003] Can\'t connect to MySQL server on \'XXX\' (13)
- SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'XXX'
- 数据库连接时 报错 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on
- Ubuntu ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
- mysql 连接失败:SQLSTATE[HY000] [2003] Can't connect to 公网服务器
- Can't connect to MySQL server on '127.0.0.1' (13)
- mysql绿色版安装问题解决(ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061))
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- Mysql启动报错:ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061)
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- MySQL远程连接ERROR 2003 (HY000):Can\'t connect to MySQL server on\'XXXXX\'的问题
- checkbox单选和全选的ajax操作办法
- 简单且线程安全的两个单例模式java程序
- Vim 语法高亮与自动缩进
- poj 1852 脑洞大开(Ants)
- 【SDOI2014】【BZOJ3534】重建
- MySQL 数据库连接失败 SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13)
- 算法总结:最短路
- 转牛逼公司小头目的炫富生活
- hdoj 2566 一个人的旅行
- iOS label 加下横线
- WIFI ioctl调用(从应用程序到内核再到WIFI网卡驱动)
- 总结&备忘:smslib&长短信
- 技术人员如何提升自己的价值
- Android常用代码之普通及系统权限静默安装APK