Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Thu Apr 29, 2010 10:57 am 
Offline
Junior Member

Joined: Tue Oct 13, 2009 9:47 pm
Posts: 22
Website: http://imknight.net
Location: Singapore / Malaysia
hi all,

i have setup my linode with LEMP ( linux, nginx, mysql ,php) + php-fpm, now everything is running smoothly, but i have a small problem ,i can't connect mysql through "localhost",i can only connect mysql with ip , which is 127.0.0.1 , did i miss out any config ?


Top
   
 Post subject:
PostPosted: Thu Apr 29, 2010 4:50 pm 
Offline
Senior Member
User avatar

Joined: Tue Nov 24, 2009 1:59 pm
Posts: 362
Disabled local socket access (mysqld.sock) in my.cnf, or put the socket in an unusual location, other than rest of the suite and/or PHP binding expects it to reside.

Look for socket= line in /etc/mysql/my.cnf, in ALL the sections (so, [client], [mysqld], [mysqld_safe]).
Also, `ps axu | grep mysqld` and look for --socket parameter on the commandline.

Proper location of the socket for Debian (and derivatives?) is /var/run/mysqld/mysqld.sock, dunno where it is on other distros.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: No registered users and 2 guests


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

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group