Connecting MySql
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
mysql>
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
mysql>
What am I doing wrong?
oops
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.
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Bookmarks