Entropy.ch Discussion Forums Forum Index Entropy.ch Discussion Forums
Discussion forums about Mac OS X software development.
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

phpMyAdmin on Leopard

 
Post new topic   Reply to topic    Entropy.ch Discussion Forums Forum Index -> PHP on Mac OS X
View previous topic :: View next topic  
Author Message
Frédéric



Joined: 01 Nov 2003
Posts: 2
Location: Neuchâtel

PostPosted: Sat Nov 10, 2007 14:15    Post subject: phpMyAdmin on Leopard Reply with quote

Hello everyone, I was wondering if someone had successfully installed phpMyAdmin on 10.5?

I have activated the default php coming with Leopard, installed mySQL 5.0.45 without problem, except for the System pref. panel which doesn't seem to work but mySQL is starting so I don't mind. Then I downloaded phpMyAdmin 2.11.2! So far it is still not working a socket problem. It's probably very simple, but I don't know enough to make it work, maybe just a symbolic link missing??

Code:
mysql> status
--------------
./bin/mysql  Ver 14.12 Distrib 5.0.45, for apple-darwin8.5.1 (i686) using readline 5.0

Connection id:      1
Current database:   
Current user:      root@localhost
SSL:         Not in use
Current pager:      stdout
Using outfile:      ''
Using delimiter:   ;
Server version:      5.0.45 MySQL Community Server (GPL)
Protocol version:   10
Connection:      Localhost via UNIX socket
Server characterset:   latin1
Db     characterset:   latin1
Client characterset:   latin1
Conn.  characterset:   latin1
UNIX socket:      /tmp/mysql.sock
Uptime:         3 hours 48 min 27 sec

Threads: 1  Questions: 4  Slow queries: 0  Opens: 12  Flush tables: 1  Open tables: 6  Queries per second avg: 0.000
--------------


Quote:
"#2002 - Le serveur ne répond pas. (ou l'interface de connexion ("socket") vers le serveur MySQL local n'est pas correctement configurée)"

I'm working on a MacBook Pro 2.33 Ghz
Back to top
View user's profile Send private message AIM Address
solsys



Joined: 20 Jan 2006
Posts: 4

PostPosted: Sun Nov 11, 2007 8:38    Post subject: Reply with quote

This is a known issue in Leopard, basically the system is looking for the mysql.sock file in the wrong place. Just need to create a symlink and you should be in business:

sudo mkdir /var/mysql/
sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock

The MySQL pref pane still won't work, but I imagine they'll fix it shortly.

Hope that helps.
--
Josh
Back to top
View user's profile Send private message
Frédéric



Joined: 01 Nov 2003
Posts: 2
Location: Neuchâtel

PostPosted: Sun Nov 11, 2007 11:00    Post subject: Reply with quote

solsys wrote:
Hope that helps.


It dit indeed work, thanks a lot Josh !
I lost 3-4 days on that, but when one doesn't know what one is doing, hey?

Cheers...
Back to top
View user's profile Send private message AIM Address
mattia



Joined: 08 Dec 2007
Posts: 1

PostPosted: Sat Dec 08, 2007 14:24    Post subject: Reply with quote

hello I follow your instuctions but I still have trouble...
I resume my procedure done till now.
Enable the OSX native php, and decomment even the line about mySQL in the php.ini file in /private/etc/php.ini
Install the mySQL 5.0.45 downloaded from the dev site of mySQL. Insltalled as usual. It is up and running, but if I try to connect using phpMyAdmin no way!
I try even the symbolic link suggested here but it gives me always the same error:
MySQL said: Documentation
Cannot connect: invalid settings.
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Entropy.ch Discussion Forums Forum Index -> PHP on Mac OS X All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group