Linux Server
Admin

Session9: Complete Mysql Server Administration, mysql backup & restoration, mysql_secure installation, root's password restoration, mysql users management, Queries, Mysql Parameters, Mysql Optimization.

Study to pass the Red Hat Certified Engineer (RHCE) exam—the benchmark certification for Red Hat Enterprise Linux. This installment of the RHCE Cert Prep series covers database configuration and management with MariaDB. Instructor Grant McWilliams begins by reviewing database basics, walking through a MariaDB server install, and noting differences between MySQL and MariaDB. Then he demonstrates some SQL commands for creating databases and tables, and how to query the data held within them. Next, he explains how to set and recover the database root user’s password and secure your database server installation. Finally, he shows how to create and restore logical MariaDB backups of databases and tables.

0 min.

Learning Objectives:

  • Installing MariaDB server
  • MariaDB commands, configuration files, and logs
  • Addressing SELinux concerns
  • Using the MySQL shell
  • Managing databases and tables with subcommands
  • Creating a database with tables
  • Querying a database
  • Renaming tables and updating records
  • Setting and recovering the root database password
  • Securing your MariaDB server installation
  • Performing and restoring logical database backups
Grant McWilliams

Grant McWilliams

Session Instructor

Grant McWilliams is a consultant, speaker, writer, professor, and developer specializing in Linux and open source.

His public speaking engagements include LinuxCon (New Orleans, 2013), Xen Project User Summit (NYC, 2014), and LinuxFest Northwest (Bellingham, WA, 2004–2011). His technical writing and editing achievements include writing documentation and man pages for Citrix XenServer via the Xenapi Admin Project.

Back to Course

Tanuj

Instructor

Tanuj Chugh, an adept and prominent trainer and speaker have been associated to education sector from many years and have an experience of more than 9 years of live industry projects based on latest technologies like Virtualization, Cloud Computing, AWS, Google Cloud, Azure, Linux & Windows Servers, Network & Security etc. Upholding the responsibilities of delivering in-house and online training to the corporate employees, clients and individuals.

Full Profile

Ready to get started?

Get in touch

Contact Us