MySQL: Connect MySQL GUI tools to WAMP 2.0
Connect MySQL GUI tools to WAMP 2.0
Posted by: Vladislav Sadykov ()
Date: January 24, 2009 09:31AM
Hay, I have a problem with MySQL database.
I have installed WAMP 2.0 server on my Windows machine and now I would like to
connect it with MySQL GUI tools 5.
The problem is that at the startup of MySQL administrator application I get this message:
"Either the server service or the configuration file could not be found.
Startup variables and service section are therefore disabled."
I have tried to install the MySQL GUI tools to the "C:\wamp\bin\mysql" directory but I get still the same message.
Maybe I need to modify some of the files to connect MySQL GUI tools to MySQL server but I don't know which one.
Can some one help me with this.
Re: Connect MySQL GUI tools to WAMP 2.0
Posted by: Ceasar Capuno ()
Date: January 29, 2009 11:47AM
from your MySQL Administrator Authentication window hold on the "ctrl" key to change the cancel button to "skip". Under Service Control Menu select the configure service tab and you'll notice that the directory of your config file is with red font, it means that the config file were not found. Since you are using wamp, you should use WAMP's config file instead of my.cnf and you can find it inside your wamp folder named "wampmanager.conf".
Upon correcting the config file directory you should start your wamp server and try to reconnect using your MySQL Administrator. I hope this helps you.
Re: Connect MySQL GUI tools to WAMP 2.0
Posted by: james bond ()
Date: February 19, 2009 01:35AM
Ceasar, you make my day. Your suggestion works perfectly
Del.icio.us : mysql
相关文档：
一、INSERT和REPLACE
INSERT和REPLACE语句的功能都是向表中插入新的数据。这两条语句的语法类似。它们的主要区别是如何处理重复的数据。
1. INSERT的一般用法
MySQL中的INSERT语句和标准的INSERT不太一样，在标准的SQL语句中，一次插入一条记录的INSERT语句只有一种形式。
INSERT INTO tablename(列名…) ......
有2个不同的方法增加用户：通过使用GRANT语句或通过直接操作MySQL授权表。比较好的方法是使用GRANT语句，因为他们是更简明并且好像错误少些。
下面的例子显示出如何使用MySQL客户安装新用户。这些例子假定权限已缺省被安装。这意味
着为了改变，你必须在MySQL正在运行同一台机器上，你必须作为MySQL
ro ......
有时候nginx，apache，mysql，php编译完了想看看编译参数可以用以下方法
nginx编译参数：
#/usr/local/nginx/sbin/nginx -V
CODE:
nginx version: nginx/0.6.32
built by gcc 4.1.2 20071124 (Red Hat 4.1.2-42)
configure arguments: --user=www --group=www --prefix=/usr/local/nginx/ --with-http_stub_status_mo ......
use mysql
update user set Password=password('newpassword') where User='root';
flush privileges;
1.通过修改MYSQL数据库中MYSQL库的USER表
就用普通的UPDATE、INSERT语句就可以
2.在命令行中使用如下命令
MYSQLADMIN -u root -p PASSWORD mypasswd
3.可以修改MYSQL文件夹中的MY.INI文件
4.使用SET PASSWORD语� ......
这段时间被这个困扰了很久，通过修改配置文件，终于把这个问题解决了。
自己在网上也找了很多关于解决这个问题的方法，但是都讲的不太清楚，所以今天在这重新说下这个问题。
我的解决方法是通过修改mysql的配置文件my.ini，方法如下：
在my.ini中可以发现有这么一段代码：
[client]
port=3306
[mysql]
default ......
