Unable to connect to the database.

I wonder what is the problem since all the credentials I put is correct

CRITICAL - 2023-11-28 16:20:33 --> Unable to connect to the database.
Main connection [MySQLi]: Access denied for user '****'@localhost (using password: YES)
in SYSTEMPATH/Database/BaseConnection.php on line 427.

sqlite is so much easier to work with than MySQL ,i mean you set up a user and password then still have to use grant permission

So have you run the "grant comand"

last time i used MySQl this is my grant command frm a mysql prompt

Code:

mysql > Grant SELECT, INSERT  ON * TO andy@localhost  IDENTIFIED   by 'mysqlPassword4Userandy'

CMS CI4     I use Arch Linux by the way