SOMEBORY KNOWS HOW TO INSTALL MYSQL 3.22 ON WIN XP SP2 1

[Arauco]

Can´t start the service MySQL like a service on Win XP sp2, try every thinks I guess, but still don´t run up it.
The light it´s allways on red. (semaforo).
Anybory knows the steps to working on?

Thank you very much.

 

[TonyGroves]

Is the service installed? If not, you'll need to run the command "mysqld-nt --install". Then, to start the service, use the command "net start mysql" (assuming the service name is "mysql").

 

[Arauco]

Dear friend Tony,

I made like you told. When I tipe have this:

" Failed to Install Service "

What I can do?

Thank you so much.

 

[TonyGroves]

There could be a couple of reasons for this -
- You're not logged in as administrator
- The service is already installed

By the way, MySQL 3.22 is ancient history. Is there any reason why you wouldn't install the current version, v. 4.1 instead?

 

[Arauco]

Very fast my friend,

I had MySQL 4.1 but can´t to work with him, I developed a application in VB 6.0 and in Java applet and the MySQL anser me some problem with cripthography?.
I´d like to work with 4.1 instead but how I do?

 

[TonyGroves]

Any application that works with MySQL 3.22 should work with 4.1. If you can uninstall 3.22 and install 4.1 now (as a service), you would be better off, as it is much more powerful. Then, you could let us know about any problems, showing us the exact error messages.

You would also need to install the MySQL ODBC or Java connector.

 

[Arauco]

Tony,

The Mysql 3.22 and my application working on very well under win98 in my notebook (with MyODBC and java connector). In my desktop with win xp don´t.
Even with drivers odbc. Right now when type for logon like in my notebook:
c:\mysql\bin\mysql -u root -p password
Enter password: pasword

I have: ERROR 2003: Can´t connect to MySQL server on 'localhost' <10061>.
Have I to put something about environment variables for MySQL?

Why don´t work in Win XP?

Thank you.

By the way my real name is Jorge, from Chile but living in Brazil since 1980 and admire you country.
I was on business in 2002 in New York, was like dream come through.
Since when I was a child I admire you country and his history.

 

[TonyGroves]

OK, you say the service is not running, and you can't start it or install it. Can you confirm that you were logged-in as administrator when you tried to start or install it?



(P.S. I'm not American, I'm Irish!)

 

[Arauco]

Hello Tony


When I try loggon I´m using de pass and user administrator, like the same way in win 98.

Do you play soccer to?,

Bye

 

[TonyGroves]

Can you show us your file c:\my.cnf and/or c:\windows\my.ini ?

 

[Arauco]

Ok!

There go!

My.Ini

[client]
port=3306

[mysqld]
port=3306
skip-locking
set-variable = max_connections=64
set-variable = read_buffer_size=1M
set-variable = key_buffer=8M
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=4M
server-id = 1

basedir = C:/MySQL/
datadir = C:/MySQL/data/

skip-bdb

innodb_data_file_path = ibdata1:10M:autoextend
set-variable = innodb_buffer_pool_size=32M
set-variable = innodb_additional_mem_pool_size=4M

set-variable = innodb_log_file_size=8M
set-variable = innodb_log_buffer_size=8M

innodb_flush_log_at_trx_commit=1

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

[mysql]
no-auto-rehash

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

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

[mysqlhotcopy]
interactive-timeout



Win.ini

; for 16-bit app support
[fonts]
[extensions]
[mci extensions]
[files]
[Mail]
MAPI=1
[MCI Extensions.BAK]
aif=MPEGVideo
aifc=MPEGVideo
aiff=MPEGVideo
asf=MPEGVideo
asx=MPEGVideo
au=MPEGVideo
m1v=MPEGVideo
m3u=MPEGVideo
mp2=MPEGVideo
mp2v=MPEGVideo
mp3=MPEGVideo
mpa=MPEGVideo
mpe=MPEGVideo
mpeg=MPEGVideo
mpg=MPEGVideo
mpv2=MPEGVideo
snd=MPEGVideo
wax=MPEGVideo
wm=MPEGVideo
wma=MPEGVideo
wmv=MPEGVideo
wmx=MPEGVideo
wpl=MPEGVideo
wvx=MPEGVideo

 

[TonyGroves]

That my.ini looks fine, assuming your MySQL directory is c:\mysql and the data is stored in c:\mysql\data . If not, you will have to edit the file to suit. I can only suggest that you re-install (preferably version 4.1).

 

[Arauco]

Fine I´ll do

Thank you very much.