webstudent Posted February 5, 2015 Share Posted February 5, 2015 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 Link to comment Share on other sites More sharing options...
Larry Posted February 6, 2015 Share Posted February 6, 2015 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. Link to comment Share on other sites More sharing options...
webstudent Posted February 6, 2015 Author Share Posted February 6, 2015 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 ) Link to comment Share on other sites More sharing options...
Larry Posted February 7, 2015 Share Posted February 7, 2015 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). Link to comment Share on other sites More sharing options...
webstudent Posted February 7, 2015 Author Share Posted February 7, 2015 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. Link to comment Share on other sites More sharing options...
Larry Posted February 11, 2015 Share Posted February 11, 2015 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. Link to comment Share on other sites More sharing options...
webstudent Posted February 12, 2015 Author Share Posted February 12, 2015 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! Link to comment Share on other sites More sharing options...
Larry Posted February 13, 2015 Share Posted February 13, 2015 Awesome. Thanks for letting me know! Link to comment Share on other sites More sharing options...
Recommended Posts