Início / dba / Perguntas / 35394
Accepted
xref
Asked: 2013-02-26 11:31:27 +0800 CST

MySQL 5.6 no OS X 10.8.2 desconecta na criação do usuário?

  • 772

Via Homebrew acabei de atualizar do MySQL 5.5.29 para 5.6.10 e todas as minhas consultas e usuários existentes estão funcionando bem, mas sempre que tento modificar permissões ou criar usuários agora o MySQL me desconecta. Há alguma configuração de my.cnf que preciso alterar para 5.6, ou atualizações da tabela do sistema que preciso fazer, etc.?

mysql> create user 'something'@'localhost' identified by 'password';
ERROR 2013 (HY000): Lost connection to MySQL server during query

mysql> create user 'something'@'localhost' identified by 'password';
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: *** NONE ***

ERROR 2013 (HY000): Lost connection to MySQL server during query

mysql> SHOW VARIABLES LIKE "%version%";
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: *** NONE ***

+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| innodb_version          | 1.2.10              |
| protocol_version        | 10                  |
| slave_type_conversions  |                     |
| version                 | 5.6.10              |
| version_comment         | Source distribution |
| version_compile_machine | x86_64              |
| version_compile_os      | osx10.8             |
+-------------------------+---------------------+
7 rows in set (0.00 sec)
mysql

1 respostas

  1. Best Answer

    Tudo bem, outra instância de "ler seus malditos logs" :)

    tail /usr/local/var/mysql/username.local.err me disse:

    2013-02-25 11:29:50 1616 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2013-02-25 11:29:50 1616 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2013-02-25 11:29:50 1616 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2013-02-25 11:29:50 1616 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
...

    Então, um rápido google apareceu a resposta : sudo mysql_upgrade -u root -ppass

    • 12

relate perguntas