PhpWebStudy
PhpWebStudy copied to clipboard
Can't connect without password & run MariaDB.
FlyEnv Version: 4.9.2 MariaDB: 11.8.1
At first, it was working. I tried to update the configuration because I received this warning: (conn=7) Access denied for user 'root'@'localhost' (using password: NO). I haven’t set or updated the password, but the warning appeared. I'm trying to connect to MariaDB using DBeaver. I've never encountered this warning before, even though I’ve installed MariaDB locally many times. How can I fix this?
So far, I’ve added the following line, although I’m not sure if it’s necessary:
[mariadbd]
skip-grant-tables
Later, I clicked Load Default File to reset the configuration file, and then this error showed up.
Try username and password both "root".
Then to set a new one:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
https://flyenv.com/guide/database-user-password.html
The default configuration of FlyEnv sets the username and password as root/root when initializing the data directory. If you modify the configuration file and use your own data directory, you will need to reset the password manually.
Thanks, root/root works great!
Any idea about the error though? Not sure why it keeps showing up even after I reinstalled FlyEnv.