Page 1 of 1

How to test MySQL on Linux Mint 14

Posted: Wed Jan 22, 2014 9:32 am
by fahim
Hi everybody,

I've installed XAMPP on Linux Mint 14 successfully. PHP works perfectly, but I need to test MySQL. How can I do that? I've found a lot of tutorials to test MySQL, but to do that first I need to access the MySQL shell using the following command:
[text]mysql -u root -p[/text]

Problem is that, when I'm issuing that command from Terminal, it's showing the following message:

[text]The program 'mysql' is currently not installed. You can install it by typing:
sudo apt-get install mysql-client-core-5.5
[/text]

How can I overcome this problem and test MySQL on Linux Mint?

Please help experts.

Thanks in advance.

Re: How to test MySQL on Linux Mint 14

Posted: Wed Jan 22, 2014 10:17 am
by Celauran
There's really no need for XAMPP on Linux. Just install Apache, PHP, and MySQL directly from your distro's repos. That said, the MySQL binaries probably aren't in your path. Check where XAMPP is installed and either add that directory to your path or symlink the binaries into your path.

Re: How to test MySQL on Linux Mint 14

Posted: Wed Jan 22, 2014 11:51 pm
by fahim
Thanks for your reply.

Actually, you are right about installing directly from the repos, but I've installed XAMPP already and now I don't want to install PHP,MySQL,Apache separately from repos. I want to connect with the MySQL which is already installed.

I've tried the following locations:

[text]/opt/lampp/
/opt/lampp/bin
/opt/lampp/var/mysql/[/text]

but unfortunately getting same result again and again. :(

Re: How to test MySQL on Linux Mint 14

Posted: Thu Jan 23, 2014 6:23 am
by Celauran
Have you tried locate?

Re: How to test MySQL on Linux Mint 14

Posted: Thu Jan 23, 2014 10:01 pm
by fahim
Thanks for you advice. I've found my desired location, which is:

[text]/opt/lampp/bin/mysql[/text]

Works for me perfectly. Marking this post as solved.

Re: How to test MySQL on Linux Mint 14

Posted: Fri Jan 24, 2014 8:27 am
by fahim
Unfortunately, I'm not getting any option to mark this post as solved. :?