# If you encounter the "Please explicitly state intended protocol" error, # use the login_unix_socket argument - name : Create a new database with name 'bobdata' _db : name : bobdata state : present login_unix_socket : /run/mysqld/mysqld.sock - name : Create new databases with names 'foo' and 'bar' _db : name : - foo - bar state : present # Copy database dump file to remote host and restore it to database 'my_db' - name : Copy database dump file copy : src : 2 dest : /tmp - name : Restore database _db : name : my_db state : import target : /tmp/2 - name : Restore database ignoring errors _db : name : my_db state : import target : /tmp/2 force : yes - name : Dump multiple databases _db : state : dump name : db_1,db_2 target : /tmp/dump.sql - name : Dump multiple databases _db : state : dump name : - db_1 - db_2 target : /tmp/dump.sql - name : Dump all databases to hostname.sql _db : state : dump name : all target : /tmp/dump.sql - name : Dump all databases to hostname.sql including master data _db : state : dump name : all target : /tmp/dump.sql master_data : 1 # Import of sql script with encoding option - name : > Import dump.sql with specific latin1 encoding, similar to mysql -u -default-character-set=latin1 -p Dump of Databse with specific latin1 encoding, similar to mysqldump -u -default-character-set=latin1 -p _db : state : dump name : db_1 encoding : latin1 target : /tmp/dump.sql - name : Delete database with name 'bobdata' _db : name : bobdata state : absent - name : Make sure there is neither a database with name 'foo', nor one with name 'bar' _db : name : - foo - bar state : absent # Dump database with argument not directly supported by this module # using dump_extra_args parameter - name : Dump databases without including triggers _db : state : dump name : foo target : /tmp/dump.sql dump_extra_args : -skip-triggers - name : Try to create database as root/nopassword first. If credentials from the config file (for example, /root/.my.cnf) are not needed to connect to a database server, but the file exists and does not contain a section, before any other valid directives, it will be read and this will cause the connection to fail, to prevent this set it to an empty string, (for example config_file: ''). As an example, the default MariaDB installation of version 10.4 and later uses the unix_socket authentication plugin by default that without using login_unix_socket=/var/run/mysqld/mysqld.sock (the default path) causes the error Host '127.0.0.1' is not allowed to connect to this MariaDB server.Īlternatively, you can use the mysqlclient library instead of MySQL-python (MySQLdb) which supports both Python 2.X and Python >=3.5. If there are problems with local connections, using login_unix_socket=/path/to/mysqld/socket instead of login_host=localhost might help. If none are present, the module will attempt to read the credentials from ~/.my.cnf, and finally fall back to using the MySQL default login of ‘root’ with no password. īoth login_password and login_user are required when you are passing credentials. If you have trouble, it may help to force Ansible to use the Python interpreter you need by specifying ansible_python_interpreter.
#MYSQL DELETE INSTALL#
If ansible discovers and uses Python 2, you need to install the Python 2 version of either PyMySQL or MySQL-python. For example if ansible discovers and uses Python 3, you need to install the Python 3 version of PyMySQL or mysqlclient. You can also use dnf install python2-PyMySQL for newer versions of Fedora see .īe sure you have mysqlclient, PyMySQL, or MySQLdb library installed on the target machine for the Python interpreter Ansible discovers. The Python package may be installed with apt-get install python-pymysql (Ubuntu see ) or yum install python2-PyMySQL (RHEL/CentOS/Fedora see ). Requires the PyMySQL (Python 2.7 and Python 3.X) or MySQL-python (Python 2.X) package installed on the remote host. To avoid the Please explicitly state intended protocol error, use the login_unix_socket argument, for example, login_unix_socket: /run/mysqld/mysqld.sock.
This module is not idempotent when state is import, and will import the dump file each time if run more than once. Requires the mysql and mysqldump binaries on the remote host. Controlling how Ansible behaves: precedence rules.
Collections in the Theforeman Namespace.Collections in the T_systems_mms Namespace.Collections in the Servicenow Namespace.Collections in the Purestorage Namespace.Collections in the Openvswitch Namespace.Collections in the Netapp_eseries Namespace.Collections in the Kubernetes Namespace.Collections in the Junipernetworks Namespace.Collections in the F5networks Namespace.Collections in the Containers Namespace.Collections in the Cloudscale_ch Namespace.Collections in the Chocolatey Namespace.
Collections in the Check_point Namespace.Virtualization and Containerization Guides.
0 kommentar(er)
