Missing mysql.sock on mac lion with Zend server

If you have MySQL server installed on Mac OS X Lion and after you install Zend Server
maybe you have this error:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)
to fix this error you need to make this link:

sudo ln -s /private/tmp/mysql.sock /usr/local/zend/mysql/tmp/mysql.sock

Good luck :)

Run Jdeveloper on mac lion

To run JDeveloper on mac lion you need :

1- create file and name it java_setting.sh
2- put this in file

#!/bin/bash 

mkdir /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6

mkdir /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/bin

ln -s /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/bin/java /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/bin/java

ln -s /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/bin/javac /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/bin/javac

ln -s /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/bin/javap /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/bin/javap

ln -s /System/Library/Java/Support/Deploy.bundle/Contents/Home/bin/javaws /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/bin/javaws

ln -s /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/bin/jar /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/bin/jar

ln -s /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/bin/xjc /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/bin/xjc

mkdir /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/lib

ln -s /system/library/java/javavirtualmachines/1.6.0.jdk/contents/classes/classes.jar /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/lib/tools.jar

mkdir /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/jre

mkdir /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/jre/bin

ln -s /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/bin/java /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/jre/bin/java

mkdir /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/jre/lib

ln -s /system/library/java/javavirtualmachines/1.6.0.jdk/contents/classes/classes.jar /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/jre/lib/rt.jar

3- chmod +x java_setting.sh

4- sudo ./java_setting.sh

After that run jdevstudio11121install.jar and install .

thanks

Install mysql server 5.5 on mac lion

To install mysql server NOT MAMP only mysql server follow this link :

http://www.djangoapp.com/blog/2011/07/24/installation-of-mysql-server-on-mac-os-x-lion/

Compare two columns using like syntax In MYSQL

if you have two tables:

emp (id , name, grad)

grad (id, name)

 and you want to compare column (emp.name and grad.name) with LIKE % use this:

select e.name, g.name 

from emp e inner join grad g 

ON e.grad like CONCAT('%',g.name, '%');

Good example for CRUD OOP for PHP and MYSQL

By creating a MySQL CRUD class you can easily create, read, update and delete entries in any of your projects, regardless of how the database is designed.

This is good example for CRUD OOP for PHP and MYSQL: 


http://net.tutsplus.com/tutorials/php/real-world-oop-with-php-and-mysql/

Arabic problem in mysql command line client

To make mysql show arabic in command line use add this command :

mysql -u root -p --default-character-set=utf8

Fix "Can't connect to local MySQL server through socket '/tmp/mysql.sock'"

If you use Zend server or MAMP and when you trying to connect to MySQL and got this error above just check the path to mysql.sock and link it in /tmp/ folder like this:

sudo ln -s /usr/local/zend/mysql/tmp/mysql.sock /tmp/mysql.sock