{"id":67600,"date":"2021-07-25T21:30:09","date_gmt":"2021-07-26T01:30:09","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/learn-some-centos-redhat-linux-rhce-mariadb-administration-on-redhat-fedora-centos-devops-rhce\/"},"modified":"2021-07-25T21:30:09","modified_gmt":"2021-07-26T01:30:09","slug":"learn-some-centos-redhat-linux-rhce-mariadb-administration-on-redhat-fedora-centos-devops-rhce","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=67600","title":{"rendered":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS #DevOps #RHCE"},"content":{"rendered":"

RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS<\/strong><\/p>\n

Check if mariaDB is installed or not<\/strong><\/p>\n

130 yum list installed | grep ^mariadb<\/p>\n

mariaDB originated from MySQL – after MySQL Got Bought by Oracle<\/p>\n

133 yum list installed | grep ^mariadb<\/p>\n

I see – installed though not completely<\/p>\n

Output:<\/strong><\/p>\n

mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda<\/p>\n

There are two other components: mariaDB – client component. MariaDB-server: Server Component<\/p>\n

The MariaDB packages:<\/strong>
\n138 mariadb-bench.x86_64 mariadb-devel.x86_64 mariadb-server.x86_64 mariadb-test.x86_64 mariadb.x86_64<\/p>\n

Install all packages at once<\/strong><\/p>\n

139 yum install mariadb*
\n140 yum list installed | grep ^mariadb<\/p>\n

Now, I see the following, after I have installed – all MariaDB packages available in my system
\nmariadb.x86_64 1:5.5.52-1.el7 @local
\nmariadb-bench.x86_64 1:5.5.52-1.el7 @local
\nmariadb-devel.x86_64 1:5.5.52-1.el7 @local
\nmariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda
\nmariadb-server.x86_64 1:5.5.52-1.el7 @local
\nmariadb-test.x86_64 1:5.5.52-1.el7 @local<\/p>\n

MariaDB Configuration Files<\/strong>
\n149 ls \/etc\/my.cnf
\n150 ls \/etc\/my.cnf.d\/*<\/p>\n

The files
\n\/etc\/my.cnf.d\/client.cnf \/etc\/my.cnf.d\/mysql-clients.cnf \/etc\/my.cnf.d\/server.cnf<\/p>\n

153 vim \/etc\/my.cnf
\n154 vim \/etc\/my.cnf.d\/client.cnf
\n155 vim \/etc\/my.cnf.d\/server.cnf
\n156 vim \/etc\/my.cnf.d\/mysql-clients.cnf
\n157 main config file \/etc\/my.cnf<\/p>\n

158 grep -v ^# \/etc\/my.cnf : will show lines that are not comments
\n159 grep -v ^# \/etc\/my.cnf<\/p>\n

The content of my.cnf : some lines are self explanatory<\/strong><\/p>\n

[mysqld]
\ndatadir=\/var\/lib\/mysql
\nsocket=\/var\/lib\/mysql\/mysql.sock
\nsymbolic-links=0
\n[mysqld_safe]
\nlog-error=\/var\/log\/mariadb\/mariadb.log
\npid-file=\/var\/run\/mariadb\/mariadb.pid<\/p>\n

MariaDB messages are logged at: \/var\/log\/mariadb\/mariadb.log<\/p>\n

MySQL Specific Selinux Contexts<\/strong>
\n171 ps -eZ | grep mysqld
\nI do not see anything as mysqld\/maridb is not running<\/p>\n

178 systemctl start mariadb.service
\n179 systemctl enable mariadb.service
\n180 ps -eZ | grep mysqld<\/p>\n

now the output:
\nsystem_u:system_r:mysqld_safe_t:s0 4428 ? 00:00:00 mysqld_safe
\nsystem_u:system_r:mysqld_t:s0 4585 ? 00:00:00 mysqld<\/p>\n

184 mysqld runs on it’s own domain mysqld_t<\/p>\n

Related Selinux file type: mysql_exec_t<\/strong>
\netc_t is for \/etc\/my.cnf.d
\nmysql_db_t is for \/var\/lib\/mysql\/
\nmysql_log_t is for \/var\/log\/mariadb\/
\n189 ll -dZ \/usr\/libexec\/mysqld \/etc\/my.cnf.d \/var\/lib\/mysql \/var\/log\/mariadb<\/p>\n

The output – please note the Selinux Contexts in the output<\/strong>
\ndrwxr-xr-x. root root system_u:object_r:mysqld_etc_t:s0 \/etc\/my.cnf.d
\n-rwxr-xr-x. root root system_u:object_r:mysqld_exec_t:s0 \/usr\/libexec\/mysqld
\ndrwxr-xr-x. mysql mysql system_u:object_r:mysqld_db_t:s0 \/var\/lib\/mysql
\ndrwxr-x—. mysql mysql system_u:object_r:mysqld_log_t:s0 \/var\/log\/mariadb<\/p>\n

Corresponding Selinux Port Type: mysql_port_t<\/strong>
\n196 semanage port -l | grep mysqld
\noutput:
\nmysqld_port_t tcp 1186, 3306, 63132-63164<\/p>\n

Related Selinux Booleans: mysql_connect_any, selinuxuser_mysql_connect_enabled
\n200 getsebool -a | grep mysql<\/p>\n

I see the output
\nmysql_connect_any –> off
\nselinuxuser_mysql_connect_enabled –> off<\/p>\n

To install MariaDB-Server:<\/strong>
\n205 yum -y install mariadb-server
\nalready installed. we installed with yum -y install mariadb* [installed everything together]<\/p>\n

207 systemctl enable mariadb<\/p>\n

We can run mysql_secure_installation – to secure our MariaDB installation<\/strong>
\n209 mysql_secure_installation<\/p>\n

—–<\/p>\n

The Output: from mysql_secure_installation command
\nNOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
\nSERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
\nIn order to log into MariaDB to secure it, we’ll need the current
\npassword for the root user. If you’ve just installed MariaDB, and
\nyou haven’t set the root password yet, the password will be blank,
\nso you should just press enter here.<\/p>\n

Enter current password for root (enter for none):
\nOK, successfully used password, moving on…<\/p>\n

Setting the root password ensures that nobody can log into the MariaDB
\nroot user without the proper authorisation.<\/p>\n

Set root password? [Y\/n] y
\nNew password:
\nRe-enter new password:
\nPassword updated successfully!
\nReloading privilege tables..
\n… Success!<\/p>\n

By default, a MariaDB installation has an anonymous user, allowing anyone
\nto log into MariaDB without having to have a user account created for
\nthem. This is intended only for testing, and to make the installation
\ngo a bit smoother. You should remove them before moving into a
\nproduction environment.<\/p>\n

Remove anonymous users? [Y\/n] y
\n… Success!<\/p>\n

Normally, root should only be allowed to connect from ‘localhost’. This
\nensures that someone cannot guess at the root password from the network.<\/p>\n

Disallow root login remotely? [Y\/n] y
\n… Success!<\/p>\n

By default, MariaDB comes with a database named ‘test’ that anyone can
\naccess. This is also intended only for testing, and should be removed
\nbefore moving into a production environment.<\/p>\n

Remove test database and access to it? [Y\/n] y
\n– Dropping test database…
\n… Success!
\n– Removing privileges on test database…
\n… Success!<\/p>\n

Reloading the privilege tables will ensure that all changes made so far
\nwill take effect immediately.<\/p>\n

Reload privilege tables now? [Y\/n] y
\n… Success!<\/p>\n

Cleaning up…<\/p>\n

All done! If you’ve completed all of the above steps, your MariaDB<\/p>\n

\n

installation should now be secure.
\nThanks for using MariaDB!<\/p>\n

Enable MariaDB through Firewall and Allow traffic on Port 3306 – default mysql port
\n218 firewall-cmd –add-service=mysql –perm
\n220 firewall-cmd –reload<\/p>\n

221 systemctl start mariadb
\n222 systemctl status mariadb
\n223 start mysql\/mariadb<\/p>\n

Run MySQL<\/strong><\/p>\n

224 mysql -u root -p<\/p>\n

mysqldump is used to backup a database
\nmysql command can be used to restore a database
\nyou can even use IDEs such as MySQL Workbench to backup and restore MySQL Databases<\/p>\n

228 mysql -u root -p
\n229 mysqldump -u root -p testsayed > testsayeddb.sql<\/p>\n

to restore – you need to use < testsayeddb.sql
\n231 mysql -u root -p testsayed < testsayeddb.sql<\/p>\n

Backup and Restore MySQL Database<\/strong><\/p>\n

You can backup multiple databases at once, you can even backup some tables or other database objects using mysqldump<\/p>\n

similarly, you can restore multiple databases at the same time using mysql command
\njust use multiple datbase or database object names with NO comma – one after another<\/p>\n

235 mysqldump -u root -p DB1 DB2 DB3 > alldb.sql<\/p>\n

when you use restore and give the sql file – if you use db name or table name before < then only that part will be restored irrespective hiow much data is there on the file<\/p>\n

example<\/strong>
\n238 mysql -u root -p DB1 tbl1 < alldb.sql ;<\/p>\n

you can use –all-databases or –databases with mysqldump command From: http:\/\/sitestree.com\/?p=12128
Categories:DevOps, RHCE
Tags:
Post Data:2018-01-03 18:59:06<\/p>\n

\t\tShop Online: https:\/\/www.ShopForSoul.com\/<\/a>
\n\t\t(Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com<\/a>
\n\t\tIn Bengali: http:\/\/Bangla.SaLearningSchool.com<\/a>
\n\t\thttp:\/\/SitesTree.com<\/a>
\n\t\t8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a>
\n\t\tShop Online: https:\/\/www.ShopForSoul.com\/<\/a>
\n\t\tMedium: https:\/\/medium.com\/@SayedAhmedCanada <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL – after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see – installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda There are two other components: mariaDB – … <\/p>\n

Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-67600","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":20401,"url":"http:\/\/bangla.sitestree.com\/?p=20401","url_meta":{"origin":67600,"position":0},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS","author":"Author-Check- Article-or-Video","date":"February 20, 2021","format":false,"excerpt":"RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda There are\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":20403,"url":"http:\/\/bangla.sitestree.com\/?p=20403","url_meta":{"origin":67600,"position":1},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS","author":"Author-Check- Article-or-Video","date":"February 20, 2021","format":false,"excerpt":"The author is: the_authornRHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":20405,"url":"http:\/\/bangla.sitestree.com\/?p=20405","url_meta":{"origin":67600,"position":2},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS","author":"Author-Check- Article-or-Video","date":"February 20, 2021","format":false,"excerpt":"The author is: the_authornRHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":20409,"url":"http:\/\/bangla.sitestree.com\/?p=20409","url_meta":{"origin":67600,"position":3},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS","author":"Author-Check- Article-or-Video","date":"February 20, 2021","format":false,"excerpt":"The author is: the_authornRHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":20411,"url":"http:\/\/bangla.sitestree.com\/?p=20411","url_meta":{"origin":67600,"position":4},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS","author":"Author-Check- Article-or-Video","date":"February 20, 2021","format":false,"excerpt":"The author is: the_authornRHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":70313,"url":"http:\/\/bangla.sitestree.com\/?p=70313","url_meta":{"origin":67600,"position":5},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS #nothing","author":"Author-Check- Article-or-Video","date":"September 1, 2021","format":false,"excerpt":"RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda There are\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/67600","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=67600"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/67600\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=67600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=67600"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=67600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}