mysql.sock

Problems with the Windows version of XAMPP, questions, comments, and anything related.

mysql.sock

Postby dylems » 23. February 2016 11:53

Hi guys,
Is there a way to locate mysql.sock on windows ? the my.ini file tells me it's there :
socket = "D:/xampp/mysql/mysql.sock"

But it's not ! And it doesnt seem to be anywhere else in my system...

Thx for help, it's very urgent !
dylems
 
Posts: 4
Joined: 23. February 2016 11:48
Operating System: Windows

Re: mysql.sock

Postby Nobbie » 23. February 2016 11:56

dylems wrote:But it's not ! And it doesnt seem to be anywhere else in my system...


The socket file is only used, when TCPIP is NOT USED, but Xampp MySQL uses TCPIP Port 3306.
Nobbie
 
Posts: 8770
Joined: 09. March 2008 13:04

Re: mysql.sock

Postby dylems » 23. February 2016 12:01

I need to setup a moodle server in the morning and creating it returns an error :

Error: Database connection failed

It is possible that the database is overloaded or otherwise not running properly.

The site administrator should also check that the database details have been correctly specified in config.php



Warning: mysqli::mysqli(): (HY000/2002): Connection refused in /moodle/lib/dml/mysqli_native_moodle_database.php on line 79

which corresponds to this line : http://puu.sh/ninbz/9a28c7dfe3.png
so I guessed it was a problem with the socket ! What could it be then ?
dylems
 
Posts: 4
Joined: 23. February 2016 11:48
Operating System: Windows

Re: mysql.sock

Postby Nobbie » 23. February 2016 12:04

dylems wrote:so I guessed it was a problem with the socket ! What could it be then ?


No, it is definately not the socket. As i already said, Xampp does not use the socket.

Maybe you applied the wrong credentials (username, password, hostname, database name) or your MySQL Server is not properly started.
Nobbie
 
Posts: 8770
Joined: 09. March 2008 13:04

Re: mysql.sock

Postby dylems » 23. February 2016 12:11

Is there something wrong with that ?

http://puu.sh/ninBw/4b395cbd49.png

The user ln3x got full access to the moodle database, and it's password is admin
dylems
 
Posts: 4
Joined: 23. February 2016 11:48
Operating System: Windows

Re: mysql.sock

Postby Altrea » 23. February 2016 12:16

You should show us the user configuration too.
I guess the user is permitted to login from any host (%).
And that is a problem because there is another anonymous user which has a higher priority.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: mysql.sock

Postby dylems » 23. February 2016 12:23

http://puu.sh/nio6q/b5ce5e2905.png
dylems
 
Posts: 4
Joined: 23. February 2016 11:48
Operating System: Windows


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 70 guests