Trouble installing MySQL
Posted: Fri Nov 02, 2012 9:53 pm
by yttriuszzerbus
I'm setting up a LAMP server on a Pi for PHP development, and I'm trying to get MySQL installed. PHP works fine, but today I downloaded phpMyAdmin and it complained about the MySQLi extension being missing. I purged all packages relating to MySQL that I could find in Aptitude, then reinstalled "mysql-common", "libmysqlclient18:armhf" and "php5-mysql" (these are the only packages which show up with dpkg --list | grep mysql. My problem now is, that although phpMyAdmin seems satisfied that the MySQLi extension is present, I'm not sure if the mysql binary is. Running the command mysql to use the command line interface gives the error -bash: mysql: command not found and a search for whereis mysql gives only /etc/mysql which contains a config file but no binary.
How can I get MySQL working?
Thanks,
yttriuszzerbus
Re: Trouble installing MySQL
Posted: Sat Nov 03, 2012 1:48 am
by bgirardot
I just ran this command:
sudo apt-get --simulate install mysql-server
and it indicates it will install just about everything you need.
I went a head and removed the --simulate option and it did in fact install a seemingly perfectly working mysql server 5.5 and mysql client on my RPi.
If you put the word "LAMPA" in the search box on these forums, you will see someone made a nice script to get a lamp stack installed. You can run the script if you want, but I suggest you download it and look at what commands the author used to install his LAMP stack.
Re: Trouble installing MySQL
Posted: Sat Nov 03, 2012 6:10 pm
by yttriuszzerbus
bgirardot wrote:I just ran this command:
sudo apt-get --simulate install mysql-server
and it indicates it will install just about everything you need.
I went a head and removed the --simulate option and it did in fact install a seemingly perfectly working mysql server 5.5 and mysql client on my RPi.
If you put the word "LAMPA" in the search box on these forums, you will see someone made a nice script to get a lamp stack installed. You can run the script if you want, but I suggest you download it and look at what commands the author used to install his LAMP stack.
Thanks for your help, turned out I didn't have mysql-server installed at all.