{"id":3951,"date":"2020-03-05T23:19:48","date_gmt":"2020-03-05T23:19:48","guid":{"rendered":"https:\/\/lamp.ciscoar.com\/?page_id=3951"},"modified":"2020-03-06T00:56:34","modified_gmt":"2020-03-06T00:56:34","slug":"mariadb-admin-user","status":"publish","type":"page","link":"https:\/\/lamp.ciscoar.com\/?page_id=3951","title":{"rendered":"MariaDB admin user"},"content":{"rendered":"\n\n\n

Administrator user account<\/h2>\n\n\n\n

It is always recommended to have one specific user account for the MariaDB administration, using the GUI provided by phpMyAdmin is really easy to add new users and also to assign permissions over databases.<\/p>\n\n\n\n

Root account<\/h2>\n\n\n\n

If you are working on a LAB environment you can perfectly use the super user account, I’m talking about the user called “root”, the one that was configured (a password was assigned) while performing the MariaDB securization<\/a> (if that’s a valid word).<\/p>\n\n\n\n

LAB environment case<\/h2>\n\n\n\n

In our case, we are working on a LAB environment and for that reason we can just go ahead and configure the user “root” as the user in charge of the MariaDB recently created<\/a> administration, just for educational purposes.<\/p>\n\n\n\n

\"\"<\/a>
root account has ALL privileges over the selected database<\/figcaption><\/figure><\/div>\n\n\n\n

The above phpMyAdmin screenshot shows our LAB and for that particular database called “php_website_database<\/strong>” the super user “root” has granted ALL PRIVILEGES, that is perfectly fine for us because that’s all we need to integrate the database with WordPress and be able to start building our website.<\/p>\n\n\n\n

Where to go next?<\/h2>\n\n\n\n

Now that is clear we’re going to use the MariaDB “root” accoun to integrate WordPress with its database, you can move forward to that step.<\/p>\n\n\n\n