Tag: MariaDB

1. 1. Log into your Cloud Sites control panel.
   2. Click on the website where you’ll be creating your database.
      

MySQL’s, and MariaDB’s, strict mode controls how invalid or missing values in data changing queries are handled; this includes INSERT, UPDATE, and CREATE TABLE statements. With MySQL strict mode enabled, which is the default state, invalid or missing data may cause warnings or errors when attempting to process the query.

Copying a table is quick and easy to do within PhpMyAdmin. Whether you are trying to make a backup copy before changes are made, archiving data, moving data to a new site or application, or even just working on restructuring your database, PhpMyAdmin can help you get the job done in just a few clicks.

This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen. Let’s learn how to delete a database user.

This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen. Now let’s learn how to check a database for errors.

This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen.  Let’s learn how to remove a user from a database.

This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen. Let’s learn how to assign a user to a database.

1. This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen.
2. Now let’s learn how to create a MySQL database user.
3. Click the “MySQL Databases” icon.
4. Under “Add New User”, enter a username for the user you want to create, along with a password.
5. Then click “Create User”.
6. That’s it! The new database user has been created.
7. You can see the new database user listed at the bottom of the page.

This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen. Let’s learn how to set up a database using the MySQL Database Wizard. Click the “MySQL Database Wizard” icon.