Curso de Programación en Python/MySQL-1

De WikiCabal
Saltar a: navegación, buscar

MySQL-1.py

urpmi mysql-connector-python

Argument Name Default Description
user The user name used to authenticate with the MySQL server.
password The password to authenticate the user with the MySQL server.
database The database name to use when connecting with the MySQL server.
host 127.0.0.1 The host name or IP address of the MySQL server.
port 3306 The TCP/IP port of the MySQL server. Must be an integer.
unix_socket The location of the Unix socket file.
auth_plugin Authentication plugin to use. Added in 1.2.1.
use_unicode True Whether to use Unicode.
charset utf8 Which MySQL character set to use.
collation utf8_general_ci Which MySQL collation to use.
autocommit False Whether to autocommit transactions.
time_zone Set the time_zone session variable at connection time.
sql_mode Set the sql_mode session variable at connection time.
get_warnings False Whether to fetch warnings.
raise_on_warnings False Whether to raise an exception on warnings.
connection_timeout Timeout for the TCP and Unix socket connections.
client_flags MySQL client flags.
buffered False Whether cursor objects fetch the results immediately after executing queries.
raw False Whether MySQL results are returned as is, rather than converted to Python types.
ssl_ca File containing the SSL certificate authority.
ssl_cert File containing the SSL certificate file.
ssl_key File containing the SSL key.
ssl_verify_cert False When set to True, checks the server certificate against the certificate file specified by the ssl_ca option. Any mismatch causes a ValueError exception.
force_ipv6 False When set to True, uses IPv6 when an address resolves to both IPv4 and IPv6. By default, IPv4 is used in such cases.
dsn Not supported (raises NotSupportedError when used).
pool_name Connection pool name. Added in 1.1.1.
pool_size 5 Connection pool size. Added in 1.1.1.
pool_reset_session True Whether to reset session variables when connection is returned to pool. Added in 1.1.5.
compress False Whether to use compressed client/server protocol. Added in 1.1.2.
converter_class Converter class to use. Added in 1.1.2.
fabric MySQL Fabric connection arguments. Added in 1.2.0.
failover Server failover sequence. Added in 1.2.1.
option_files Which option files to read. Added in 2.0.0.
option_groups ['client', 'connector_python'] Which groups to read from option files. Added in 2.0.0.
allow_local_infile True Whether to enable LOAD DATA LOCAL INFILE. Added in 2.0.0.
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)

#!/usr/bin/python
#-*-coding: utf-8 -*-

import mysql.connector
from mysql.connector import errorcode

try:
  Conn = mysql.connector.connect( user='PythonClase',
                                  password='Py800se',
                                  host='127.0.0.1',
                                  unix_socket='/var/lib/mysql/mysql.sock',
                                  database='PythonClase')
except mysql.connector.Error as err:
  if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
    print( "UsuarioNombre o Contraseña incorrecto" )
  elif err.errno == errorcode.ER_BAD_DB_ERROR:
    print( "Base de Datos no existe" )
  else:
    print( err )
else:
  Conn.close()

pip3 install mysql-connector-python --allow-external mysql-connector-python  ----  NO SIRVE MÁS ----

Descarga URL: http://cdn.mysql.com/Downloads/Connector-Python/mysql-connector-python-2.0.4.zip#md5=3df394d89300db95163f17c843ef49df 

unzip

python3 setup.py install