Accesing LAMPP mysql via the command line on linux

mysql linux apache lampp
lychee picture lychee · Mar 7, 2015 · Viewed 9.1k times · Source

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

Answer

Sergio Ellerbracke picture Sergio Ellerbracke · May 28, 2017

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

Related questions

UTF-8 all the way through

I'm setting up a new server and want to support UTF-8 fully in my web application. I have tried this in the past on existing servers and always seem to end up having to fall back to ISO-8859-1. Where …

Read More
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' -- Missing /var/run/mysqld/mysqld.sock

My problem started off with me not being able to log in as root any more on my mysql install. I was attempting to run mysql without passwords turned on... but whenever I ran the command # mysqld_safe --skip-grant-tables & …

Read More
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I am an electrical engineer who mainly plays around with power systems instead of programming. Recently, I have been following a manual to install a software suite on Ubuntu. I have no knowledge of mySQL at all, actually. I have …

Read More