On Sunday, 25 August 2013, Brian Lee wrote: > [client] > 20 port = 3306 > 21 socket = /var/run/mysqld/mysqld.sock > 22 > 23 # Here is entries for some specific programs > 24 # The following values assume you have at least 32M ram > 25 > 26 # This was formally known as [safe_mysqld]. Both versions are > currently pars ed. > 27 [mysqld_safe] > 28 socket = /var/run/mysqld/mysqld.sock > 29 nice = 0 > 30 > 31 [mysqld] > 32 # > 33 # * Basic Settings > 34 # > 35 character-set-server=utf8 > 36 default-collation=utf8_unicode_ci > 44 user = mysql > 45 socket = /var/run/mysqld/mysqld.sock > 46 port = 3306 > 47 basedir = /usr > 48 datadir = /var/lib/mysql > 49 tmpdir = /tmp > 50 skip-external-locking > 51 # > 52 # Instead of skip-networking the default is now to listen only on > 53 # localhost which is more compatible and is not less secure. > 54 #bind-address = 127.0.0.1 > 55 bind-address = 199.167.196.137 > 56 > 57 # > 58 # * Fine Tuning > 59 # > 60 key_buffer = 16M 61 max_allowed_packet = 16M > 62 thread_stack = 192K > 63 thread_cache_size = 8 > 64 # This replaces the startup script and checks MyISAM tables if needed > 65 # the first time they are touched > 66 myisam-recover = BACKUP > 67 #max_connections = 100 > 68 #table_cache = 64 > 69 #thread_concurrency = 10 > 70 # > 71 # * Query Cache Configuration > 72 # > 73 query_cache_limit = 1M > 74 query_cache_size = 16M > 81 #general_log_file = /var/log/mysql/mysql.log > 82 #general_log = 1 > 83 > 84 log_error = /var/log/mysql/error.log > 86 # Here you can see queries with especially long duration > 87 #log_slow_queries = /var/log/mysql/mysql-slow.log > 88 #long_query_time = 2 > 89 #log-queries-not-using-indexes > 90 # > 91 # The following can be used as easy to replay backup logs or for > replication . > 92 # note: if you are setting up a replication slave, see README.Debian > about > 93 # other settings you may need to change. > 94 #server-id = 1 > 95 #log_bin = /var/log/mysql/mysql-bin.log > 96 expire_logs_days = 10 > 97 max_binlog_size = 100M > 98 #binlog_do_db = include_database_name > 99 #binlog_ignore_db = include_database_name > 119 [mysqldump] > 120 quick > 121 quote-names > 122 max_allowed_packet = 16M > 123 > 124 [mysql] > 125 #no-auto-rehash # faster start of mysql but no tab completition > 126 character-set-server=utf8 > 127 default-collation=utf8_unicode_ci > 128 > 129 [isamchk] > 130 key_buffer = 16M > 131 > 132 # > 133 # * IMPORTANT: Additional settings that can override those from this > file! > 134 # The files must end with '.cnf', otherwise they'll be ignored. > 135 # > 136 !includedir /etc/mysql/conf.d/ # only contains [mysqld_safe]; syslog >
I think you only want character-set-server in the mysqld section, and not also in the mysql section. However, I really know almost nothing about MySQL, so you might be better off asking in that community rather than here. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-users. For more options, visit https://groups.google.com/groups/opt_out.
