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.
  • 875 Users Found This Useful

Was this answer helpful?

Related Articles

Clean - Shrink ibdata1

To shrink ibdata1 once and for all you must do the following:MySQLDump all databases into a SQL...

How do I backup a MariaDB - MySQL Database?

Here are the steps on how to backup a MySQL database using phpMyAdmin in your Ultra Web Hosting...

How do I import into a MariaDB - MySQL database?

import a database with Ultra Web Hosting phpMyAdmin: Log in to your control panel with...

Warning: Unknown(): open_basedir restriction in effect

Basedir restriction is set for security. This most often occurs when you are calling an app...

How can I parse html as php?

Create an .htaccess file and upload it to the root of your public_html directory. Include the...