How to connect python to mysql database in ubuntu

This article mainly introduces how to connect python to mysql database in ubuntu, which is very good and has reference value. if you need python, refer to enter the root permission.

apt-get install mysql-serverapt-get install mysql-client

Create a database

Mysql-u root-p passward link database create database basenameuse basename

If the database needs to be modified, you can directly use

mysql -u root -p passward basename

Create a table

create table latest_face( id int(11) not null auto_increment, camera_id varchar(240) not null, picture mediumblob not null, datetime datetime not null, people_id int(11) not null, people_name varchar(16),accessed int(4) not null,primary key(id) )charset = gb2312;

Use python to connect to a database.

When apt-get install mysql-python is used, no mysql-python package is found. However, it is very troublesome to directly download and install python, so pip install mysql-python is used.

When pip is used to install mysql-python, the prompt EnvironmentError: mysql_config not found is displayed. In this case, reinstall libmysqlclient-dev, pt-get install libmysqlclient-dev, and pip install mysql-python. the installation is successful.

Input import MySQLdb in python to test whether it can be used

The above section describes how to connect python to mysql database in ubuntu. I hope it will be helpful to you. if you have any questions, please leave a message, the editor will reply to you in a timely manner. I would like to thank you for your support for PHP chinnet!

For more articles about how to connect python to the mysql database in ubuntu, refer to the PHP Chinese network!