[oe] [meta-oe][PATCH] mariadb: change socket location in my.cnf

[Qi.Chen at windriver.com]

From: Chen Qi <Qi.Chen at windriver.com>

Change socket location to /var/lib/mysql/mysql.sock. Otherwise, we
could spot errors in systemd systems like below.

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

This is because mysqld.service is using PrivateTmp=true.

Signed-off-by: Chen Qi <Qi.Chen at windriver.com>
---
 meta-oe/recipes-support/mysql/mariadb/my.cnf |    4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/meta-oe/recipes-support/mysql/mariadb/my.cnf b/meta-oe/recipes-support/mysql/mariadb/my.cnf
index f2c9b90..c9b785b 100644
--- a/meta-oe/recipes-support/mysql/mariadb/my.cnf
+++ b/meta-oe/recipes-support/mysql/mariadb/my.cnf
@@ -1,7 +1,7 @@
 [client]
 #password					= password
 port						= 3306
-socket						= /tmp/mysql.sock
+socket						= /var/lib/mysql/mysql.sock
 
 [mysqld_safe]
 err-log						= /var/log/mysql.err
@@ -9,7 +9,7 @@ err-log						= /var/log/mysql.err
 [mysqld]
 user 						= mysql
 port 						= 3306
-socket 						= /tmp/mysql.sock
+socket 						= /var/lib/mysql/mysql.sock
 pid-file 					= /var/lib/mysql/mysqld.pid
 log-error 					= /var/log/mysqld.err
 basedir 					= /usr
-- 
1.7.9.5