MySQL

Manage MySQL database and database users.

Add MySQL Database

Create MySQL Database

This page will help you to create a MySQL database under your eenos account.

Go to: MySQL -> Add MySQL Database

To create a MySQL database, you need to fill out the following,

Database Name, a name for a database.

The database name starts with the prefix eenosuser_. You only need to enter the remaining part of the name.

Select Database Server,  select a MySQL host server to create the database

Now, click the Create Database button to start creating the database.


Add MySQL User

Create MySQL  Database User

This page is for creating a MySQL database user to connect to your MySQL server.

Location:

MySQL -> Add MySQL User

Both the database and the user need to be on the same server to make the connection.

You may need to enter all the details to create the user as follows,

Enter Database User Name, a user name to connect

Select Database Server,  select the MySQL server to create a user

User Password, enter a strong password for the MySQL user

Access Host, from which server or IP the user is connecting. If you don't know, choose localhost. 

Now, click the button Add MySQL User to start adding the user.

Add User to Database

Assign MySQL Database user to a database

From this page, you can assign privileges for a MySQL database user to a particular database.

Location :

MySQL -> Add User to Database

You may select the following details to assign the user.

Select Database,  a database to add

Select Database User, a MySQL  user to assign to the database

Both Database and User need to be in the same MySQL server to assign.

Assign Database User Privileges, to grant the privileges for  MySQL users.

Now, click the button  Assign User to add the user to the selected database.

MySQL Databases

Manage Your MySQL Databases

This page will help you manage your MySQL databases from the eenos control panel.

Location :

MySQL -> MySQL Databases

From this page, you can delete a database or assign a user to a database.

Revoke MySQL User

To remove a user from a database,  select the mysql user and click the user remove icon from this page.

Delete MySQL Database

To delete your database, click the Delete Database button. 

MySQL Users

MySQL  User Management

You can manage your MySQL users from this page. These operations include changing the access host, changing the password, and deleting the user.

Location:

MySQL -> MySQL Users

Change Access Host

The host is allowed to connect to the database using the selected MySQL user name. To change the access host, click the edit icon on the respective column.

Change MySQL User Password

To change the  MySQL user password, click the button Change Password for the respective  MySQL user.

Delete MySQL User

You can delete a MySQL user, by clicking the button Delete User.

You can remove a user only if it is revoked from all databases. 


phpMyAdmin

Accessing phpMyAdmin from the eenos control panel.

You can access the PHPMyAdmin interface on your eenos server from the following   links

Eenos provides  phpmyadmin interface with a basic set of configurations so that you can manage your database from your browser.

You may now need to log in with the database username and password.