Hi,
I´m currently setting up a fresh FreeBSD 14.3 server with MariaDB 11.8. This morning I stumbled about some odd behavior: I was in the root shell for configuration and wanted to edit a database so I ran „mysql -p“. What I wasn´t aware of was that had opened the wrong entry in my password manager but mariadb let me in with wrong password! I noticed that later when I was looking for a database user but couldn´t find him in the pw manager. After some testing I found that
- when you su to root mariadb accept any input for „mysql -p“ even if you only press enter
- for any other database user you need to give the correct password
- when you run in a normal system account „mysql -u root -p“ you must give the correct password
So - is this a bug or a feature I`m not aware of?
Best regards,
Mike
I´m currently setting up a fresh FreeBSD 14.3 server with MariaDB 11.8. This morning I stumbled about some odd behavior: I was in the root shell for configuration and wanted to edit a database so I ran „mysql -p“. What I wasn´t aware of was that had opened the wrong entry in my password manager but mariadb let me in with wrong password! I noticed that later when I was looking for a database user but couldn´t find him in the pw manager. After some testing I found that
- when you su to root mariadb accept any input for „mysql -p“ even if you only press enter
- for any other database user you need to give the correct password
- when you run in a normal system account „mysql -u root -p“ you must give the correct password
So - is this a bug or a feature I`m not aware of?
Best regards,
Mike