Build a MySQL database environment using C language in Ubuntu

1. sudo apt-Get install mysql-server mysql-Client
Use sudo netstat
-Tap | grep MYSQL: Check whether the service is enabled:
TCP 0 0 localhost. localdomain: MySQL
*: * Listen-

For example
If the service is not running, you can use
Sudo/etc/init. d/MySQL restart
Enable.

2. Install the GUI tool
Sudo apt-Get install mysql-query-Browser
Sudo apt-Get
Install mysql-Admin
After installation, run the command in the/usr/bin directory.
You can simply double-click to run it. If you are idle, You can compile a shell.
MySQL. Sh
Internal
Rong:
#/Usr/bin/MySQL-Admin
/Usr/bin/MySQL-query-Browser
Grant executable permissions
Chmod
U + x mysql. Sh
Put this shell on the desktop and it will be convenient.

3. MySQL directory

Database Directory:/var/lib/MySQL/(you can modify ETC/MySQL/My. CNF to change the directory where data is stored)
Configuration File:/usr
/Share/MySQL
Related commands:/usr/bin (mysqladmin mysqlbrowser mysqldump and other commands)

4. Configure the c api Environment
As I said before, this is the only thing that can be found after two points.

Sudo apt-Get install libmysqlclient15-dev

After installation, the header file mysql. H will be found in the/usr/include/MySQL/directory.
It will be found in/usr/lib/MySQL/
Some dynamic or static MySQL library files