i Download ed mysql, unzipped it, ran setup.
then from prompt I started the mysqld sever, but when i try changing the password it gives me the error:
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.
I did 'telnet localhost 3306' to check the port and got this:
Could not open connection to host, on port 3306.
No connection could be made because the target machine actively refused it.
What can i do to get it working?if you installed mysql to your computer than how do you expect to telnet into your own computer?
what OS are you on?am running win xp prothen you need to run mysaql as a service and run winmyadmin.exe in teh bin folder of mysql. I wrote somethign about this let me find it.Running Mysql on win2000 as a Service, should be very close to XP
1. Install Mysql to the default location.
2. run c:\mysql\bin\WinMysqlAdmin (c: is the drive letter you installed mysql to)
3. it should ask for a username and password, this is for root access.
4. looking at the ini tab make sure mysqld-nt is checked.
5. right click anywhere and click on "install as Service"
6. don't start the service just yet, you need to go into the services
panel, start->settings->control panel->Administative Tools->Services
find the mysql one and right click on it and goto properties.
7. On the second tab (log) make sure it is second radio button,
then click on browse to find the user that will run this servive
everytime the computer starts. enter there password and then click
on apply and then ok.
8. then back in WinMysqlAdmin right click anywhere and start the service.
then from prompt I started the mysqld sever, but when i try changing the password it gives me the error:
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.
I did 'telnet localhost 3306' to check the port and got this:
Could not open connection to host, on port 3306.
No connection could be made because the target machine actively refused it.
What can i do to get it working?if you installed mysql to your computer than how do you expect to telnet into your own computer?
what OS are you on?am running win xp prothen you need to run mysaql as a service and run winmyadmin.exe in teh bin folder of mysql. I wrote somethign about this let me find it.Running Mysql on win2000 as a Service, should be very close to XP
1. Install Mysql to the default location.
2. run c:\mysql\bin\WinMysqlAdmin (c: is the drive letter you installed mysql to)
3. it should ask for a username and password, this is for root access.
4. looking at the ini tab make sure mysqld-nt is checked.
5. right click anywhere and click on "install as Service"
6. don't start the service just yet, you need to go into the services
panel, start->settings->control panel->Administative Tools->Services
find the mysql one and right click on it and goto properties.
7. On the second tab (log) make sure it is second radio button,
then click on browse to find the user that will run this servive
everytime the computer starts. enter there password and then click
on apply and then ok.
8. then back in WinMysqlAdmin right click anywhere and start the service.