Ubuntu under Mysql installation and Operation graphics and text tutorial _mysql

Installing MySQL on Ubuntu is simple and requires 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 are not forgotten, you can use the following command to check whether the installation is successful after the installation is complete:
sudo netstat-tap | grep mysql
After checking with the above command, if you see a socket with MySQL in listen state, the installation is successful.
Login to the MySQL database can be done by the following command:
Mysql-u Root-p
-U to select the login user name,-p indicates the user password, the above command input will prompt the password, at this time, enter the password can log in to MySQL.

　

then through show databases; You can view the current database.
We choose the MySQL database on the next step, using the use MySQL command, display the current database of the form: show tables

Write a simple program to access the database to implement show tables functionality:

#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;
}

When compiling the code, you need to link the MySQL library, which can be compiled in the following way:

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

Then run the compiled code:

The visible result is the same as using the SQL statement show tables.

Wonderful topic sharing: MySQL different versions of the installation Tutorials mysql5.7 version Installation Tutorials

This is the Ubuntu installation of MySQL and simple operation, I hope to help you learn, but also hope that we continue to pay attention to the cloud-dwelling community more wonderful content.