Ubuntu installs MySQL and simple operation

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 the installation process will be prompted to set the password or something, note the settings do not forget that after the installation is complete, you can use the following command to check whether the installation is successful: sudo netstat-tap | grep mysqlAfter 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. And then through Show Databases;　　You can view the current database. We choose the MySQL database on the next steps, using Use MySQLcommand to display the form for the current database: Show TablesWrite 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.

Ubuntu installs MySQL and simple operation