Level 75
Do you have multiple database instances. If that's the case, that may be the trouble.
1 like
Apr 8, 2022
5
Level 1
Connection problem with mariadb in laragon
This is my first time i use laragon. After switching to mariadb version 10.6.3 or 10.6.7, i change password to 1234. But everytime i access to database, i get error "Access denied for user 'root'@'localhost' (using password: YES)". When i use mariadb version 10.2.x, everything is normal, i change password to 1234 and connected successfully to the database. Can anyone know what is hanppening and tell me how to fix it. Thank you
Level 1
@jlrdw i dont think that is the problem. Becausei extracted 3 version of mariadb and 1 version of mysql in laragon. But1 maridb version 10.2.x and mysql still works normally when i switching between them. But i will check again. Thank you.
Level 75
@pthai-it-dev follow https://mariadb.com/kb/en/installing-mariadb-windows-zip-packages/
I use the zip packages. Or goto the other sections for MSI installer. Take note of changes. I.e.,
Note : Starting with MariaDB 10.4.3, a pre-built data directory is no longer provided, and users need to run mysql_install_db.exe to create a data directory.
1 like
Level 1
@jlrdw this time i run mysql_install_db.exe after extracting zip file and it does create a data folder. But laragon can not change the root password anymore (error: Column 'plugin' is not updatable). So i need t know the default password of root user in mariadb to access, right?
Level 1
I resolved mine. Please check the my.ini file in Laragon->bin->mysql-> and deletes all the lines that start with "=". These are rubbish. Dont know why they are there.
Please or to participate in this conversation.