MariaDB – Create Database Creation or deletion of databases in MariaDB requires privileges typically only given to root users or admins. Under these accounts, you have two options for creating a database − the mysqladmin binary and a PHP script. mysqladmin binary The following example demonstrates the use of the mysqladmin binary in creating a […]
Category Archives: mariadb
MariaDB – Introduction A database application exists separate from the main application and stores data collections. Every database employs one or multiple APIs for the creation, access, management, search, and replication of the data it contains. Databases also use non-relational data sources such as objects or files. However, databases prove the best option for large […]
MariaDB – Select Database After connecting to MariaDB, you must select a database to work with because many databases may exist. There are two ways to perform this task: from the command prompt or through a PHP script. The Command Prompt In choosing a database at the command prompt, simply utilize the SQL command ‘use’ […]