wampserver和mysql administrator共同使用
来源:互联网 发布:c语言32个关键词 编辑:程序博客网 时间:2024/06/01 09:58
英文原文:
For those readers who do not develop PHP on Windows platform WampServer is probably the most popular Apache + MySQL + PHP package for Windows. MySQL Administrator on the other hand, is a part of MySQL GUI Tools package.
The problem with this pair, is that they don't want to work together. At least not right out of box. MySQL Administrator fails to find mysql service process as installed by WampServer. This leads to infamous 'Could not find settings' error message.You still will be able to use MySQL Administrator, but some of its features will be unavailable - among them quite important 'Startup variables' that lets you configure your server.
The reason is simple. WampServer keeps MySQL's config file in a directory, that is not checked by MySQL Administrator's searching algorithm.
Luckily, the solution is also simple.
Open registry editor
Windows XP: Go to Start > Run... type in regedit and press Enter
Vista: Go to Start, type regedit into search box and press Enter
A word of warning: be careful when using registry editor, as you might break your system if you change wrong variables.
Using tree on the left go to:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\wampmysqld
In the window on the right find ImagePath variable, double click it's name.
In the dialog that opens you should see something like this:
c:\wamp\bin\mysql\mysql5.1.33\bin\mysqld.exe wampmysqld
(MySQL's version may vary)
Change it like this:
"c:\wamp\bin\mysql\mysql5.1.33\bin\mysqld.exe" --defaults-file="c:\wamp\bin\mysql\mysql5.1.33\my.ini" wampmysqld
(be careful not to miss any double quotes!
Close registry editor, then restart you MySQL server from WampServer's tray menu.
MySQL Administrator should work fine now.
翻译:
为了解决wampserver和mysql administrator无法共同使用的问题(mysql administrator会提示无法找到服务器),需要在注册列表中将“HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\wampmysqld”这一项的“ ImagePath”元素的值从
c:\wamp\bin\mysql\mysql5.1.33\bin\mysqld.exe wampmysqld
改为
"c:\wamp\bin\mysql\mysql5.1.33\bin\mysqld.exe" --defaults-file="c:\wamp\bin\mysql\mysql5.1.33\my.ini" wampmysqld
注意保留双引号。
修改后重启mysql server就可以了。
0 0
- wampserver和mysql administrator共同使用
- MYSQL administrator 使用
- MySQL Administrator使用细节总结
- Ubuntu 安装 mysql 和 MySQL Administrator 图形界面
- wampserver 的安装和使用
- mysql-administrator的安装与使用
- MySQL Administrator
- 使用wampserver搭建Apache+PHP+MySQL
- WampServer下修改和重置MySQL密码
- 如何解决mysql和wampserver冲突
- WampServer下修改和重置MySQL密码
- WampServer下修改和重置MySQL密码
- WampServer下修改和重置MySQL密码
- WampServer下修改和重置MySQL密码
- WampServer MySQL修改密码和默认编码
- mysql 游标与事务共同使用
- mysql 游标与事务共同使用
- wampserver和eclipsePhp一起使用开发php
- java中applet小程序的数字签名
- POJ 2777 Count Color
- Android animator
- 整合网上资源 整理的 Alfred 2 的配置教程
- myeclipse6.0安装maven插件
- wampserver和mysql administrator共同使用
- easyUI 增删查改1
- HTML5特效源码网站
- 数据结构(15)--哈夫曼树以及哈夫曼编码的实现
- APP启动页的正确配置方式
- You can't specify target table X for update in FROM clause
- java 模式分类
- SVM训练及预测过程
- oracle数据库中数据库名、实例名、数据库域名、全局数据库名、数据库服务名,ORACLE_SID