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
相关文档：
有时候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 ......
他将多个表在逻辑上当作一个表来查询。他建立后有两个文件，
.frm 表结构定义
.mrg union表的名字清单
两个基本表:
CREATE TABLE TEST_MERGE_1(
ID INT(5) NOT NULL,
VALUE VARCHAR(100) NOT NULL,
PRIMARY KEY(ID)
)
CREATE TABLE TEST_MERGE_2(
ID INT(5) NOT N ......
2009年10月30日 星期五 22:53
1, 查看MySQL
服务器配置信息
mysql> show variables;
mysql> show variables;
2, 查看MySQL服务器运行的各种状态值
mysql> show global status;
mysql> show global status;
3, 慢查询
mysql> show variables like '%slow%';
+--------------- ......
最近一直在进行Penrose连接Mysql的尝试，可总是提示无法连接到Mysql，无论是检查端口是否开启，设置Mysql远程访问权限等都不管用，后来在Penrose的官网找到一个建立样例数据库及设置远程连接的文档，没想到一举成功，痛快啊！
下面就把文档和大家共享一下！（是英文，大家就凑合着看下吧！因为最近搞Penrose太累了， ......
网上很多写在windows下无法载入mysql扩展解决办法，但是在liunx下的就没几个，以下是在liunx下的解决办法
重装后php不会自动把mysql.so扩展加上去,要
sudo vim /etc/php5/apache2/conf.d/pdo.ini
加入extension=mysql.so就可以了
其实也可以在 /etc/php5/apache2/php.ini中加入
也可以在/etc/php5/apache2/conf. ......
