OCS connect to socket mariadb [closed]

Question

Hi,

I would like to access my local database with socket. No with TCP/IP connection ! It's possible ?

When I use localhost, can't connect but 127.0.0.1 it's Ok.

Thanks

Answer 1

I think it's NOT an OCS problem, but a MySQL/MariaDB problem ... No ?

Answer 2

With command line I can connect to MySQL/MariaDB with socket parameter (-S /path/to/file.sock).

But I don't know configure ocs to use this file.

Answer 3

No. I disagree this way.

Definitively, it's better let OCS connect itself to MariaDB with its own method !

And ask you WHY you need connect to MariadDB using socket ? The question is 'really need' !

After, if you stay with your request, ask you how configure MariaDB to support 2 ways.

Answer 4

I have lot of people who connect to this server and we do to secure all, network and operating system. Connect with mysql.socket is more faster and more secure I think.

Thanks

Answer 5

No.

OCS is designed for access MySQL/MariaDB using network and usually 'localhost'=127.0.0.1. Good chance for change it (OCS) for using socket ! Ask directly creator ...

When you install MySQL/MariaDB, by default, it's bind to 127.0.0.1 and without socket. So security are TOTALLY the same : it's not possible to reach the MySQL server from another computer thru network !

The difference is when you bind MySQL/MariaDB with an real internal ip (192.168.x.x) ...

(I create only dedicated server for OCS ... When you have questions, if you don't give enough informations, why you think readers can understand your requirements ?)

Answer 6

Sorry, lot of think in my head.

THanks for your answer, I forget my idea.
Have a good day