Arch Linux

shadowblue

Member

Registered: 2008-07-16

Posts: 10

after upgrade mysql socket problem

Hi,
i have upgrade my mysql installation to last version (pacman -Syu) and now i can't connect to mysql using phpmyadmin, the error is #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured).

I search with google a solution, i try to change the socket dir from tmp to var/lib but without success.

I try to replace the new config file with the old but with not success.

Someone have a solution?
Is this a bug?
Why not the mysql.sock is on dir mysqld ?

joker806

Member

Registered: 2008-04-11

Posts: 7

Re: after upgrade mysql socket problem

Same problem here Solved by downgrading back to 5.1.39 for now.. Any solution for 5.1.40??

Nezmer

Member

Registered: 2008-10-24

Posts: 559

Website

Re: after upgrade mysql socket problem

http://bugs.archlinux.org/task/17179

---

English is not my native language .

MindTooth

Member

From: Norway

Registered: 2008-11-11

Posts: 331

Re: after upgrade mysql socket problem

Temp fix:
Locate both MySQL and MySQLi socket fields in your php.ini file, and add this; /tmp/mysqld/mysql.sock

Birger

ilpianista

Fellow developer

Registered: 2007-10-06

Posts: 568

Website

Re: after upgrade mysql socket problem

Temp fix:
Locate both MySQL and MySQLi socket fields in your php.ini file, and add this; /tmp/mysqld/mysql.sock

if you have mysql-5.1.40-2 sock path is /var/run/mysqld/mysqld.sock

gnumdk

Member

Registered: 2009-10-15

Posts: 175

Re: after upgrade mysql socket problem

I've got mysql 5.1.40-2 but it doesn't run anymore

chown mysql.mysql /var/run/mysqld fix it.

Last edited by gnumdk (2009-11-18 13:42:51)

gnumdk

Member

Registered: 2009-10-15

Posts: 175

Re: after upgrade mysql socket problem

Kde broken...

File content of '/home/gnumdk/.local/share/akonadi/akonadiserver.error':
Unable to open database "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) QMYSQL: Unable to connect"

Idem for amarok looking for /tmp/mysql.sock

ilpianista

Fellow developer

Registered: 2007-10-06

Posts: 568

Website

Re: after upgrade mysql socket problem

ok ok I am rebuilding all them

gnumdk

Member

Registered: 2009-10-15

Posts: 175

Re: after upgrade mysql socket problem

Thanks

MindTooth

Member

From: Norway

Registered: 2008-11-11

Posts: 331

Re: after upgrade mysql socket problem

http://www.archlinux.org/news/473/

Birger

murfMan

Member

Registered: 2009-10-27

Posts: 161

Re: after upgrade mysql socket problem

how do i fix this? i tried changing the socket dir in php.ini didnt work

i also tried chown mysql.mysql /var/run/mysqld

Last edited by murfMan (2009-11-18 17:14:18)

ilpianista

Fellow developer

Registered: 2007-10-06

Posts: 568

Website

Re: after upgrade mysql socket problem

how do i fix this? i tried changing the socket dir in php.ini didnt work

line 1215, restart httpd

kermana

Member

Registered: 2009-04-13

Posts: 60

Re: after upgrade mysql socket problem

Well, after upgrading I had to reinstall phpmyadmin over the old one and my problem got solved. If I change line 1215 as said in the news actually breaks my installation.  wierd ...

phpmyadmin 3.2.3-1
mysql 5.1.40-2

got it: removed and reinstalled phpmyadmin from scratch... now everything works as expected. Sorry for the forum pollution

Last edited by kermana (2009-11-18 19:58:15)