problems with MySQL

dm3472

Hello

I was trying to run mysql under the Windows Xp,but it doesn't work. First I started mysqld-nt and after that I started
mysqladmin -u root PASSWORD 'krnekej' and when I did that I got message:

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'

what is the problem? I tried everything,but it doesn't work...anyone?

zmack

Hi Damjan,

When you start mysqld-nt, click on CNTRL + ALT + DEL. Amongst your processes, do you see the mysql process running?

Another question, within your mysql\bin folder, do you have a file called wimysqladmin?

Regards

-Abi

dm3472

Hello -Abi,

yes,I see the process mysqdl-nt running,

answer on second question...yes, I do have file wimysqladmin...
what should I do now?

Regards

Damjan

zmack

Launch winmysqladmin and let me know if you get a green light in your system tray. The green light indicates that the mysqld-nt process is well and truely up and running.

The error message that you are getting indicates that the process is not running properly.

If all else fails, completely uninstall the vesrion of mysql from your system manking sure that you delete the c:\mysql folder (make sure you kill the process otherwise you will be getting access errors). Then make a fresh install.

I suggest we troubleshoot this problem in anycase before you resort to the above.

-Abi

zmack

Hi Damjan,

some more info!

Make sure you have the windows version, just over 9MB download from
mysql.com (public version of win32). Then run setup.exe. It will install to
C:\mysql for default. Best is to leave it as default. If you change it, you
will have to change your mysql configuration later. If you install into
c:\mysql, then go to command line and try this
c:\cd mysql\bin [return]
c:\cd mysql\bin>mysqld --standalone [return]

then type exit.
Then go to the comand line again, type in
c:\cd mysql\bin [return]
c:\cd mysql\bin>mysql [return]

and you should get a welcome message

I found an excellent guide on the net:

Try this page -> www.analysisandsolutions.com/code/mybasic.htm

Hope this helps

-Abi

dm3472

Hi Abi

thx for everything,now it is working properly.

Regards

Damjan