Where is my.cnf on Mac OSX?
On Mountain Lion, I found that the my.cnf file is missing. This is because Mac uses the default MySQL settings…
Start/Stop MySQL from Mac OSX Terminal
So you want to stop MySQL, or restart it? sudo /usr/local/mysql/support-files/mysql.server start sudo /usr/local/mysql/support-files/mysql.server stop sudo /usr/local/mysql/support-files/mysql.server restart
Mac OSX 10.8 PHP, mysql.sock not found
I found that after install MySQL and Apache/PHP – that the database connections didn’t work from PHP. They worked if…
mysql_connect(): A connection attempt failed
mysql_connect(): A connection attempt failed because the connected party did not properly respond after a period of time Shouldn’t be…
MyODBC and Access – Urgh
Well. I have had to sort out a report for someone who likes using Microsoft Access. We use the MySQL…
MySQL Rename Field
To rename a field, there are loads of examples and different syntax on the web, so I thought I would…
Copy a record within the same table MySQL
Just a simple copy record function. First of all, pick a random temporary table name, and ensure you don’t have…
How to install MySQL Server on Centos
To install MySQL on Centos is a little different from Ubuntu – as I found out. Obviously APT is replaced…
Logging MySQL Queries
I often set up mysql query logging when I am diagnosing a problem. In the my.cnf file, enter (or update…
Using MAX and DATE_FORMAT to get the latest date from a MySQL table
Don’t use DATE_FORMAT when trying to assertain the latest date in a table. It won’t work. DATE_FORMAT will convert the…