Tag Archives: MySQL

OS X – Fail to start MySQL server which is installed by Homebrew

After i reboot my OS X, i find that i couldn’t start the MySQL server and it throws the following error:

hatuey:5.6.19 yingkityuen$ mysql.server start
Starting MySQL
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/hatuey.local.pid).

 

Go to the above folder and delete the mysql error log which is ended with .err. In my case, i executed the following command:

hatuey:5.6.19 yingkityuen$ rm /usr/local/var/mysql/hatuey.local.err

Where hatuey is my Mac machine name.

This should fix the problem.

Done =)

Reference: Mahdi Yusuf – MySQL ‘The server quit without updating PID file’

Advertisements

MariaDB – Installation on Ubuntu Precise

Next: Run phpMyAdmin on Nginx in Ubuntu Precise

It’s time to give up MySQL and move on to MariaDB. Here is the steps for MariaDB installation on Ubuntu Precise (Ubuntu 12.04.1 LTS) with root privilege.

1. Create the following file.
/etc/apt/sources.list.d/MariaDB.list

# http://downloads.mariadb.org/mariadb/repositories/
deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntu precise main
deb-src http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntu precise main

Continue reading MariaDB – Installation on Ubuntu Precise

Drupal 7 – Create a Datetime field in hook_schema() @ 1

Next: Drupal 7 – Create a Datetime field in hook_schema() @ 1

If your custom module requires an additional table in the Drupal database, you have to create the .install file and define the schema inside it. In Drupal 7, the datetime field is no longer support by the Drupal Schema API. If you want to create a datetime field, you have to use the mysql_type or pgsql_type. Here is an example.
Continue reading Drupal 7 – Create a Datetime field in hook_schema() @ 1

PHP – PHP 5.3 Repository for CentOS from Webtatic.com

Webtatic.com provides its own repository. If you want to get the latest packages such as PHP and MySQL, you can consider adding it to your yum repo by the following steps.

1. Add the yum repository information

Continue reading PHP – PHP 5.3 Repository for CentOS from Webtatic.com