MySQL Forums
Forum List  »  PHP

Re: Charset SESSION vs GLOBAL
Posted by: Cédric Michel
Date: March 30, 2011 05:00AM

Yeah!!!

The solution was effectively to create a new user with limited rights! It was also necessary to add init-connect = 'SET NAMES latin1' in the my.cnf (which doesn't work with root).

my.cnf:
[mysqld]
init-connect = 'SET NAMES latin1'

+ new user with GRANT [em]SELECT,INSERT,UPDATE,DELETE,CREATE,DROP[/em] on database

Thank you for tips! And also for the link which learnt me a lot

Cédric

Options: ReplyQuote


Subject
Written By
Posted
March 26, 2011 03:37PM
March 27, 2011 07:17PM
March 28, 2011 12:26AM
Re: Charset SESSION vs GLOBAL
March 30, 2011 05:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.