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(列名…) ......
他将多个表在逻辑上当作一个表来查询。他建立后有两个文件，
.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 ......
对于针对字符串位置的操作，第一个位置被标记为1。
ASCII(str) 返回字符串str的最左面字符的ASCII代码值。如果str是空字符串，返回0。如果str是NULL，返回NULL。
mysql> select ASCII('2');
-> 50
mysql> select ASCII(2);
-> 50
mysql> select ASCII('dx');
-> 100
也 ......
---- 在数据库的应用开发中，常常会遇到性能和代价的之间矛盾。以作者在开发股市行
情查询和交易系统中遇到的问题为例，要在实时记录1000多只股票每分钟更新一次的行
情数据的同时，响应大量并发用户的数据查询请求。考虑到性价比和易维护性，系统又
要求在基于PC服务器，Windows NT平台的软硬件环境下实现。开 ......
最近在做PHP与数据库交互的project，急于求成，模仿了下例子就开始动手，结果误把mysql_fetch_array写成了mysql_fetch_row,囧事来了，发现返回的数组居然是index=>value的形式，而明明记得是field name=>value的哈，查手册才明白。
1. mysql_fetch_array的函数原型是
array mysql_fetch_array ( resour ......
