How to test MySQL on Linux Mint 14

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
fahim
Forum Commoner
Posts: 36
Joined: Sun Jan 05, 2014 7:06 pm
Location: Dhaka, Bangladesh

How to test MySQL on Linux Mint 14

Post 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.
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: How to test MySQL on Linux Mint 14

Post 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.
fahim
Forum Commoner
Posts: 36
Joined: Sun Jan 05, 2014 7:06 pm
Location: Dhaka, Bangladesh

Re: How to test MySQL on Linux Mint 14

Post 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. :(
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: How to test MySQL on Linux Mint 14

Post by Celauran »

Have you tried locate?
fahim
Forum Commoner
Posts: 36
Joined: Sun Jan 05, 2014 7:06 pm
Location: Dhaka, Bangladesh

Re: How to test MySQL on Linux Mint 14

Post 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.
fahim
Forum Commoner
Posts: 36
Joined: Sun Jan 05, 2014 7:06 pm
Location: Dhaka, Bangladesh

Re: How to test MySQL on Linux Mint 14

Post by fahim »

Unfortunately, I'm not getting any option to mark this post as solved. :?
Post Reply