Somethings, I just forget…again and again. Yeah, I need to go through the W3C School’s SQL tutorial and learn more about it and databases in general, but for now, here are some helpful tips for people like me that rely on MySQL, but often fall into the same novice traps/problems.
- I do not install MySQL very often but when I do, I forget how to set the initial passwords. Post installation instructions
- I then sometimes, have a problem (if I install MySQL 4.1) with the MySQL 4.1+ password hashing algorithm. The error: “Client does not support authentication protocol requested by server; consider upgrading MySQL client.” The solution:MySQL 4.1+ password hashing algorithm
- Don’t forget to check out MySQL’s own GUI app: MySQL Administrator.