MariaDB Server install and config - facing error

KodeKloud Engineer
#1

I done complete config but still DB error, can you guide please @Tej-Singh-Rana @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.

db
db2030×484 36.2 KB

#2

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

#3

@Tej-Singh-Rana yes it same.

#4

But by default db port is 3306.

#5

ok, let me try again with this port. 3306

I thinking for mariaDB its 3307 default. :stuck_out_tongue:

#6

@Tej-Singh-Rana 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’ );

#7

if I can see your urgent response to solve, will be much happy and thankful. @Tej-Singh-Rana

#8

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

#9

@Subhodas09

Hope you can help. in this regards

#10

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

#11

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

#12

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