Could not create database on MariaDB
-
I'm having a trouble on creating a database on MariaDB that laragon started. I've already generated a passphrase via phpmyadmin.
Here's the screenshot of the problem:
[Window Title] Error [Content] Could not create database acctinfo. Reason: C:\laragon\bin\mysql\mariadb-10.1.14-winx64\bin\mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' [OK]
Someone help me on this problem. Thanks
-
You can try Reset and Generate MySQL Password in Menu > MySQL
-
@leokhoa I still got the same error
-
Hmm, I have no idea what you had done with phpmyadmin passphrase. Can you try manually reset it?
https://forum.laragon.org/topic/63/phpmyadmin-password-how-to-reset-mysql-root-s-password/
-
I've already reset my MariaDB root password but I still got the same error
-
This problem triggers when I use the 'create database' from the laragon > MySQL.
-
The problem is when you changed password from phpMyAdmin, Laragon have no information about the password, so it can not create database for you.
If you update the new root password within Laragon's Menu, Laragon will encrypt and will use it when creating databases.
-
@leokhoa The one's getting changed is the MySQL root password not the MariaDB root password.
Creating database using MySQL doesn't give me the error btw, it only happens on MariaDB
-
@Deuterium2H : I've downloaded MariaDB 1.10.16 Win64 and tested creating database OK.
-
@leokhoa Ok, I'll try to use MariaDB 10.1.16 Win64. I'm currently using MariaDB 10.1.14 Win64 for laragon. I'll notify you when the problem got solved, I got a crappy internet atm. Thanks
-
@leokhoa The problem was not resolved by updating my MariaDB version, however it got solved when I reinstalled laragon. Thank you
Btw, what is the password for memcached login? TIA
-
You can see it on the Menu
Menu > Memcached > Web Administration (xxx)