Mysql 4.0 configure file my.ini

[pfj511]

#2008-01-14 14:17:33

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=D:/MySQL
bind-address=127.0.0.1
datadir=D:/MySQL/data
#language=D:/MySQL/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
set-variable = max_connections=1500 
set-variable = max_allowed_packet=16M 
skip-locking 
#skip-networking 
set-variable = key_buffer=384M 
set-variable = max_allowed_packet=1M 
set-variable = table_cache=512 
set-variable = sort_buffer=2M 
set-variable = record_buffer=2M 
set-variable = thread_cache=8 
# Try number of CPU's*2 for thread_concurrency 
set-variable = thread_concurrency=8 
set-variable = myisam_sort_buffer_size=64M 
#set-variable = connect_timeout=5 
#set-variable = wait_timeout=5 
server-id = 1 
[isamchk] 
set-variable = key_buffer=128M 
set-variable = sort_buffer=128M 
set-variable = read_buffer=2M 
set-variable = write_buffer=2M 
[myisamchk] 
set-variable = key_buffer=128M 
set-variable = sort_buffer=128M 
set-variable = read_buffer=2M 
set-variable = write_buffer=2M 
[WinMySQLadmin]
Server=D:/MySQL/bin/mysqld-nt.exe
user=root
password=

[snirben]

password need be empty? and all the empety = need be empety?

[pfj511]

Originally Posted by snirben

password need be empty? and all the empety = need be empety?

just need same with you own mysql

my sql has two account

root password is empty( so that the Navicat for MySQL can open the sql without the password)

test test

[DarkBebi]

I DO NOT UNDERSTAND THIS, where do i put this, how do i put this in. please someone help me... do i change the bind address to my ip so others can play?

[pfj511]

Originally Posted by DarkBebi

I DO NOT UNDERSTAND THIS, where do i put this, how do i put this in. please someone help me... do i change the bind address to my ip so others can play?

in mymsql folder ,if your sql in c disk you only need to modify the dir in this file