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:

1#include <mysql/mysql.h>2#include <stdio.h>3#include <stdlib.h>4 intMain ()5 {6MYSQL *Conn;7Mysql_res *Res;8 Mysql_row ROW;9     CharServer[] ="localhost";Ten     CharUser[] ="Root"; One     CharPassword[] ="Mima"; A     CharDatabase[] ="MySQL"; -      -conn =Mysql_init (NULL); the      -     if(!mysql_real_connect (conn, server,user, password, database,0Null0))  -     { -fprintf (stderr,"%s\n", MYSQL_ERROR (conn)); +Exit1); -     } +      A     if(Mysql_query (Conn,"Show Tables"))  at     { -fprintf (stderr,"%s\n", MYSQL_ERROR (conn)); -Exit1); -     } -      -res =Mysql_use_result (conn); in      -printf"MySQL Tables in MySQL database:\n"); to      +      while(row = mysql_fetch_row (res))! =NULL) -     { theprintf"%s \ n", row[0]); *     } $     Panax Notoginseng Mysql_free_result (res); - Mysql_close (conn); the      +printf"finish! \ n"); A     return 0; the}

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 actions