Curso de Programación en Python/MySQL-1

• MySQL-1.py

MySQL-1.py

urpmi mysql-connector-python

Antes de iniciar, debemos crear el base de datos

[rrc@Pridd PythonClase]$ mysql -p
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 13
Server version: 10.0.22-MariaDB Mageia MariaDB Server

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)

MariaDB [(none)]> create database PythonClase;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| PythonClase        |
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)

MariaDB [(none)]> show create database PythonClase;
+-------------+----------------------------------------------------------------------------------------------+
| Database    | Create Database                                                                              |
+-------------+----------------------------------------------------------------------------------------------+
| PythonClase | CREATE DATABASE `PythonClase` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */ |
+-------------+----------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

MariaDB [(none)]> grant all on PythonClase.* to 'PythonClase'@'localhost' identified by 'Py800se';
Query OK, 0 rows affected (0.00 sec)

 1 #!/usr/bin/python
 2 #-*-coding: utf-8 -*-
 3 
 4 import mysql.connector
 5 from mysql.connector import errorcode
 6 
 7 try:
 8   Conn = mysql.connector.connect( user='PythonClase',
 9                                   password='Py800se',
10                                   host='127.0.0.1',
11                                   unix_socket='/var/lib/mysql/mysql.sock',
12                                   database='PythonClase')
13 except mysql.connector.Error as err:
14   if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
15     print( "UsuarioNombre o Contraseña incorrecto" )
16   elif err.errno == errorcode.ER_BAD_DB_ERROR:
17     print( "Base de Datos no existe" )
18   else:
19     print( err )
20 else:
21   Conn.close()
22 
23 pip3 install mysql-connector-python --allow-external mysql-connector-python  ----  NO SIRVE MÁS ----
24 
25 Descarga URL: http://cdn.mysql.com/Downloads/Connector-Python/mysql-connector-python-2.0.4.zip#md5=3df394d89300db95163f17c843ef49df 
26 
27 unzip
28 
29 python3 setup.py install