Using Linux. I'm trying to learn PHP so I'm also going to need to learn some MySQL to work with my PHP code. Do I need mysql client or mysql server? I thought it was on my system but after issuing the command 'mysql' I got the following error.

garrett@bedroom ~ $ mysql
The program 'mysql' is currently not installed. You can install it by typing:
sudo apt-get install mysql-client-core-5.5
4 Years
Discussion Span
Last Post by Trap910

hi, you have to install both server and client (sudo apt-get install mysql-server mysql-client). You can also install client separately (sudo apt-get install mysql-client).

If you have already done some attemps to install mysql on ubuntu, it is very important that you remove directory /var/lib/mysql explicitly after each removing of mysql itself (sudo apt-get remove --purge mysql-server mysql-client) and before new installation (sudo apt-get install mysql-server mysql-client).

I hope that will help.

Edited by 1stDAN


Its better to install the whole LAMP(Linux, Apache, Mysql,Perl PHP) combination..The steps are very simple, just google the steps to install there are some set of sudo command to install mysql and apache

then try mysql -u<username> -p password

you should get mysql> prompt, if you want to make mysql more easy, install phpmyadmin which gives the user interface to create and manage the database...This will make the task more easy to understand

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.