PhpWebStudy icon indicating copy to clipboard operation
PhpWebStudy copied to clipboard

Can't connect without password & run MariaDB.

Open TuruSakthi opened this issue 7 months ago • 3 comments

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. Image

TuruSakthi avatar Apr 09 '25 17:04 TuruSakthi

Try username and password both "root".

Then to set a new one: ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

timint avatar Apr 14 '25 00:04 timint

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.

xpf0000 avatar Apr 17 '25 15:04 xpf0000

Thanks, root/root works great!

Any idea about the error though? Not sure why it keeps showing up even after I reinstalled FlyEnv.

TuruSakthi avatar Apr 23 '25 10:04 TuruSakthi