WAMP/MySQL errors not in correct language

by

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

More Related Contents:

  1. Access denied for user ‘root’@’localhost’ with PHPMyAdmin
  2. Can I store query result of one field into different variables? if not then what should I do for that?
  3. The requested URL was not found on this server.
  4. Project Links do not work on Wamp Server
  5. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  6. WAMP Cannot access on local network 403 Forbidden
  7. How to write a stored procedure using phpmyadmin and how to use it through php?
  8. Import file size limit in PHPMyAdmin
  9. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  10. Mysql event error using php
  11. Store procedures in phpMyAdmin
  12. How to solve time out in phpmyadmin?
  13. phpmyadmin automatic logout time
  14. WAMPServer phpMyadmin Maximum execution time of 360 seconds exceeded
  15. #1193 – Unknown system variable ‘lc_messages’ when trying to login to phpmyadmin
  16. Unknown database error in PHP but it exists in PHPMyAdmin
  17. Extension mysqli is missing, phpmyadmin doesn’t work
  18. How to SELECT DEFAULT value of a field
  19. How to log in to phpMyAdmin with WAMP, what is the username and password?
  20. Auto Increment skipping numbers?
  21. How to write a stored procedure in phpMyAdmin?
  22. Installing PDO driver on MySQL Linux server
  23. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’
  24. which is better every user have a table or just a row [closed]
  25. Best practice: Import mySQL file in PHP; split queries
  26. unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING error [duplicate]
  27. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  28. Remotely connecting to a MySQL database
  29. How do you make good use of multicore CPUs in your PHP/MySQL applications? [closed]
  30. How to get a list of databases?

Leave a Comment