Jump to content
Larry Ullman's Book Forums

Recommended Posts

Hi, I'm having a hard configurating mysql on my computer, I've already tried it 10 time after installing and uninstalling again and again.

 

after the installation of mysql, everything seem alright because I can read: configuration for mysql server 5.6.23 has succeeded. please click finish to continue.

 

but now when I try to get to mysql with the console cmd: c:\programme\mysql\mysql server 5.6\bin>mysql

I got this: error 1045 (28000): access denied for user'ODBC'@'localhost (using password: NO )

 

when I try this: c:\programme\mysql\mysql server 5.6\bin>mysqlshow -u root

I get this: access denied for user'root'@'localhost (using password: NO )

 

when I try this: c:\programme\mysql\mysql server 5.6\bin>mysqlshow -u root -p password

I first get this: enter password:******

after I entered the password I gave in my configuration, I get this: Unknown database 'password'

 

I don't know what to do

Share this post


Link to post
Share on other sites

I'm not sure why you're using "mysqlshow" instead of just "mysql". But use `mysql -u root -p` and then enter the root user password at the prompt. 

Share this post


Link to post
Share on other sites

you're right, but as I first used "mysql" I got this error > error 1045 (28000): access denied for user'ODBC'@'localhost (using password: NO )

 

 

then after that I used "mysqlshow -u root -p password" and "mysql -u root -p", it worked both. I could acces mysql.

 

but then comes another problem as I tried to change the password by using "mysqladmin -u root -p password 'newNEWpassword'; I then entered the configuration root user password at the prompt. now I can't access mysql anymore. I get an error like this with any password I use > error 1045 (28000): access denied for user'ODBC'@'localhost (using password: YES )

Share this post


Link to post
Share on other sites

Okay, to start, you need to make sure you're trying to do everything as the right user. If you use `some-command -u root`, you'll be attempting to execute that command as root. The times you're seeing "access denied for user 'ODBC'", you're not trying to execute as root, and your system is using the default user ("ODBC", who is probably neither an administrator nor has a password set). 

Share this post


Link to post
Share on other sites

Yes I started it again after I tried to changed the password with "mysqladmin -u root -p password 'newNEWpassword'".

 

 

So I tried again to execute the command as root with "mysql -u root -p". I got this error --> "error 1045 (28000): access denied for user'root'@'localhost (using password: YES )". I've entered any password and nothing seems to work.

Share this post


Link to post
Share on other sites

So this is progress, then, as you know you're using "root". It looks like you have successfully changed the password and no longer know what the right one is. I'd try all the likely values you've used, but if you still can't find the right one, look online for instructions for resetting the MySQL root password. 

Share this post


Link to post
Share on other sites

sorry Now I know why I couldn't find the password. the passward was actually  'newNEWpassword', I wrote the whole syntax as it was in the book. I didn't know I had to change  'newNEWpassword' with my new password. now it works. thank you!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×