Accesing LAMPP mysql via the command line on linux

Question

I've have installed LAMPP, I need to access MySQL from the terminal but I dont know how, because if I simply type mysql into the prompt it says the mysql program is not installed, but it has to be installed because it stands for Linux + Apache + MySQL + PHP + Perl. Thank

score 6 · Answer 1 · edited May 28 '17 at 21:01

6

My solution:

sudo /opt/lampp/lampp status

sudo /opt/lampp/lampp startmysql

sudo /opt/lampp/lampp status

cd /opt/lampp/bin

./mysql -h localhost test

edited May 28 '17 at 21:01

Derrick

3,669
5
35
50

answered May 28 '17 at 19:22

Sergio Ellerbracke

61
1
2

score 2 · Accepted Answer · answered Mar 07 '15 at 19:29

2

On my system this solved my problem

sudo /opt/lampp/lampp startmysql
/opt/lampp/bin/mysql -u username

answered Mar 07 '15 at 19:29

lychee

1,771
3
21
31

score 1 · Answer 3 · answered Nov 29 '18 at 06:17

1

For Bitnami LAMP stack

/opt/lampstack-7.1.23-0/mysql/bin/mysql -u root -p

answered Nov 29 '18 at 06:17

vijay

731
5
15

score 0 · Answer 4 · answered Mar 07 '15 at 18:28

0

A good start would be to run which mysql to locate the binary and check if it is actually installed. If it is missing try re-installing.

answered Mar 07 '15 at 18:28

Kostas Drk

335
2
7

Accesing LAMPP mysql via the command line on linux

4 Answers4