467,136 Members | 1,252 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,136 developers. It's quick & easy.

Error 1045 OBDC@localhost...Using password YES

I posted a message earlier regarding denial of access into mysql
database - "Error 1045 Acess denied to user ODBC@localhost..Using
password YES". I've just came across a possible solution in mysql
manual, section:A.4.2 "How to Reset a Forgotten Root Password" where
it says:

# Take down the mysqld server by sending a kill (not kill -9) to the
mysqld
# server. The pid is stored in a `.pid' file, which is normally in
the MySQL
# database directory:
# shell> kill `cat /mysql-data-directory/hostname.pid`
# You must be either the Unix root user or the same user mysqld runs
as to do
# this.
# Restart mysqld with the --skip-grant-tables option.
# Set a new password with the mysqladmin password command:

This gist hasn't really helped me out, or I should perhaps say that I
can't figure out the steps the above info is suggesting. I'm using
windows 98 - incase OS info will be required for any analysis.

Does anyone know how exactly I can restart mysqld with
the---skip-grant-table option?

For clarity, I'd like to mention that I did not forget my password - I
simply could not acces mysql from the command prompt as usual with
c:\mysql\bin\-root -p...Enter password ****, and so on!

I'm only trying this as a last resort - to get rid of the old password
so as to install a new one.

Your replies will be appreciated

Ike
Jul 19 '05 #1
  • viewed: 5003
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Bruce A. Julseth | last post: by
reply views Thread by Morten Gulbrandsen | last post: by
4 posts views Thread by 21novembre@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.