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\
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\
(MySQL's version may vary)
Change it like this:
"c:\wamp\bin\mysql\mysql5.1.
(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.
That would be it ;)
----
MySQL Forums post, where I've found this solution|Database Software Development by Expert Developers, UK
Posts
10 comments:
i'm learn about wamp server so your blog is very helpful for me. thanx for this gr8 blog.
good blog having web information
more services from us
hi i'm developing a system which is a simple 'task monitoring system' i'm using WampServer but i tried it running it.. it is too slow in my clients... any idea to increase the speed or should i use better servers..
shalominfotech IT companyit is an it trainig company now we offerd special training courses...
Hello,
dedicated server, you can avoid most of the disadvantages of shared hosting, such as viruses, spam, malicious code, malicious software and overload the server applications or programs.
For many years, only the large scale businesses in India had web hosts and thus small-sized businesses were operating using the usual way in the advertisement so as to promote their sales.
Manchester Web Design
nice post I really enjoy reading this post. thank you for sharing this post.
This is a good read for me, Must accept that you are just one of the best blogger I ever noticed. Thanks for publishing this great article.
Strimedix | Dandruff
Post a Comment