Install / configure mariadb

#1

I have done the following for installing and configuring mariadb:

  1. ssh peter@stdb01

  2. sudo yum install openssh-client

  3. scp db.sql peter@stdb01:~/ from jump_host

  4. ssh peter@stdb01

  5. sudo yum install mariadb-server
    sudo systemctl start mariadb
    sudo systemctl enable mariadb
    sudo systemctl status mariadb
    sudo mysql_secure_installation

  6. CREATE USER kodekloud_gem IDENTIFIED BY ‘password’;
    CREATE DATABASE kodekloud_db1;
    GRANT ALL privileges ON kodekloud_db1.* TO kodekloud_gem;
    mysql -u kodekloud_gem -p kodekloud_db1 < db.sql;

  7. ssh tony@stapp01
    Ir0nM@n
    mysql -u kodekloud_gem -p -h stdb01

  8. ssh steve@stapp02
    Am3ric@
    mysql -u kodekloud_gem -p -h stdb01

  9. ssh banner@stapp03
    BigGr33n
    mysql -u kodekloud_gem -p -h stdb01

  10. edited wp-config in all app servers
    db_name ‘kodekloud_db1’
    db_user ‘kodekloud_gem’
    db_host ;localhost’
    db_pass ‘password’

After doing the above steps I am still getting an error: “connection cannot be established to database”

Please see the below screenshots.

banner
banner1366×768 132 KB
steve
steve1366×768 132 KB
tony
tony1366×768 137 KB
banner
banner1366×768 132 KB

#2

Seems like you are passing incorrect DB host i.e localhost in wp-config file. Please not that database is running on Database server instead.

#3

Hi Inderpreet,

I did the same above steps mentioned in my previous post for installing & Configuring
mariadb with changes to user: kodekloud_pop, db: kodekloud_db8.

CREATE USER kodekloud_pop IDENTIFIED BY ‘password’;
CREATE DATABASE kodekloud_db8;
GRANT ALL privileges ON kodekloud_db8 .* TO kodekloud_pop;
mysql -u kodekloud_pop -p kodekloud_db8 < db.sql;

wp-config edited as follows:

db_name ‘kodekloud_db8’
db_user ‘kodekloud_pop’
db_host 'stdb01.stratos.xfusioncorp.com’
db_pass ‘password’

database server hostname from wiki: stdb01.stratos.xfusioncorp.com

The result I keep getting is the same. What am I doing wrong?

error
error1366×768 66.3 KB

#6

for the db host you need to enter ip:port number

#7

In wp-config. php set debug to true. So that you can get error message. what exactly went wrong.Also add port number 3306.in dn=b_host.
Also add 3 lines in /etc/my.cnf file in mysqld section.
[mysqld]
skip-grant-tables
skip-networking=0
skip-binding

1 Like
#8

I went in /etc and ls there on db server but there was no my.cnf file…Can you pls suggest how can get /etc/my.cnf file.

#9

/etc/my.cnf file is default confiuration file.When you install mariadb.Which version db you installed.
you can also check /etc/mysql/my.cnf

#10

@shabbir…Have one more doubt aboult wp-config.php file that it should be edited on all app servers or only should be edited on db server.

#11

Only in the DB server. Apologies you have to change in storage server.

1 Like
#12

@shabbir@Inderpreet… I opened wp-config.php file in db server but its blank and i tried to open it in app server stapp01 there i can see the editable file…plz suggest.

#13

You have to change in storage server NFS share which mounted as /var/www/html all app server. there you can find /data/wp-config.php. in my case. in your case will be different.

#14

Just edit and save in NFS server, It will be reflected in all app servers

#15

I got the same error.
My problem was a wrong permission configuration in the mariadb user.
I could solved thanks to @shabbir tip “set debug to true in wp-config.php”. After that, I could understood where my problem was located.