mariadb by defaults uses UNIX_SOCKET plugin to authenticate user root. https://mariadb.com/kb/en/mariadb/unix_socket-authentication-plugin/. It works by retrieving uid of the process that has connected to the socket and allowing to connect to the MariaDB account with the corresponding user name. In another word, if you are running your RPi as pi user, when ...
MariaDB is a drop-in replacement for MySQL and should be mostly compatible to it.
Unless you need a very specific feature of MySQL, MariaDB should work just fine.
For more details about the compatibility of MySQL and MariaDB see the following two links:
Looks like you have a character encoding issue. The output \xfc means the character with (hexadecimal) code point 0xFC. That is indeed ü in the Latin-1 character set, but my guess is that it's not being interpreted in that way by Python (or at least it's got mangled somewhere along the way).
My suggestion would be to move everything to UTF-8. If possible, ...
I found a solution although this is not the straightforward way to compile all at once.
First I compiled and installed Qt 5.12.4 without the MySQL driver plugin as described in the tutorial referenced in my original question.
I'm not sure if this next step is really required, but then I created symbolic links to redirect from MySQL to MariaDB in order to ...
By default, the MariaDB server listens for TCP/IP connections on a network socket bound to a single address [...] In Debian [...] the default bind_address is 127.0.0.1, which binds the server to listen on localhost only.
source: Server System Variables - MariaDB Knowledge Base
sudo netstat -ln shows in the column "Local Address" for your raspberry1 "0.0.0....
I resolved my problem by creating a new database dump that only includes the owncloud database:
mysqldump --single-transaction --routines --triggers owncloud
Of course, any additional databases need to be migrated separately.
You need to install the Mariadb packages and the mysql compatibility package in your sysroot.
apt install mariadb-client mariadb-common mysql-common
libmariadb-dev-compat package will create all the links necessary for compatibility between mariadb and mysql.
Then, when you call to qt configure script you must ...
On my build ouput MySQL did work according to my output ( but can't test as i get errors regarding OpenGl when i start my compiled application )
I compiled on on a 4GB Pi4 with the Raspbian Buster Lite .
Does EGLFS work for you ?
I did install these libs maybe this will fix it for you ? :
sudo apt-get install sense-hat libatspi-dev build-essential ...
Remove that mariadb junk with sudo rm /etc/apt/sources.list.d/mariadb.list.
Run sudo apt update then sudo apt install libmariadbclient18 mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server mariadb-server-10.1 mariadb-server-core-10.1
If you need 10.2 you'll have to wait for Raspbian Stretch.
I do not understand what you want to achieve. At least one time you have to configure the default installation with your add ons and settings. So at the next time it boots it is ready as the final unit. It will not forget all your effort so you do not need to do it again or using a script.
If you want to distribute your setup just take an image from your ...