mysql绿色版安装问题解决(ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061))
来源:互联网 发布:云计算教程 百度网盘 编辑:程序博客网 时间:2024/05/22 12:48
原来一直是使用MySQL安装版没有出现过问题,今天在安装绿色版MySQL时出现了点问题
在安装成windows服务成功后,用net start mysql 启动时提示启动成功,但当我连接mysql就报以下错误:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
my.ini文件内容:
[mysqld]
basedir=E://databases//mysql
datadir=F://databases//mysql//data
操作如图所示:
然后,又后remove掉服务,这样重复了很多次还是一样的错误,真想晕!
之后,在mysql安装目录下的data目录中发现有几个系统目录,于是把my.ini文件中的datadir值设为此目录.
更改后的主要配置为:
[mysqld]
basedir=E://databases//mysql
datadir=E://databases//mysql//data
basedir: 为你数据库程序放置目录
datadir :为你数据库数据目录
重新安装服务,启动服务之后,登录成功.
注:如果想把datadir指定到其他目录,则需要把安装目录下的data目录下的文件与目录拷贝到你所指定的目录下.
如图所示:
总结:
导制此问题的主要原因就是自已指定的数据库数据目录没有包含系统的数据库文件.
如果把数据库目录设到其他目录(不是安装目录下的data目录),则需要把此目录下的文件和目录拷到你指完的目录下即可.
- mysql绿色版安装问题解决(ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061))
- mysql绿色版安装问题解决(ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061))
- Mysql启动报错:ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061)
- mysql长时间不用出现ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- mysql 解决 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- mysql 常见问题:ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061)
- MySQL 服务无法启动 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- MySQL错误ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)的解决
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061 "Unknown error")
- windows安装mysql的坑:ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)
- ERROR 2003 (HY000):CAN’T CONNECT TO MYSQL SERVER ON ‘LOCALHOST’ (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) 解决办法
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on localhost (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- lucene日期索引与搜索
- 使用Python调用工作目录下所有快捷方式
- 一种朋友
- struct2.0(一)
- Java Annotation基本介绍
- mysql绿色版安装问题解决(ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061))
- struct2.0(二)
- 了解 ibatis
- cctype字符函数
- java 二叉树算法(一)
- menu
- 111
- java 二叉树算法(二)
- photoshop 基本工具(1)