Re: how do I make utf8 the default encoding for my MySQL installation

2011-11-17 Thread Duane Hill
On Friday, November 18, 2011 at 03:31:44 UTC, martin.muel...@mac.com confabulated: > Is it possible to make utf8 the default for all databases and transactions > in a MySQL installation? > The current default is Latin1. There is a suggestion on the Web to edit > the my.cnf file as follows > [m

how do I make utf8 the default encoding for my MySQL installation

2011-11-17 Thread Martin Mueller
Is it possible to make utf8 the default for all databases and transactions in a MySQL installation? The current default is Latin1. There is a suggestion on the Web to edit the my.cnf file as follows [mysqld] init_connect=’SET collation_connection = utf8_general_ci’ init_connect=’SET NAMES utf8′

Re: Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)

2011-11-17 Thread Reindl Harald
Am 17.11.2011 15:02, schrieb Franck Houssen: > $ mysql -u dummy -p (when I hit "return" as a password => connection OK) > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > mysql> show tables; > ERROR 1046 (3D000): No database selected > mysql> quit > Bye > > $ mysql

Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)

2011-11-17 Thread Franck Houssen
Hello mysql-list, I try to install MySQL under Cygwin : I can build (mysql-5.5.17 on windows 7 using Cygwin), I can start and stop the server (only using mysqld.server - mysqladmin fails to connect). I can not connect to the server when I want to use a password (if I don't use any password