The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Local socket communication, path in my.ini

Hello,

I have a question about the path specification insite the my.ini configuration file. Version: MariaDB 5.2.12 for windows.

I want to use a local client<->server connection. So I configure the socket parameter: 'socket = C:/Data/MariaDB 5.2/data/mysql.sock'. But I can't find the file 'mysql.sock' in the configured path. So I tried 'socket = C:\Data\MariaDB 5.2\data\mysql.sock'. But with this configuration I can not find the file too.

What is my mistake? How can I check if MariaDB use the socket communikation?

Best regards, Oliver

Answer Answered by Elena Stepanova in this comment.

http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_socket

"On Unix, this option specifies the Unix socket file to use when listening for local connections. The default value is /tmp/mysql.sock. If this option is given, the server creates the file in the data directory unless an absolute path name is given to specify a different directory. On Windows, the option specifies the pipe name to use when listening for local connections that use a named pipe. The default value is MySQL (not case sensitive). "

You are on Windows, hence no file.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.