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 django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users. For more options, visit https://groups.google.com/groups/opt_out.
