Local Installation (XP) - Especially MySQL

[Julio]

I renewed my subscription to download vb3 a few months ago. Since, I have tried to install it, without success.

I installed Apache and PHP 4.3.10 these are no brainers.

Installed MySQL 5, 4.0 up to 4.2.14 Most of the time, installation will not finish due that it is not able to start the service. A few times it has finished and I when I try to install vb3, it will give some errors related to MySQL.

I have read and tried a zillion times. I am pretty sure it has to do with MySQL installation. (Maybe I am wrong).

Can someone please let me know which versions should I install to verify I will have no issues? Links?

Is there any installation guide or suggestions on how should I install/setup MySQL and the database under WinXP? (posted by a user or support)

[Zachery]

First, uninstall all of your other versions of MySQL.
Then get the MySQL installer for 4.0.25 for windows and have it run. It will setup everything you need. And after that you should basicly be good to go.

[Julio]

Zach:

1. Thanks for replying. As usual you have always helped me with success. A+ for your excellent support.

2. I downloaded the MySQL install 4.0.25 as you requested and installed it.
When I try to set the password for root, or setup a new database for vb, and assign privileges, I get "ERROR 2004: Can't create TCP/IP socket (0)"

3. I tried using the WinMySQLAdmin, but I can not modify anything in there.
Should I install MyPHPAdmin ?

[Zachery]

Hmm, thats odd...

Go into the mysql/bin directory via cmd (somthing like c:\mysql\bin or c:\Program Files\MySQL\Bin) and type mysql and see what happens. If you get an error, try mysql -uroot

You might try sotmhing like this from run

cmd /k c:\mysql\bin\mysql.exe -uroot

[Julio]

Tried that as well.. same error.

[Zachery]

From the command line again type

ping localhost

[Julio]

It replied OK.. no problem

From the command line again type

ping localhost

[Zachery]

Since your running Windows XP type

net stop mysql

After regardless of the message type

net start mysql

[Julio]

The MySQL service could not be started
A system error has ocurred
System error 1067 has occured
The process has terminated unexpectedly

P.S - I am trying the installation in another PC. (Laptop)

Since your running Windows XP type

net stop mysql

After regardless of the message type

net start mysql

[Zachery]

Think I got it tracked down, you should have in c:\ or c:\windows or c:\mysqldir a my.ini or my.cnf

If you hae a my.cnf in any of those locations remove it. If you have a my.ini file please post the contents of it (minus any passwordS)

[Julio]

#This File was made using the WinMySQLAdmin 1.4 Tool
#8/29/2005 1:56:51 PM

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

[mysqld]
basedir=C:/mysql
#bind-address=My IP
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=root
password=*********

[Julio]

#This File was made using the WinMySQLAdmin 1.4 Tool
#8/29/2005 1:56:51 PM

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

[mysqld]
basedir=C:/mysql
#bind-address=my IP
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=root
password=*********

[Zachery]

Try using this instead.

[client]
port=3306
[mysqld]  
port=3306
basedir=C:/mysql/
datadir=C:/mysql/Data/
wait_timeout = 180
connect_timeout = 10  
max_allowed_packet = 16M
max_connect_errors = 10    
skip-innodb
[mysqld_safe]   
open_files_limit = 8192  
[mysqldump]  
quick  
max_allowed_packet = 16M  
[myisamchk]   
key_buffer = 64M   
sort_buffer = 64M  
read_buffer = 16M  
write_buffer = 16M

[Julio]

Nope.. same error

Actually same error in both machines.

[Zachery]

Very odd... My own MySQL has been running just fine in windows for the longest time..

Your not running any firewall or antivirus software are you?