Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

WAMP/MySQL errors not in correct language

I've re-installed WAMP multiple times, searched literally hundreds of pages, and its not fixed this issue:

enter image description here

I've looked inside the phpmyadmin config files, set:

$cfg['Lang'] = 'en-utf-8'; 

Uninstalled multiple times (as mentioned) and seemed to have no luck what so ever. Any help would be appreciated.

like image 845
Dobby Avatar asked May 22 '14 09:05

Dobby


People also ask

Why MySQL in WAMP is not working?

MySQL can be installed as part of some other tools/apps. If that is the case they normally set the service name to MYSQL and set it to start automatically so it is probably running before you get to start WAMPServer and therefore blocking port 3306.

Why phpMyAdmin is not working in WAMP?

Make sure that nothing else is using port 80. Look under options >> advanced >> connection and see if "use port 80" is checked. Uncheck if so. Then restart Skype. Might have to restart WAMP too.

How do I change the default DBMS in WAMP?

There's a solution that just requires right-clicking on the WAMP icon, go to "Tools" and click on "Invert default DBMS MariaDB <-> MySQL", that should work. It will set MySQL as a default engine, change the port numbers for you and restart the services all by itself.


2 Answers

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

like image 85
RiggsFolly Avatar answered Sep 22 '22 17:09

RiggsFolly


Change the following settings in my.ini file

lc-messages=en_US 

To permanently change the language preferences

like image 44
Rooha Ali Avatar answered Sep 21 '22 17:09

Rooha Ali