Mysql Configuration Errorsconfiguration
Posted 5 February 2015 - 4:09 PM
Posted 6 February 2015 - 8:41 AM
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.
Posted 6 February 2015 - 6:15 PM
Posted 6 February 2015 - 8:00 PM
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).
Posted 7 February 2015 - 9:23 AM
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.
Posted 11 February 2015 - 9:21 AM
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.
Posted 12 February 2015 - 1:07 PM
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!
Also tagged with one or more of these keywords: configuration
PHP Advanced: Visual QuickPro Guide →
PHP Advanced and Object-Oriented Programming: Visual QuickPro Guide (3rd Edition) →