How to Install mysql-dev for Server on Ubuntu

22.04aptcMySQL

I am working on a server plugin for MySQL v8.0 (as well as a legacy plugin for v5.7) and I need to install the correct header files. I've looked around the internet and all I can find is libmysqlclient-dev, which is for client dev. I need to install a server development package so I can include headers such as mysql/plugin_auth.h.

Can this be done?

Best Answer

The default repositories in Ubuntu don't include the server development package for MySQL by default, but you can work around this limitation by installing the MySQL source code.

Open the terminal and type:

sudo apt update
sudo apt install build-essential libncurses-dev libssl-dev zlib1g-dev cmake git libboost-all-dev pkg-config bison 
git clone https://github.com/mysql/mysql-server.git

This will download the MySQL source code. You can then navigate to the directory in which you downloaded the MySQL source code, and compile the server which will install the necessary header files in the standard include directories.

In order for CMake to work, the author also had to install libboost-all-dev and pkg-config. Additionally, after cloning the repository, the author had to install bison and run cd <repo>/sql/ then bison sql_yacc.yy -o sql_yacc.cc -Hsql_yacc.hh and bison sql_hints.yy -o sql_hints.yy.cc -Hsql_hints.yy.hh Thanks to Cardinal System for commenting.

MySQL 5.7 reached its end of life in October 2023. This means it will no longer receive official security updates or bug fixes. You can install MySQL 5.7 on Ubuntu 22.04 by following the steps in How to Install MySQL 5.7 on Ubuntu 18.04, 20.04, or later.

You must compile plugins with the entire server source code present, not just the libraries and header files. (source)

Related Solutions

Ubuntu – Installing old MySQL server 4.1 on Ubuntu 11.04

I know this is an older post, but this page is one of the top links I found when searching and many of the links like this one are unanswered. But there is a solution! The YouTube link (http://www.youtube.com/watch?v=2Ar5QszDYEs) shows the manual installation of MySQL 4.1.22 from source files in 6.06... but it still works in 11.05 with minimal alteration. The steps I followed were:

sudo apt-get update && sudo apt-get upgrade
sudo apt-get install build-essential checkinstall libncurses5-dev curl
curl --o mysql-4.1.24.tar.gz http://mirror.provenscaling.com/mysql/community/source/4.1/mysql-4.1.24.tar.gz
sudo tar -xvzf mysql-4.1.24.tar.gz --directory=/usr/local/src
cd /usr/local/src/mysql-4.1.24/
sudo groupadd mysql
sudo useradd -g mysql mysql
sudo apt-get install
sudo ./configure --prefix=/usr/local/mysql
sudo make
sudo mkdir /usr/local/mysql
sudo mkdir /usr/local/mysql/include
sudo mkdir /usr/local/mysql/include/mysql
sudo mkdir /usr/local/mysql/lib
sudo mkdir /usr/local/mysql/lib/mysql
sudo mkdir /usr/local/mysql/share
sudo mkdir /usr/local/mysql/man
sudo mkdir /usr/local/mysql/mysql-test
sudo checkinstall
    y
    mysql-server 4.1.24
dpkg -l | grep -i mysql
sudo cp support-files/my-medium.cnf /etc/my.cnf
cd /usr/local/mysql/
pwd
bin/mysql_install_db --user=mysql
sudo chown -R root .
sudo chown -R mysql var
sudo chgrp -R mysql .
bin/mysql --version
bin/mysql_install_db --user=mysql
sudo bin/mysqld_safe user=mysql &

I hope this helps someone else too!

MySQL – How to Install MySQL Client on Ubuntu 10.04

Try:

sudo apt-get install mysql-client

Or alternatively:

sudo apt-get install mysql\*

Commands like those worked for me when I installed it on my 11.04 system.

Best Answer

Related Solutions

Ubuntu – Installing old MySQL server 4.1 on Ubuntu 11.04

MySQL – How to Install MySQL Client on Ubuntu 10.04

Related Question