ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Installing MariaDB

    Scheduled Pinned Locked Moved IT Discussion
    mariadbdatabasezabbixcentoscentos 7linuxntg lab
    8 Posts 2 Posters 2.0k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A
      antonit
      last edited by scottalanmiller

      Hey guys,

      I've been building a Zabbix monitoring server this week, and was just about to install MariaDB for it's backend database (not for the front end). Was wondering if it would be better to install it as a db user or as an admin on the box?

      Antoni

      1 Reply Last reply Reply Quote 1
      • S
        scottalanmiller
        last edited by

        It's on CentOS 7, the user management is built in for MariaDB. Just do the yum install and the correct user will be created by the installer.

        1 Reply Last reply Reply Quote 0
        • S
          scottalanmiller
          last edited by

          I'm cheating a bit knowing that you are on CentOS 7 🙂

          1 Reply Last reply Reply Quote 0
          • S
            scottalanmiller
            last edited by

            This should be all that is needed for the install...

            yum -y install mariadb-server mariadb
            
            1 Reply Last reply Reply Quote 2
            • A
              antonit
              last edited by

              Yup, installed like a charm. Of course I had to add "sudo" 😉

              1 Reply Last reply Reply Quote 0
              • A
                antonit
                last edited by antonit

                What is the default db admin?

                S 1 Reply Last reply Reply Quote 0
                • S
                  scottalanmiller
                  last edited by

                  As this is a dedicated database server and not on the same box as Zabbix, you will need to open the firewall as well.

                  Be sure to run this script, too.

                  mysql_secure_installation
                  
                  1 Reply Last reply Reply Quote 1
                  • S
                    scottalanmiller @antonit
                    last edited by

                    @antonit said:

                    What is the default db admin?

                    root

                    1 Reply Last reply Reply Quote 0
                    • 1 / 1
                    • First post
                      Last post