How to change default language in phpMyAdmin

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 Code language: JavaScript (javascript)

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

Also check out: Fix MySQL ERROR 1045 (28000): Access denied for user ‘user’@’localhost’ (using password)