error message i get when trying to work with mysql 1

[pssheba]

Hi !
I installed mysql on my win2000 platform and tried to do the following:
\mysql\bin\mysqladmin -password newpassword
I get an error message saying:
"connect to server at localhost failed".
I'm new to mysql.
Can anyone tell me what i have done wrong ?
Thanks!

 

[ericbrunson]

The command is "mysqladmin -p password newpassword"

-p says prompt me for the current password
password is the command "I want to change the password"
newpassword is the new password

 

[TLowder]

also be sure
mysqld-nt
is running in your task manager

 

[pssheba]

OK
I opened a dos window and typed: \mysql\bin\mysqld-nt.
Then i typed:
"mysqladmin -p password" and i was asked: "Enter password".
I typed "mypass" and recieved:
"MYSQLADMIN: connect to server at 'localhost' failed
error: 'Access denied for user:'ODBC@localhost' <Using password: YES>'".

I havent done anything yet with mysql, only installed it and this is the first thing i do and all i get is an error message. I have no database or any table created by myself.
Should i first create database in order to change password ?
Thanks anyway !

 

[ericbrunson]

Go back and read my first post again.

-p says prompt me for the CURRENT password

The new password is entered on the command line.

 

[pssheba]

What excactly do you suggset ? That i type the current password ? I dont know the current password ! That i omit
-p ? that i omit "password" ? Any of those leadss to "Not connected".

 

[TLowder]

This might help

http://dev.mysql.com/doc/mysql/en/Access_denied.html

Have you set up a user called odbc? log on as root if you haven't set up users

Download this- mysql-administrator-1.0.12-win.zip
And this - mysqlcc-0.9.4-win32.zip
if you haven't already their easy to use gui interfaces

Tom

 

[ericbrunson]

If you don't know the current password, then that is a completely different problem. There is a completely different procedure to set a forgotten password.

If the user has no password, then you can just leave off the -p.

Otherwise you would connect as a different user using mysql and set the password using either GRANT or SET PASSWORD.

If you don't know the password for *any* user with permissions to set other peoples password then you can google for 'mysql manual forgotten password' and there is a good section in the mysql manual for resetting it.

If you don't correctly express your problem and you don't read the answers closely and follow directions accurately, then don't get all indignant when the answers don't resolve your problem.

 

[pssheba]

Thanks a lot Tom !
All i did so far is installing MySql. I have no users, no passwords and no Databases. I want to know how to create user, how to connect as a user, how to make password and what is "root's" password and how i can discover a user's password.
I'll use the links attached and hopefully i can start manage MySql.
And Thanks again.

 

[CTekGirl]

I wanted to provide a comment that I followed TLowder's tips and my server on MySQL is no longer getting connection errors. Thanks for your detail and clear steps. Well Done!

I hope it works for the original poster as well.