Is this that the location of your mysql, or it should it not be in /opt/lampp/bin folder?

there is no bin after lampp

only these folder are there htdocs mysql old temp var

There is I'm looking at them now as we chat!

apache2 ctlscript.sh icons lib manager-linux-x64.run php RELEASENOTES uninstall.dat bin docs img libexec manual phpmyadmin sbin var build error include licenses modules proftpd share xampp cgi-bin etc info logs mysql properties.ini temp COPYING.thirdparty htdocs lampp man pear README-wsrep uninstall -- these are the files I have

sorry i dont understand what you said abve

the right command is `/opt/lampp/bin/mysql'

hello

hello

ok but there is no bin after lampp sir

simple do

ls /opt/lampp

are we there?

htdocs mysql old temp var

these are the only folders there

ok

i used this command to install mysql sudo apt install mysql-server

open a terminal

run which mysql

you are mixing lampp mysql with the repo mysqlxingi

ok

now do you see that you have another location for your mysql?

the one in lampp should be in /opt/lampp/bin

ok

and since you don't have it that command should be /usr/bin/mysql

i have to use /usr/bin/mysql

yes

you did not install lampp properly

is there any issues with my current mysql installation

when you launch xamp does it run from the admin panel?

any link to follow to install properly

one moment

apachefriends.org/index.html

try there

its not xamp its lamp i think

linode.com/docs/web-servers/lamp/…

i used this link

one moment

let me look at that link

sure

there is no mention of the command /opt/lampp/mysql in that link!

your mixing up things

your installation is ok if you did as that link directed

just change the command to /usr/bin/mysql

sure thank you so much

ok bye ping if you have any issue just leave a comment in your question