Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Not a Bug
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Environment:linux
Description
I have created a symbolic link " ln -s /demarialab1/pocinst/socket/pocinst.sock /tmp/mysql.sock "
and executed mysql_secure_installation script, which went through successfully and ,i removed mysql.sock as " rm /tmp/mysql.sock "
once i remove it i am not able to check if the instance is up and running.
I am creating primary and DR databases on the same server,so i have to remove symbolic link.
Kindly advice.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
- Find a configuration where you don't have to override the socket, e.g. use non-default socket location in your cnf file;
- use TCP protocol to connect to the database.
can the symbolic link be created under any filesystem other than /tmp ?
it always throws this err when i remove the sym link.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2 "No such file or directory")
>> can the symbolic link be created under any filesystem other than /tmp ?
Please read MySQL manual in regard to 'socket' option.
>> it always throws this err when i remove the sym link.
>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2 "No such file or directory")
Please read MySQL manual in regard to ways to connect to the server
Otherwise, please (again) consider signing up for a support plan and a training course from our partners SkySQL (www.skysql.com)
Thank You, i was able to fix through tcp.