The author is: the_authornRHCE: MariaDB Administration on Redhat\/Fedora\/CentOS
\nCheck if mariaDB is installed or not
\n130 yum list installed | grep ^mariadb
\nmariaDB originated from MySQL – after MySQL Got Bought by Oracle
\n133 yum list installed | grep ^mariadb
\nI see – installed though not completely
\nOutput:
\nmariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda
\nThere are two other components: mariaDB – client component. MariaDB-server: Server Component
\nThe MariaDB packages:
\n138 mariadb-bench.x86_64 mariadb-devel.x86_64 mariadb-server.x86_64 mariadb-test.x86_64 mariadb.x86_64
\nInstall all packages at once
\n139 yum install mariadb*
\n140 yum list installed | grep ^mariadb
\nNow, 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
\nMariaDB Configuration Files
\n149 ls \/etc\/my.cnf
\n150 ls \/etc\/my.cnf.d\/*
\nThe files
\n\/etc\/my.cnf.d\/client.cnf \/etc\/my.cnf.d\/mysql-clients.cnf \/etc\/my.cnf.d\/server.cnf
\n153 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
\n158 grep -v ^# \/etc\/my.cnf : will show lines that are not comments
\n159 grep -v ^# \/etc\/my.cnf
\nThe content of my.cnf : some lines are self explanatory
\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
\nMariaDB messages are logged at: \/var\/log\/mariadb\/mariadb.log
\nMySQL Specific Selinux Contexts
\n171 ps -eZ | grep mysqld
\nI do not see anything as mysqld\/maridb is not running
\n178 systemctl start mariadb.service
\n179 systemctl enable mariadb.service
\n180 ps -eZ | grep mysqld
\nnow 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
\n184 mysqld runs on it’s own domain mysqld_t
\nRelated Selinux file type: mysql_exec_t
\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
\nThe output – please note the Selinux Contexts in the output
\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
\nCorresponding Selinux Port Type: mysql_port_t
\n196 semanage port -l | grep mysqld
\noutput:
\nmysqld_port_t tcp 1186, 3306, 63132-63164
\nRelated Selinux Booleans: mysql_connect_any, selinuxuser_mysql_connect_enabled
\n200 getsebool -a | grep mysql
\nI see the output
\nmysql_connect_any –> off
\nselinuxuser_mysql_connect_enabled –> off
\nTo install MariaDB-Server:
\n205 yum -y install mariadb-server
\nalready installed. we installed with yum -y install mariadb* [installed everything together]
\n207 systemctl enable mariadb
\nWe can run mysql_secure_installation – to secure our MariaDB installation<\/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.
\nEnter current password for root (enter for none):
\nOK, successfully used password, moving on…
\nSetting the root password ensures that nobody can log into the MariaDB
\nroot user without the proper authorisation.
\nSet root password? [Y\/n] y
\nNew password:
\nRe-enter new password:
\nPassword updated successfully!
\nReloading privilege tables..
\n… Success!
\nBy 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.
\nRemove anonymous users? [Y\/n] y
\n… Success!
\nNormally, root should only be allowed to connect from ‘localhost’. This
\nensures that someone cannot guess at the root password from the network.
\nDisallow root login remotely? [Y\/n] y
\n… Success!
\nBy 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.
\nRemove test database and access to it? [Y\/n] y
\n– Dropping test database…
\n… Success!
\n– Removing privileges on test database…
\n… Success!
\nReloading the privilege tables will ensure that all changes made so far
\nwill take effect immediately.
\nReload privilege tables now? [Y\/n] y
\n… Success!
\nCleaning up…
\nAll done! If you’ve completed all of the above steps, your MariaDB<\/p>\n
installation should now be secure. 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 @anaconda There are two other … <\/p>\n
\nThanks for using MariaDB!
\nEnable MariaDB through Firewall and Allow traffic on Port 3306 – default mysql port
\n218 firewall-cmd –add-service=mysql –perm
\n220 firewall-cmd –reload
\n221 systemctl start mariadb
\n222 systemctl status mariadb
\n223 start mysql\/mariadb
\nRun MySQL
\n224 mysql -u root -p
\nmysqldump 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
\n228 mysql -u root -p
\n229 mysqldump -u root -p testsayed > testsayeddb.sql
\nto restore – you need to use < testsayeddb.sql
\n231 mysql -u root -p testsayed < testsayeddb.sql
\nBackup and Restore MySQL Database
\nYou can backup multiple databases at once, you can even backup some tables or other database objects using mysqldump
\nsimilarly, 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
\n235 mysqldump -u root -p DB1 DB2 DB3 > alldb.sql
\nwhen 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
\nexample
\n238 mysql -u root -p DB1 tbl1 < alldb.sql ;
\nyou can use –all-databases or –databases with mysqldump command
\nShare this:LinkedIn<\/a>Facebook<\/a>Twitter<\/a>Skype<\/a>WhatsApp<\/a>Reddit<\/a>Pinterest<\/a>Print<\/a>Tumblr<\/a>Pocket<\/a> From: http:\/\/sitestree.com\/learn-some-centos-redhat-linux-rhce-mariadb-administration-on-redhat-fedora-centos-7\/
Categories:
Tags:
Post Data:2021-01-24 21:25:16<\/p>\n Shop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a>\n (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"> http:\/\/Training.SitesTree.com<\/a> \n In Bengali: <a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\">http:\/\/Bangla.SaLearningSchool.com<\/a>\n <a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\">http:\/\/SitesTree.com<\/a>\n 8112223 Canada Inc.\/JustEtc: <a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\">http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a>\n Shop Online: <a href='https:\/\/www.ShopForSoul.com'> https:\/\/www.ShopForSoul.com\/<\/a>\n Medium: <a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"> https:\/\/medium.com\/@SayedAhmedCanada <\/a>\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"