how to access mysql from command line -- Linux

[steveo_88]

Having significant trouble interacting with mysql from the linux terminal. I navigate to /opt/lampp/bin and type in

Code: Select all

mysql -uroot -p

I get this output:

The program 'mysql' can be found in the following packages:
* mysql-client-core-5.1
* mysql-cluster-client-5.1
Try: sudo apt-get install <selected package>

Meanwhile, no problem querying my db through phpMyAdmin.

Any ideas what's going on? after extensive internet searches, I'm still stumped.

[Nobbie]

Any ideas what's going on? after extensive internet searches, I'm still stumped.

Yes, that is very very very basic linux knowledge: the current directory is NOT part of the PATH environment variable. You have to prepend the current directory to the command call:

Code: Select all

./mysql -u root -p

[steveo_88]

ahhh... yes that was it. Much appreciated, problem solved. Completely forgot that I start xampp every morning in exactly that way: /opt/lampp/lampp start, for some reason I thought starting mysql would be different. thanks!

[jayrrilles]

I was able to use the command but after, instead of seeing mysql on the prompt it shows "MariaDB [(none)]".

What does this mean?

[Nobbie]

I was able to use the command but after, instead of seeing mysql on the prompt it shows "MariaDB [(none)]".

What does this mean?

It means what it says - you have a MariaDB installation. Google for MariaDB and you will find proper information about MariaDB. What it is and what it does. If you had looked for the Xampp description you would have seen, that Xampp does not deliver MySQL anymore, but MariaDB instead: from https://www.apachefriends.org/index.html

What is XAMPP?

XAMPP is the most popular PHP development environment

XAMPP is a completely free, easy to install Apache distribution containing MariaDB, PHP, and Perl. The XAMPP open source package has been set up to be incredibly easy to install and to use.