Consider that you have installed your lampp under /opt director
So you lampp folder seems to be like /opt/lampp/, by default the path of the mysql is /opt/lampp/var/mysql/
when you type the mysql connector will search for the socket, to specify the socket use the bellow command
mysql -u root --socket=/opt/lampp/var/mysql/mysql.sock
To import or restore a mysql database in lampp or to lampp directory use the below command
mysql -u root --socket=/opt/lampp/var/mysql/mysql.sock your DBNAME < DBFILE.SQL
Mysql will use the socket /opt/lampp/var/mysql/mysql.sock and will store the database user the lampp directory or folder.
|
