my sql don't start-help me please
Posted by: avnic (---.red.bezeqint.net)
Date: August 18, 2006 12:43PM

Hi everybody!!!

i just download wamp5_1.6.4a.exe

befor that version i have a older one

after install wamp5_1.6.4a.exe

when wamp start it's only start the apache
the mysql don't start
in the error log file i have this message

[ERROR] c:\wamp\mysql\bin\mysqld-nt.exe: Can't create/write to file 'c:\wamp\mysql\data\com2.pid' (Errcode: 2)

please help me!!!!

Options: ReplyQuote
Re: my sql don't start-help me please
Posted by: CyberSpatium (67.170.181.---)
Date: August 18, 2006 06:23PM

after you upgrade your mysql server you need to run MYSQL_UPGRADE to check for problems in your tables.

[dev.mysql.com]

what version of WAMP did you upgrade from? the current wamp 1.6.4 comes with mysql 5.0.22. According to mysql, when upgrading a 5.0 installation to 5.0.10 or newer, it is necessary to upgrade your mysql user grant tables. Otherwise, creating stored procedures and functions might not work.

Options: ReplyQuote
Re: my sql don't start-help me please
Posted by: avnic (---.red.bezeqint.net)
Date: August 19, 2006 03:14AM

hi!

when i do

C:\> bin\mysql -u root -p mysql

it ask for apassword i enter the root
and its say error 2003 can't connect to mysql server........


i run windows xp

Options: ReplyQuote
Re: my sql don't start-help me please
Posted by: CyberSpatium (67.170.181.---)
Date: August 19, 2006 08:23AM

wamp comes with the mysql root user set with no password, so when you are prompted for a password,just press enter.

to connect to mysql using php, use
mysql_connect('localhost', 'root', null);

Options: ReplyQuote
Re: my sql don't start-help me please
Posted by: avnic (---.red.bezeqint.net)
Date: August 19, 2006 10:25AM

it did the some problem

i have afirewall mcafee i shut it down and it did also the some problem

Options: ReplyQuote
Re: my sql don't start-help me please
Posted by: CyberSpatium (67.170.181.---)
Date: August 19, 2006 11:37AM

huh?

Options: ReplyQuote
Re: my sql don't start-help me please
Posted by: bugasty (---.ptprime.net)
Date: August 23, 2006 05:19PM

i think u just forgot your root password, by default is " ".
on c:\wamp\mysql\bin.
i have other problem. i can not connect to mysql using php. it just work using the console
thnak u
artur

Options: ReplyQuote


Sorry, only registered users may post in this forum.