MariaDB Server install and config - facing error

I done complete config but still DB error, can you guide please @player001 @Inderpreet @rahul456

=======================================Word press config file================
/** The name of the database for WordPress */
define( ‘DB_NAME’, ‘kodekloud_db4’ );

/** MySQL database username */
define( ‘DB_USER’, ‘kodekloud_cap’ );

/** MySQL database password */
define( ‘DB_PASSWORD’, ‘123sc’ );

/** MySQL hostname */
define( ‘DB_HOST’, ‘localhost:3307’ );

==============================
create database kodekloud_db4;
CREATE USER ‘kodekloud_cap’@localhost IDENTIFIED BY ‘123sc’;
GRANT ALL PRIVILEGES ON . TO ‘kodekloud_cap’@localhost;
FLUSH PRIVILEGES;

Restore database also was successful.

Hello, @bilalshakir41396
Is it the same task? So let me read the task requirements as per image.

@player001 yes it same.

But by default db port is 3306.

ok, let me try again with this port. 3306

I thinking for mariaDB its 3307 default. :stuck_out_tongue:

@player001 I try with 3306.

but same error.

where I can see error logs?

host we needs to use as localhost or like this in wordpress config fille.

/** The name of the database for WordPress */
define( ‘DB_NAME’, ‘kodekloud_db4’ );

/** MySQL database username */
define( ‘DB_USER’, ‘kodekloud_roy’ );

/** MySQL database password */
define( ‘DB_PASSWORD’, ‘123sc’ );

/** MySQL hostname */
define( ‘DB_HOST’, ‘127.0.0.1:3306’ );

if I can see your urgent response to solve, will be much happy and thankful. @player001

Try it by yourself. It’s so much fun.

@Subhodas09

Hope you can help. in this regards

@bilalshakir41396

Would you please verify user name and password with mysql client?

mysql -u kodekloud_roy -p123sc kodekloud_db4

when you get into mysql user write a simple query like this :
select * from kodekloud_db4;

I doubt you have set right password.

that means at every application node we needs to install mysql client ? I think I have not installed. @Nasri

@bilalshakir41396 , no the package is a client package and is used to connect to database server.