Category : mysql

mysql in docker on windows with python, local LOAD DATA INFILE… query gets the pymysql 1290 error, ‘The MySQL server is running with the –secure-file-priv option so it cannot execute this statement’ mysql> SHOW VARIABLES LIKE ‘secure_file_priv’; in powershell shows ‘NULL’ tried LOAD DATA LOCAL INFILE… as found as possible solution get pymysql error 3948, ..

Read more

I have to build a lambda layer to connect a lambda to MySQL, in the same way that this layer was built for MSSQL. The process to build the MySQL layer is similar to the previous shell script: docker run -it –rm –entrypoint bash -e ODBCINI=/opt/odbc.ini -e ODBCSYSINI=/opt/ lambci/lambda:build-python3.8 curl ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.9.tar.gz -O tar xzvf unixODBC-2.3.9.tar.gz ..

Read more

I have one development server and already installed elasticsearch kibana filebeat docker on docker already running 2 container mariadb database. I already set filebeat for 1 mariadb database. with config on /etc/filebeat/modules.d/mysql.yml like this – module: mysql # Error logs error: enabled: true var.paths: ["/media/dbdev1/data/mysql_error.log"] # Slow logs slowlog: enabled: true var.paths: ["/media/dbdev1/data/mysql_slow.log"] if I ..

Read more