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
相关文档：
mysql 截取某一个时间(datetime类型)的日期：
方法1：select date(row_name) from table_name where row = row1;
方法2：select left(row_name, 10) from table_name where row = row1;
方法3：select cast(row_name as char[10]) from table_name where row = row1;
取得某个日期的time_t数值：select unix_times ......
前一篇文章中说到了LOAD命令，这里就来详细的给自己，顺便也给大家讲解下LOAD命令和批处理的数据导入功能。用的时候感觉MySQL用起来真的比较滋润。。。。
批处理导入文件，从sql文件导入数据到数据库中 ，批处理是一种非交互式运行mysql程序的方法， ......
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语� ......
1. -static 13%
--with-client-ldflags=-all-static
--with-mysqld-ldflags=-all-static
静态链接提高13%性能
2. -pgcc 1%
CFLAGS="-O3 -mpentiumpro -mstack-align-double" CXX=gcc \
CXXFLAGS="-O3 -mpentiumpro -mstack-alig ......
最近在做PHP与数据库交互的project，急于求成，模仿了下例子就开始动手，结果误把mysql_fetch_array写成了mysql_fetch_row,囧事来了，发现返回的数组居然是index=>value的形式，而明明记得是field name=>value的哈，查手册才明白。
1. mysql_fetch_array的函数原型是
array mysql_fetch_array ( resour ......
