Knowledgebase

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.

4. 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.

5. 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.