View Single Post
  #4 (permalink)  
Old August 1st, 2004, 04:28 AM
halbrook halbrook is offline
Registered User
 
Join Date: Aug 2004
Location: Eugene, OR, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to halbrook
Default

Quote:
quote:Originally posted by sambrose
  
Quote:
quote: As of today, still no change in the zip files. 2 hours down the drain. This is why Open Source is still not considered 'ready for prime time'.


Why a waste of 2 hours?  I am going to assume that since it is a .zip file you downloaded, that your platform is Windows.

Solution:
1)Install the program.

2)Open your c:\mysql directory, then open the \bin directory and you will see a file called winmysqladmin. -- click it.  It will start up a GUI admin screen. Enter a username / password for it.  It WILL automatically create the file for you. -- DONE
I just had the same problem, so I came to this forum to find out what to do. All the chatter about how it is not part of the distro, then you come on and say click, click, DONE. I did what you said and it still did not work. I am a pretty fast typer, so I will finish with the my.cnf file. Have a good one...

Oh before I forget, for all those who want to save some time - here is the file per page 25-26 :D
Code:
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
#
# One can use all long options that the program supports.
# Run the program with -help to get a list of available options

# This will be passed to all mysql clients
[Client]
#password=my_password
port=3306
#socket=MySQL

# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# The MySQL server
[mysqld]
port=3306
#socket=MySQL
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
server-id = 1
# The following line is added from Page 26
local-infile = 1

# Uncomment the following if you want to log updates
log-bin

# Uncomment the following if you move the MySQL distribution to another location
#basedir = d:/mysql
#datadir = d:/mysql/data/

# Uncomment the following if you are NOT using BDB tables
#skip-bdb

# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=4M
#set-variable = bdb_max_lock=10000

# Uncomment the following if you are using Innobase tables
#innodb_data_file_path = ibdata1:400M
#innodb_data_file_path = c:\ibdata
#innodb_log_group_home_dir = c:\iblogs
#innodb_log_arch_dir = c:\iblogs
#set-variable = innodb_mirrored_log_groups=1
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[mysqlhotcopy]
interactive-timeout
Josh
Reply With Quote