Trouble with setting up server

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 375,205 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,356 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser:

Thread Tools Display Modes

Views: 2449 | Replies: 0

•

Join Date: Mar 2004

Posts: 715

Reputation: Phaelax is on a distinguished road

Rep Power: 6

Solved Threads: 27

Phaelax

Offline

Master Poster

Trouble with setting up server

Feb 7th, 2005

Running Win2kpro with mysql server 4.1. I installed the service "mysqld-max-nt.exe", but it won't run. It's set for automatic, but even if I try to activate it manually, it won't. I checked the event viewer and it shows only this:
"The mysql41 service terminated unexpectedly"
Could there be a problem with my config file?

my.cnf

Help with Code Tags

(Toggle Plain Text)

[mysqld]
prompt = mysql\\_\v>\\_
port = 3306 
basedir = C:/MySQL/MySQLServer41/
datadir = C:/MySQL/storage/data/
innodb_data_home_dir = C:/MySQL/storage/data/ibdata/ 
innodb_log_group_home_dir = C:/MySQL/storage/data/iblogs/ 
innodb_data_file_path = ibdata1:10M:autoextend 
# Make table names case sensitive. 
set-variable = lower_case_table_names=0

I was following the tutorial here: http://www.analysisandsolutions.com/...asic.htm#start

When I try to connect from the prompt, I get the error code 10061.

Also, the tutorial doesn't explain what InnoDB tables are. What's the difference with them?