I went to the mysql prompt and typed ./bin/mysqladmin -u root password;
I get "You have an error in your SQL syntax" and it flags the entire line of code. You said "go to the installation directory of mysql (cd/usr/local/mysql)", is the same as the mysql prompt? 'Also, am I supporsed to be using 'root' as the username?
I was attempting to use the mysqldump command to convert my .frm files to a .sql file on my local machine. I was getting an ACCESS 1045 error because the username 'root' had never been associated with my password. I then attempted to create that association using the 'mysqladmin -u username -p password' command that was offered by several people, including you. I kept getting an error. I noticed from the postings that numerous other people were getting the same result. Turns out there shouldn't be spaces between the '-u' and 'username' or the '-p' and password, a simple point that wasn't stated explicitly. When I entered 'mysqladmin -uroot -ppassword', it worked.femster,
I was attempting to use the mysqldump command to convert my .frm files to a .sql file on my local machine. I was getting an ACCESS 1045 error because the username 'root' had never been associated with my password. I then attempted to create that association using the 'mysqladmin -u username -p password' command that was offered by several people, including you. I kept getting an error. I noticed from the postings that numerous other people were getting the same result. Turns out there shouldn't be spaces between the '-u' and 'username' or the '-p' and password, a simple point that wasn't stated explicitly. When I entered 'mysqladmin -uroot -ppassword', it worked.
You can't post conmments that contain an email address.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
femster,
I was attempting to use the mysqldump command to convert my .frm files to a .sql file on my local machine. I was getting an ACCESS 1045 error because the username 'root' had never been associated with my password. I then attempted to create that association using the 'mysqladmin -u username -p password' command that was offered by several people, including you. I kept getting an error. I noticed from the postings that numerous other people were getting the same result. Turns out there shouldn't be spaces between the '-u' and 'username' or the '-p' and password, a simple point that wasn't stated explicitly. When I entered 'mysqladmin -uroot -ppassword', it worked.
×