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.
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.
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
- Click the phpMyAdmin link on your eenos control panel from MySQL -> phpMyAdmin, or
- Go to https://your-website-name/eenos-phpmyadmin/
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.