MySQL installation and testing under Ubuntu

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

1. Installation of the server:sudo apt-get install mysql-server 2. Installation of the clientApt-get Isntall mysql-client
 3. Installation of the development packagesudo apt-get install Libmysqlclient-devto fill in the password during installation: Assume that you set the password for MySQL: abc123 after installation, you can check the installation of MySQL by the following command: sudo netstat-tap | grep mysqlafter entering the command, the output server is in the listening state listen, indicating that you have successfully installed MySQLUse the following command to open MySQL: mysql-u root-pParameter information:-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 use Command Show Databases; You can view the current database. Use Use MySQL; Select the current database MySQL. Of course, you can also choose a different database for the current active database;Use show tables; display the form for the current database: Write 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 -lmysqlclient

Then run the compiled code:

./mysql_test

Done.

MySQL installation and testing under Ubuntu