Can't connect to local MySQL server through socket (4279627)

NOTE: On UNIX systems, you may get an error in regards to the .sock file as shown below when trying to connect to MySQL via command line

ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)

Solution

- Go to Quest_Software/Foglight/config directory
- Either vi or grep the server.config

# grep sock config/server.config

Look for:
foglight.database.embedded.socket = "/tmp/fms-511-16382.sock";
Copy the socket = "/tmp/fms-511-16382.sock"

# mysql/bin/mysql -u foglight -p -P 13306 --socket /tmp/fms-511-16382.sock (no quotes)

Reading table information for completion of table and column names. (This can be turnef off to get a quicker startup with -A

Commands end with ; or \g

Type 'help;' or '\h' for help. Type '\c' to clear the current imput statement

- Once you login, test it to make sure you successfully login

USE foglight

SELECT * FROM sec_user WHERE username = 'foglight';

The default user name and password is foglight /foglight but this can be checked in the server.config file.

mysql -u root -p foglight -P13306 can be also used.