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 and therefore doesn’t require a config file. If you want…
A bunch of ramblings about PHP programming, JQuery, MySQL and other 'stuff'
On Mountain Lion, I found that the my.cnf file is missing. This is because Mac uses the default MySQL settings and therefore doesn’t require a config file. If you want…
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
I found that after install MySQL and Apache/PHP – that the database connections didn’t work from PHP. They worked if I tried to connect using the MySQL client though. Must…
mysql_connect(): A connection attempt failed because the connected party did not properly respond after a period of time Shouldn’t be using these functions anymore anyway as they are discouraged, however,…
Well. I have had to sort out a report for someone who likes using Microsoft Access. We use the MySQL ODBC driver, called MyODBC Connector. But its relationship with Access…
To rename a field, there are loads of examples and different syntax on the web, so I thought I would blog the only one that works for me: ALTER TABLE…
Just a simple copy record function. First of all, pick a random temporary table name, and ensure you don’t have a table in your database by that name. Then, copy…
To install MySQL on Centos is a little different from Ubuntu – as I found out. Obviously APT is replaced with yum on this flavour of Linux, but not only…
I often set up mysql query logging when I am diagnosing a problem. In the my.cnf file, enter (or update the log parameter) log=/path/to/logfile.log Remember to restart the mysql service:…
Don’t use DATE_FORMAT when trying to assertain the latest date in a table. It won’t work. DATE_FORMAT will convert the dates to a string, and then the MAX will compare…