Raspberry Pi Stack Exchange
Raspberry Pi Stack Exchange

Questions tagged [mariadb]

22 questions
5
votes
1 answer

MySQL initial installation

I know there are many, many threads on this, but hear me out before marking it as a duplicate. On an Raspberry Pi running stretch installed mysql sudo apt-get install mysql-server No errors pi@raspberrypi:~ $ mysql -u root ERROR 1698 (28000):…
Chad G
  • 1,063
  • 1
  • 7
  • 14
2
votes
1 answer

Connection to MySQL database does not work

I have two Raspbery PI 3 which I have installed (almost) identical. The configuration of /etc/mysql/mariadb.conf.d/50-server.cnf is identical for both Raspberrys. Problem: I can only connect to the mysql database of one of these Raspberrys (using…
Michael Hutter
  • 169
  • 2
  • 10
2
votes
1 answer

Importing Data from MFRC522 to MariaDB via. raspberry pi 3

can you please assist me on python scripts that can import DATA FROM AN RFID READER (MFRC522) TO A MariDB DATABASE using a Raspberry Pi 3 B+?
Ak282616
  • 29
  • 1
1
vote
1 answer

Install Raspbian with all settings

Is it possible to install Raspbian with all settings as I want them, with scripts and GUI I have programmed and with MariaDB with all necessary tables? So the next time it boots it is ready as the final unit. Or do I need to write a script that is…
Stefan Bahrawy
  • 11
  • 2
1
vote
1 answer

Python reads 'ä','ü','ö' and 'ß' wrong out of MariaDB

I read a message out of my Database like this: import MySQLdb db = MySQLdb.connect(host="localhost", user="?", passwd="?", db="?") cur = db.cursor() message = cur.execute("SELECT Nr, Nachricht from message") for row in cur.fetchall() : …
Simon Ber
  • 9
  • 2
1
vote
1 answer

Cannot connect to MariaDB on Raspberry Pi from Windows PC on same local network

I am trying to connect to a MariaDB database on a Raspberry Pi 5 running Raspbian using DBeaver CE running on a Windows 11 PC on the same local area network. I am getting the following error message in DBeaver CE: Socket fail to connect to host…
Joel Brown
  • 129
  • 5
1
vote
2 answers

Updating Connector/Python for Python 3.11

Having moved to Python 3.11, I need to update Connector/Python - which requires the MariaDB Connector/C library. This library is normally installed with python -m pip install mariadb But I'm getting an error: MariaDB Connector/Python requires…
tyddynonn
  • 19
  • 3
1
vote
0 answers

Install latest MariaDB properly via apt

Currently I'm running this helper function in my synced shell environments on all my Linux/macOS devices; install_mariadb() { local mariadb_version_test local mariadb_version local repo_arch local distro …
Fëanorson
  • 11
  • 1
1
vote
1 answer

Raspberry PI 3 mariaDB and python issue with expanding columns

I am having an issue that I don't really have programming experience to resolve. I have an application that deploys an SQL table that may have more or less columns depending on user input. I am currently struggling with the insert command being more…
Kevin Lay
  • 21
  • 2
1
vote
1 answer

Build MariaDB 10.5 on Raspberry Pi 3B Unable to find a source package for mariadb-server

I am wanting to build MariaDB 10.5.5 on my Raspberry Pi 3B (Kernel version 5.4.65-v7+) since it has some nice features I want to play with. The first step involves setting up the build environment described here: Build Environment Setup for…
A Dark Divided Gem
  • 125
  • 5
1
vote
1 answer

Problem with mariaDB, HSF+ and Raspbian on a Raspberry Pi 4

I'm making a full LAMP using a Raspberry PI 4 w/ 4GB RAM, Apachie2, MariaDB 10.3.22 and PHP and a 4 Teribite HSF+ USB drive. Initial setup worked fine till I attempted to change to data store of mariaDB to the HSF+ data directory. Yes, I installed…
Gary Scott
  • 11
  • 1
1
vote
1 answer

Migrating MariaDB from Stretch to Buster

I am currently in the process of migrating my ownCloud from my old Pi 3B to a Pi 4B. On the 3, I made a backup of my MariaDB with mysqldump: mysqldump --single-transaction --routines --triggers --all-databases | gzip > backup_db.sql.gz Here is the…
Clashsoft
  • 121
  • 5
1
vote
1 answer

Use actual MySQL on Raspbian Stretch instead of MariaDB

I have a web based project which I wrote with NodeJS. I moved the project to my Raspberry Pi which runs on Raspbian Stretch. The project has a lot of lines of code which deal with MySQL connections. However, when I installed MySQL on Stretch, I got…
RishiC
  • 153
  • 1
  • 7
1
vote
3 answers

How do I build Qt's mysql-plugin on Raspbian Buster

I try to build the MySQL plugin on a Raspbian Buster with C++ and Qt 5.12.4. Building Qt itself worked fine by following this tutorial: https://www.tal.org/tutorials/building-qt-512-raspberry-pi However, if I add the option -sql-mysql to the…
elnacho
  • 43
  • 1
  • 6
0
votes
1 answer

can't install mariadb 10.1 on raspbian stretch

after several attempts to install mariadb on Raspbian stretch i am still stuck on the same error: Setting up mariadb-server-10.1 (10.1.23-9+deb9u1) ... Job for mariadb.service failed because the control process exited with error code. See "systemctl…
Nicolas
  • 3
  • 2
1
2