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?
- 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.
If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.
If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installations is still needed to connect to the server. In this case please select skin now and re-run the Configuration Wizard from the start menu.
Please revert me, if you need more assistance, i would be very glad to assist you more.
If you were satisfied with the solution please rate this sollution.
Lost or forgot your administrator/user password for Microsoft SQL Server?
If so, turn to help from AnyPasskeySQL Password Recovery,
which is a professional program enables you reset administrator or user
password for Microsoft SQL Server instantly regardless of the length,
complexity, language and encoding of the password set before. As long as
you got AnyPasskey SQL Password Recovery and master.mdf file, you could
reset SA password on any authorized PC in minutes without the
installation of Microsoft SQL Server. What's more, this featured-in tool
supports all versions of Microsoft SQL Server and Microsoft SQL Server
MySQL offers Check Table syntax that checks a table or tables for errors. It works for several storage engines like MyISAM, InnoDB, & Archive. If you run this syntax then you can the cause of problem & reported tables.
If Check Table finds errors then you can repair reported tables by Repair MySQL Table syntax.
When you install MySQL for the first time, no password is set for root user.
Move to the installation directory of mysql (cd/usr/local/mysql) Set the password for user, using the following command - ./bin/mysqladmin -u <username> password
Enter your password. Then you can connect to the mysql client as
./bin/mysql -u <username> -p <password>