What is PHPMyAdmin and where can I access it?
phpMyAdmin is an open source web-based application written in PHP. It provides a convenient visual interface in your browser to work with MySQL databases, the world's leading database management system. It has all the features you need to manage your databases:
- Searching your database tables
- Delete or truncate your database tables
- Renaming and changing the fields and indexes of database tables
- Import or export a database
- Execute database queries
- Search the database for a specific entry
- and many, many more
The database administration is fully integrated into the service we offer and can be easily accessed from the cPanel. In this tutorial we will introduce you to the basics of using phpMyAdmin so that you can use it with confidence in the future. Let's get started!
Access to the phpMyAdmin function in cPanel
Before you can access the phpMyAdmin functionality, you will need to log into your cPanel account with us. To do this, please read our instructions for the Access to the cPanel service.
Once you are logged in, please navigate to the "Database" section and click on the "phpMyAdmin" icon.
When you click on the result, you will be redirected to phpMyAdmin, with which you can manage your database. Let's go through the startup screen and explain each aspect.
A look at the index page of phpMyAdmin
The first thing you will notice after logging in is the Server indication: localhost:3306 at the top of the screen. This indicates that you are currently using a locally configured MySQL Server use, which is based on Port 3306 is running. This information is also the details you need to specify for your database in your application's configuration file for "Hostname" and "Port".
Below you can see two sections: General settings and Display settings. In the General Settings section you can change the MySQL server connection collation. This setting determines the character set or encoding used to send data to and from MySQL. We recommend that you use the default setting utf8mb4_unicode_ci unless you want phpMyAdmin to use a very specific encoding. utf8mb4_unicode_ci ensures that communication between phpMyAdmin and MySQL uses the full UTF-8 character set. If you want to change the encoding, please use the dropdown menu and select the desired encoding.
The Display Settings section is intended for changing the theme, language and font size. To change these settings use the dropdown menus provided.
On the left side you will see a list of all your databases located on the server.
The table information_scheme contains valuable information such as database metadata and other useful information about the MySQL server that is important for the normal operation of the database on your account. You should pay no attention to it and concentrate on the Database tables of your website.
Please do not delete or modify any tables or entries in the "information_schema" database, as this may cause serious problems with all databases of your web hosting account and possibly lead to data loss.
Finally, on the right side of the screen you will see three areas: the area "Database Server", the range "Web Server" and the area "phpMyAdmin".
The first field Database Server shows you information about the MySQL server, such as the version, the current user and the MySQL character set.
In the Web Server section you can find information about the web server, such as the version, supported MySQL related PHP extensions and the current PHP version.
In the phpMyAdmin section you will find the current version as well as useful links to the phpMyAdmin tool.
We hope this summary of phpMyAdmin, how to access it and the index page will help you get started. If you experience any technical issues with this feature, such as not being able to access or use it, please contact our technical support via the Ticket system in your customer area.
The cheapest web hosting in Switzerland
Our EASY web hosting is cheap, fast & secure with free SSL certificate