Re: MySQL manage.py dbshell throwing error unknown variable 'character-set-server=utf8'

[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+unsubscribe@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.