So here I am trying to set a root password for mysql and I am looking at something like this:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18 to server version: 3.23.38-max-debug
type 'help:' or '\h' for help. Type '\c' to clear the buffer
and I type at the prompt:
mysql> mysqladmin -u root password "this is secret";
then I get:
ERROR 1064: You have an error in your SQL syntax near 'mysqladmin -u root password "this is secret"' at line 1
What am I doing wrong?
I just realized that the title was very misleading. That is because I was working from the dos prompt c:\mysql\bin>, I stop getting the connection failed problem after I typed in mysql-opt and mysql again. But this one I can't figure out.
mysqladmin is a separate binary. You execute it from the command prompt, not from within the mysql binary.
So at the c:\mysql\bin> prompt you type the mysqladmin line.