Wamp/MySQL Errors Not in Correct Language

WAMP/MySQL errors not in correct language

To change the language that MySQL uses when reporting you need to change the my.ini file as follows.

Find this line:

# Change your locale here !
lc-messages=fr_FR

And change it to your prefered language, for example:

lc-messages=en_GB

To change it to English US, you can do like this:

lc-messages=en_US

Save the file and then restart MySQL.

left click wampmanager icon -> MySQL -> Service -> Restart Service

Remember the guys that produce WampServer are French so I guess thats why this has been added to the my.ini file, and they just forgot to remove it on this release.

How to Find my.ini in WAMPServer

Use the wampmanager menus like so :-

left click wampmanager icon -> MySQL -> my.ini

This will load the my.ini file into your editor.

Here you can find a list of valid locales

Wamp Server phpMyAdmin not in English

I think there is some other installed languages on your system that caused this problem.
However you can change phpMyAdmin inside its settings. To fix it, please do these steps (As you can't read the texts, I have to tell you an address in phpMyAdmin) :

This is for phpMyAdmin 3.4.5; You may have another version

  1. Open phpMyAdmin
  2. In the home page, look at the main menu in top of the page (right side)
  3. Point your mouse on the last item; A list will be shown to you, then click at the last item with a wrench icon beside it. (You entered to the phpMyAdmin settings)
  4. There are 4 boxes in the current page. Look at the right-bottom one. There is a button there. It's reset button. Click on it ...
  5. Your settings will reset and you can see phpMyAdmin in English language.

Good luck.

error code during install migration is not in english, how to change it to english?

It seems you are using Wamp server's mySQL..

  1. Left click wamp server icon
  2. hover MySQL
  3. left click my.ini

Sample Image

On the text editor,find this line:

lc-messages=fr_FR

And change to:

lc-messages=en_US

After saving the changes,you need to restart Mysql service.

Sample Image

By the way the error you get means:

 access denied for user: homestead'@'@localhost'(password: yes)

Be sure you correctly configure laravel to use on wamp-server and your database settings are correct..

you may need to check both app/config/databese.php and .env file in your root directory..

https://laravel.com/docs/5.0/configuration#environment-configuration

How can i change the language that says in phpMyAdmin in WAMP?

You can do
just as I did...

You have to change in the my.ini file

In the my.ini file, find this line:

# Change your locale here !
lc-messages=fr_FR

and change it in your desire language:

lc-messages=en_GB

I changed it here in United Kingdom English

may this help you.... :)



Related Topics



Leave a reply



Submit