{"id":1662,"date":"2020-01-10T00:57:13","date_gmt":"2020-01-10T00:57:13","guid":{"rendered":"https:\/\/lamp.ciscoar.com\/?page_id=1662"},"modified":"2020-05-07T18:33:25","modified_gmt":"2020-05-07T18:33:25","slug":"creating-a-new-mysql-maria-data-base","status":"publish","type":"page","link":"https:\/\/lamp.ciscoar.com\/?page_id=1662","title":{"rendered":"Creating a new MySQL Maria Data Base"},"content":{"rendered":"\n\n\n

Creating a new MySQL Maria database<\/h2>\n\n\n\n
\"\"<\/figure>
\n

WordPress uses a relational database to manage information for the site (text, images, animations, videos, etc.) and also for its users (administrators, contributors, subscribers, editors, etc.). <\/p>\n<\/div><\/div>\n\n\n\n

We already have MariaDB <\/a>(a fork of MySQL) installed on our Linux CentOS <\/a>, which can provide this functionality, the only thing we have to do now is to go ahead and create a new database that will be used with WordPress, and also assign permissions to a particular user for WordPress to be able to manage that database.<\/p>\n\n\n\n

Using phpMyAdmin to create a new DB<\/h2>\n\n\n\n

The easiest way to create a new MySQL (Maria database) is using the GUI provided by phpMyAdmin<\/a><\/strong>, for those of you who prefer to create the DB using the CLI here<\/a> you can find all the commands.<\/p>\n\n\n\n

\"\"<\/a>
phpMyAdmin new database<\/figcaption><\/figure><\/div>\n\n\n\n

Only two things have to be chosen when creating a brand new MySQL (MariaDB) database, the database name<\/strong> and the collation<\/strong>, see below screenshots taken from phpMyAdmin.<\/p>\n\n\n\n

\"\"<\/a>
phpMyAdmin choose database name<\/figcaption><\/figure><\/div>\n\n\n\n
\"\"<\/a>
Maria database select collation UTF8 MB4 unicode<\/figcaption><\/figure><\/div>\n\n\n\n
\"\"<\/a>
phpMyAdmin create database<\/figcaption><\/figure><\/div>\n\n\n\n

Immediately after the database creation you will be located inside the database, as you can imagine the new DB is empty, that means no tables will be found.<\/p>\n\n\n\n

\"\"<\/a>
The new database is blank (no tables)<\/figcaption><\/figure><\/div>\n\n\n\n

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

The main advantage of using a CMS (content management system) when creating a new website is that you don’t have to worry for the database and its tables, everything will be managed automatically for us once the configuration is done.<\/p>\n\n\n\n

The next step is to create a user and assign permissions over the database, that user will be used by WordPress, once they are configured to work together you will see all the tables populated automatically.<\/p>\n\n\n\n