goalseeker — 2012-11-21T01:24:27-05:00 — #1
At a very late stage in my life I am trying to learn mysql and php and hope someone can just point me in the right direction. I find it quite difficult to learn from a book no matter how well written.
I believe I have set my basics correctly, I am using wamp to access mysql and php plus apache.
I am at the stage of entering some basic commands to check things through such as
QUERY: mysqladmin --vesion
RESULT: mysqliadmin Ver 8.42 Distribution: 5.5.16 for win32 x86
QUERY: mysqladmin -u root status
RESULT: Uptime: 88456 Threads: 1 Questions: 1 Slow queries: 33 Flush Tables: 1 Open tables: 0 queries per second avg: 0.000
QUERY: mysqladmin -u root -p status
RESULT: enter password (entered)
mysqladmin connect to server at 'localhost' failed
error 'Access denied for user 'root'@'localhost' <using password YES>'
Can anyone please explain in simple terms what I may have done incorrectly, it is difficult to ask a book questions!
I should say I have written the simple code in one of the examples to display date on search and it displayed correctly.
vsdan — 2012-11-21T01:39:19-05:00 — #2
That usually means you entered your mySQL password incorrectly.
goalseeker — 2012-11-21T04:38:23-05:00 — #3
Thanks VSDan I believe I have entered password correctly and have also changed password with
mysqladmin -u root -p password(newpassword)
I am then asked to insert password I just created but get the above error.
guelphdad — 2012-11-21T08:53:22-05:00 — #4
no space between the -p and the password so -p password is incorrect and -ppassword is correct.
goalseeker — 2012-11-21T13:49:56-05:00 — #5
Hi I have tried that to see what happens but when I enter mysqladmin -u root -p status I again get the error.
When I wnter mysql I get welcome to the mysql monitor and can access details of the help files. I get all the commands available.
When I enter mysql -u root status I get the results I expect
Do I take it that the password entry is causing the problem even though I have attempted to reset the password as above.