- 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.
This error means that mysql doesn't have sufficient memory to store the entire query result, so far no rocket science, the first thing you have to do is check your query it might be wrong, is it reasonable that it would return so many rows?
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>