MySQL setUp Lion Client
>MySQL
download
http://www.mysql.com/downloads/mysql/
http://www.mysql.com/
check kernel
uname -a
64bit kernel >
Darwin hostname.local 11.2.0 Darwin Kernel Version 11.2.0: Tue Aug 9 20:54:00 PDT 2011; root:xnu-1699.24.8~1/RELEASE_X86_64 x86_64
32bit kernel > include [i386]
Download yuor match version
easy to use DMG version
install
pkg install
mysql-5.5.20-osx10.6-x86_64.pkg
MySQLStartupItem.pkg
MySQL.prePane install (easy to doubleclick)
Starting MySQL
easy to use PrefPane
set admin Password
use taminal
/usr/local/mysql/bin/mysqladmin -u root password rootPassword
after reload
/usr/local/mysql/bin/mysqladmin reload -u root -p
chenge MySQLConection
sudo nano /etc/php.ini
if not php.ini file
$ sudo cp php.ini.default php.ini
change php.ini for default socet
about line 1210
mysql.default_socket = /var/mysql/mysql.sock
change to
;mysql.default_socket = /var/mysql/mysql.sock
mysql.default_socket = /tmp/mysql.sock
about line 1279
mysqli.default_socket = /var/mysql/mysql.sock
change to
;mysqli.default_socket = /var/mysql/mysql.sock
mysqli.default_socket = /tmp/mysql.sock
restart WebServer from Taminal
slowly restart
sudo apachectl graceful
quickly restart
sudo apachctl restart
>phpMyAdmin
downloard
http://www.phpmyadmin.net/
setup
downlaod folder name chenge to [phpMyAdmin}
move to
/Library/WebServer/Documents/
change config
$ sudo cp /Library/WebServer/Documents/phpMyAdmin/config.sample.inc.php /Library/WebServer/Documents/phpMyAdmin/config.inc.php
change config.inc.php
$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
to
$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
$cfg['blowfish_secret'] = 'asdfghjk'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! may be random words */
PHP effectve
/etc/apache2/httpd.conf
#LoadModule php5_module libexec/apache2/libphp5.so
to
LoadModule php5_module libexec/apache2/libphp5.so
sudo apachectl graceful
acsecc Web browser
http://localhost/phpMyAdmin/
login root
