phpMyAdmin is an essential tool in every administrator toolbox. It is a PHP script meant for giving users the ability to interact with their MySQL/MariaDB databases. Through phpMyAdmin, you can have a “raw” view of the data, tables and fields stored in the MySQL database.
This article will show you how to change the default language in phpMyAdmin in two different way.
Change the language of phpMyAdmin web interface
First, you need to open phpMyAdmin administration page and login.
Locate Appearance settings section, then select the language in its Language drop-down menu.
Change the language in phpMyAdmin's config.inc.php file
Modify the phpMyAdmin's config.inc.php file , and change the following parameters:
$ cfg['DefaultLang'] = 'en' ; // Language if no other language is recognized // or $ cfg['Lang'] = 'en' ; // Force this language for all users
with each variable meaning
- $cfg[‘DefaultLang’] will specify the language if the language phpMyAdmin is not validated.
- $cfg['Lang'] will force the user to use the configuration language specified here