How to connect python to the mysql database in ubuntu, ubuntupython

How to connect python to the mysql database in ubuntu, ubuntupython

Go to root

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 usingapt-get install mysql-python The system prompts that no mysql-python software package is found. However, it is very troublesome to download and install the SDK directly.pip install mysql-python


When pip is used to install mysql-python, the prompt EnvironmentError: mysql_config not found is displayed. Reinstalllibmysqlclient-dev，pt-get install libmysqlclient-dev, And thenpip 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. Thank you very much for your support for the help House website!