Root password issue at install

[David Ehmer]

Having a problem setting up a password for MySQL

The reported problem when attempting to set up a root password is;

C:\mysql\bin>mysqladmin version
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'

When checking this:

C:\mysql\bin>telnet localhost 3306
Connecting To localhost...Could not open connection to the host, on port
3306: C
onnect failed

Appreciate any suggestions
David

[John Richards]

David Ehmer wrote:

Having a problem setting up a password for MySQL

The reported problem when attempting to set up a root password is;

C:\mysql\bin>mysqladmin version
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'

When checking this:

C:\mysql\bin>telnet localhost 3306
Connecting To localhost...Could not open connection to the host, on port
3306: C
onnect failed

Appreciate any suggestions
David

I found the same when installing under Mandrake Linux 9.1 so I just
configured it so that I use it as root with no password, as the manual
suggests in this case. It may not be the ideal from a security point of
view, but I am the only user on my machine, and I never use the Database
online, so that does not worry me unduly. It certainly works OK like that.

Best wishes

John Richards