Django Learning Notes-environment configuration--mysql configuration

One, MySQL installation configuration

1, Fedroa19--Yum installation myusql;

MySQL database (select a matching Ferora version):

MYSQL-COMMUNITY-SERVER-5.6.19-1.FC19.X86_64, the dependent package will be installed automatically;

The Automatically installed content includes:

A, download the MySQL package and its dependent package, and install;

b, create MySQL user and MySQL group;

C, initialize the MySQL DB, establish the basic table;

Finally, you should install the following 5 related packages:

Mysql-community-libs-5.6.19-1.fc19.x86_64
Mysql-community-server-5.6.19-1.fc19.x86_64
Mysql-community-release-fc19-5.noarch
Mysql-community-client-5.6.19-1.fc19.x86_64
Mysql-community-common-5.6.19-1.fc19.x86_64

2. Start MySQL:

service MySQL restart;

3. The MySQL service installed by Yum is not configured by default, the password must be changed after the first connection.

Update user set Password=password ("test") where user= ' root ';

Flush privileges;

4, create the relevant DB---------statement no longer repeat

5. Install Python connector

Python is connected to MySQL, and the other language connector is installed directly, which makes it easy to learn;

mysql-python-1.2.3-7.fc19.x86_64------------------------Django Special Connection library, import MySQLdb

Mysql-connector-java-5.1.28-1.fc19.noarch
Mysql-community-libs-5.6.19-1.fc19.x86_64
Mysql-connector-python-1.2.2-1.fc19.noarch
Mysql-community-server-5.6.19-1.fc19.x86_64
Mysql-community-release-fc19-5.noarch
Mysql-connector-c++-1.1.2-1.fc19.x86_64
Mysql-connector-odbc-5.3.2-1.fc19.x86_64
Mysql-community-client-5.6.19-1.fc19.x86_64
Mysql-community-common-5.6.19-1.fc19.x86_64

Python Validation:

Import MySQLdb----------Django needs to use

Import MySQL----general call