D:\mysql\bin>mysql -u root -p mysql Enter password: ******* ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)D:\mysql\bin>mysqladmin -u root -p password 111222 Enter password: ******* mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to MySQL server on 'localhost' (10061)' Check that mysqld is running on localhost and that the port is 3306. You can check this by doing 'telnet localhost 3306'这会是什么原因呢?
oracle我觉得这个大型的数据库对我来说太难了
MySQL几乎就不需要进行什么配置,
直接拷贝过来就能用了,
为了有更好的性能与运行环境,
可能是要进行一些设置的
如下:
[WinMySQLAdmin]
Server=D:/mysql/bin/mysqld-nt.exe[mysqld]
basedir=D:/MYSQL
#MySQL安装在D:\MYSQL目录下
#bind-address=192.168.0.2
#安装的机器IP为192.168.0.2
datadir=D:/MYSQL/data
#MYSQL的数据库文件放在D:\MYSQL\data
language=D:/MYSQL/share/chinese
#MYSQL系统反馈的错误信息为中文,(我自己汉化了一下 ^_^)
#port=3306
#TCP/IP的侦听端口为3306
#set-variable=key_buffer=16M
#最大索引为16M
#set-variable = max_allowed_packet = 8M
#最大允许传送的数据包为8M
#在传送图像文件时需修改此值
Enter password: *******
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)D:\mysql\bin>mysqladmin -u root -p password 111222
Enter password: *******
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'这会是什么原因呢?
建议找本mysql手册看看先
其中有些mysqld-??????.exe形式的都是服务程序,也可以运行其中的一个。
它会自动处理,
启动MySQL服务的