MySQL: which one needed?

**Autodave** · June 8th, 2013

Installing a program for our church's library. Program calls for MySQL to be installed. This will all be on one machine and one machine only. Question: do I need to Install MySQL server or client, or both?

**Cheesemill** · June 8th, 2013

It will be MySQL server that's needed, but installing this installs the client as well.

Code:

sudo apt-get install mysql-server

**Autodave** · June 8th, 2013

I installed server through the software center: I assumke that client was also installed then?

**SeijiSensei** · June 8th, 2013

If you can type "mysql" at the command prompt and not get an error in response, then the client is installed. Note that if you intend to talk the to MySQL database with PHP, you need make sure the php5-mysql package is installed as well.

**rewyllys** · June 9th, 2013

Originally Posted by Autodave

Installing a program for our church's library. Program calls for MySQL to be installed. This will all be on one machine and one machine only. Question: do I need to Install MySQL server or client, or both?

I hope I'm not being too curious in asking, what is the program that you're installing for your church's library?

**Autodave** · June 9th, 2013

Originally Posted by rewyllys

I hope I'm not being too curious in asking, what is the program that you're installing for your church's library?

Right now, I am looking at KOHA. This is a small library: maybe 300 books. I have been looking around and that was one I thought might work. If anyone has a better idea, let me hear it.

Also, I need to install Sorl. Is there a command line for that or do I need to d-l that .tar file and do it that way?

**Cheesemill** · June 9th, 2013

I think you mean Solr...

Code:

sudo apt-get install solr-common

You can search for packages available in the repositories using the Ubuntu package database....
http://packages.ubuntu.com/

**rewyllys** · June 9th, 2013

Originally Posted by Autodave

Right now, I am looking at KOHA. This is a small library: maybe 300 books. I have been looking around and that was one I thought might work. If anyone has a better idea, let me hear it.

Also, I need to install Sorl. Is there a command line for that or do I need to d-l that .tar file and do it that way?

Thanks for the information. KOHA looks interesting.

BTW, have you looked for possible answers to your MySQL question on the Koha Community Website?