How do I add a user to a MariaDB & MySQL database?

There are two ways to add a user to a MySQL database with Ultra Web Hosting:

 

Using phpMyAdmin

  1. Go to your Ultra Web Hosting control panel.
  2. Click on the "MySQL Databases" tab.
  3. Navigate to MySQL Users "Add New user".
  4. Enter a new Username and Password (twice).
  5. Click "Create user".
  6. In the "Users" section, click on the "Add User" button.
  7. Navigate to "Add User To Database".
  8. Select the new user in the drop down menu. 
  9. Select the corresponding database you want to add the user to.
  10. Click "Add".
  11. Check/click "All Privileges" (important).
  12. Click "Make Changes".

Using the command line via SSH

  1. Log in to your Linux web server via Secure Shell/SSH.
  2. Open the MySQL client program on the server in the /usr/bin directory.
  3. Type in the following syntax to create a new user:
CREATE USER 'username'@'hostname' IDENTIFIED BY 'password';
  • {username} is the name of the new user.
  • {hostname} is the hostname of the server where the database is located.
  • {password} is the password for the new user.
  1. Type in the following syntax to grant privileges to the new user:
GRANT {privileges} ON {databasename}.* TO 'username'@'hostname';
  • {privileges} is a comma-separated list of privileges. For example, to grant all privileges, you would type ALL PRIVILEGES.
  • {databasename} is the name of the database that you want to grant privileges to.
  1. Example:
GRANT ALL PRIVILEGES ON my_database.* TO 'my_user'@'localhost';

This will grant all privileges to the user my_user on the database my_database.

Once you have added the user, you can test to see if they have been granted the correct privileges by logging in to the database as the new user. For example, to log in as the user my_user on the database my_database, you would type the following command:

mysql -u my_user -p my_database


If you are able to log in and see the data in the database, then the user has been granted the correct privileges.


Which method you choose will depend on your preference and level of technical knowledge. If you are not familiar with the MySQL command line, then the control panel is a good option. It is a web-based interface that makes it easy to view and manage your MySQL databases.


Contact Ultra if you need help.
  • 871 Users Found This Useful

Was this answer helpful?

Related Articles

Strict Standards: Non-static method JLoader::register() should not be called statically in

The error message...  Strict Standards: Non-static method JLoader::register() should not be...

403 Forbidden error with Drupal after install

There are a few things you can do to fix the 403 Forbidden error with Drupal after install:...

Learn About MySQL

MySQL is a relational database management system (RDBMS) that is open-source and free to use. It...

Running a PHP file with a cron job

To run a PHP file from cron, use the "cron jobs" section of your control panel. Use the following...

Could not connect to the MariaDB - MySQL database

The error message "Could not connect to the MariaDB" can occur for a number of reasons. Some of...