Install MySQL and simple operation under Ubuntu

Installing MySQL on Ubuntu is very simple and requires just a few commands to complete.

1. sudo apt-get install Mysql-server

2. Apt-get Isntall mysql-client

3. sudo apt-get install Libmysqlclient-dev

During installation, you will be prompted to set a password or something, note that the settings do not forget that after the installation is complete, you can use the following command to check if the installation is successful:

sudo netstat-tap | grep MySQL

After checking with the above command, if you see a socket with MySQL in the Listen state, the installation is successful.

Log in to MySQL database by the following command:

Mysql-u root-p

-U means to select the login user name,-p indicates the login user password, the above command input will prompt for a password, then enter the password can log in to MySQL.

then through show databases; You can view the current database.

We choose the MySQL database to do the next step, using the use MySQL command, display the current database form: Show tables

Write a simple program to access the database and implement the show Tables feature:

#include <mysql/mysql.h>
#include <stdio.h>
#include <stdlib.h>
int main ()
{
MYSQL *conn;
Mysql_res *res;
Mysql_row ROW;
Char server[] = "localhost";
Char user[] = "root";
Char password[] = "Mima";
Char database[] = "MySQL";

conn = Mysql_init (NULL);

if (!mysql_real_connect (conn, server,user, password, database, 0, NULL, 0))
{
fprintf (stderr, "%s\n", MYSQL_ERROR (conn));
Exit (1);
}

if (mysql_query (conn, "Show Tables"))
{
fprintf (stderr, "%s\n", MYSQL_ERROR (conn));
Exit (1);
}

res = MYSQL_USE_RESULT (conn);

printf ("MySQL Tables in MySQL database:\n");

while (row = mysql_fetch_row (res)) = NULL)
{
printf ("%s \ n", row[0]);
}

Mysql_free_result (RES);
Mysql_close (conn);

printf ("finish! \ n ");
return 0;
}

Compiling the code requires a link to the MySQL library, which can be compiled in the following ways:

g++-wall Mysql_test.cpp-o mysql_test-lmsqlclient

Then run the compiled code:

The visible results are the same as show tables with the SQL statement.

Make it and make it happen

Install MySQL and simple operation under Ubuntu