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-devDuring 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 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>intMain () {MYSQL*Conn; Mysql_res*Res;    Mysql_row ROW; CharServer[] ="localhost"; CharUser[] ="Root"; CharPassword[] ="Mima"; CharDatabase[] ="MySQL"; Conn=Mysql_init (NULL); if(!mysql_real_connect (conn, server,user, password, database,0Null0) {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