[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
On Saturday, August 24, 2013 7:06:28 PM UTC-4, tom wrote: > > On Saturday, 24 August 2013, Brian Lee wrote: > >> So, my website, involving lots of database calls, works perfectly fine, >> even after a reboot. >> >> However, attempting to connect directly via dbshell results in this >> error: >> $ ./manage.py dbshell >> mysql: unknown variable 'character-set-server=utf8' >> >> Attempting to figure out my version of mysql also gave the same error. >> $ mysql --version >> mysql: unknown variable 'character-set-server=utf8' >> > > I suspect that this is actually a MySQL configuration issue, rather than a > Django issue, but could you post the contents of your my.cnf file? > -- 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.