关于安装jumpserver跳板机报错的问题解决

[root@localhost install]# python install.py

django.db.utils.OperationalError: (1366, "Incorrect string value: '\\xE6\\x9C\\xBA\\xE6\\x88\\xBF' for column 'name' at row 1")

[[email protected] ~]# cat /etc/my.cnf  

[mysqld]

.......

#在mysqld模块下增加以下两个参数

character_set_server=utf8    

init_connect='SET NAMES utf8'

[root@localhost ~]# /etc/init.d/mysqld restart

注意：新版MySQL(如：5.5）或MariaDB等，mysqld启动时可能会遇到“[ERROR] /usr/libexec/mysqld: unknown variable         ‘default_character_set=utf8’”的错误；就应该在[mysqld]中用 character_set_server=utf8 替换掉 default_character_set=utf8

2.删除原来创建的jumpsrvice问题数据库

3.再打开mysql数据库创建django连接的数据库

[root@localhost ~]# mysql -uxxxx -pxxxxxx

    mysql> show variables like'character%';    //运行这语句查看一下character_set_database参数是否utf8

    mysql> set character_set_database=utf8;    //如果不是utf8，运行此语句设置一下

    +--------------------------+----------------------------------+

    | Variable_name            | Value                            |

    +--------------------------+----------------------------------+

    | character_set_client     | utf8                             |

    | character_set_connection | utf8                             |

    | character_set_database   | utf8                             |

    | character_set_filesystem | binary                           |

    | character_set_results    | utf8                             |

    | character_set_server     | utf8                             |

    | character_set_system     | utf8                             |

    | character_sets_dir       | /usr/local/mysql/share/charsets/ |

    +--------------------------+----------------------------------+

    mysql> create database jumpservice;    //之后就可以正常创建jumpservice数据库了

    Query OK, 1 row affected (0.00 sec)

4.[[email protected] install]# python install.py    //重新执行命令即可安装成功

> create database jumpserver;

> grant all on jumpserver.* to 'jumpserver'@'127.0.0.1' identified by 'asd9577';