Archive for the ‘MySQL’ Category
MySQL CLI Output Formatting Tips
I’m sure you’ve seen results similar to this on a standard query:
Now, if you use the \G option (Send command to mysql server, display result vertically.):
That makes reading the output from command line really nice.
One more tidbit that I’ve found I like to do is use the \p option (Print current command.) combined with \G [...]
DBDesigner4 and MySQL 5.0: Together Again
If you’re struggling with “dbExpress Error: Invalid User/Pass ID” and you are using MySQL 5.0 server (Windows or Linux) this is because of the password structure changes.
DBDesigner4 (now MySQL WorkBench (OSS/SE)) was developed to work with MySQL 3 and MySQL 4. There is a workaround to allow you to connect to MySQL 5 servers though.
Add [...]