Bronca GRAAAANDE mo Mysql
Pessoal,
Estou enfrentando a maior bronca aqui no meu mysql, quando o instalo, recebo os segintes erros:
[root@fred 4.1.12]# rpm -ivh MySQL-server-4.1.12-1.i386.rpm
aviso: MySQL-server-4.1.12-1.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
A preparar... ########################################### [100%]
1:MySQL-server ########################################### [100%]
050708 21:28:34 [Warning] Asked for 196608 thread stack, but got 126976
050708 21:28:34 [Warning] Can't create test file /var/lib/mysql/fred.lower-test
ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13)
ERROR: 1146 Table 'mysql.db' doesn't exist
ERROR: 1146 Table 'mysql.db' doesn't exist
ERROR: 1 Can't create/write to file './mysql/host.frm' (Errcode: 13)
ERROR: 1 Can't create/write to file './mysql/user.frm' (Errcode: 13)
ERROR: 1146 Table 'mysql.user' doesn't exist
ERROR: 1146 Table 'mysql.user' doesn't exist
ERROR: 1146 Table 'mysql.user' doesn't exist
ERROR: 1146 Table 'mysql.user' doesn't exist
ERROR: 1 Can't create/write to file './mysql/func.frm' (Errcode: 13)
ERROR: 1 Can't create/write to file './mysql/tables_priv.frm' (Errcode: 13)
ERROR: 1 Can't create/write to file './mysql/columns_priv.frm' (Errcode: 13)
ERROR: 1 Can't create/write to file './mysql/help_topic.frm' (Errcode: 13)
ERROR: 1 Can't create/write to file './mysql/help_category.frm' (Errcode: 13)
ERROR: 1 Can't create/write to file './mysql/help_relation.frm' (Errcode: 13)
ERROR: 1 Can't create/write to file './mysql/help_keyword.frm' (Errcode: 13)
ERROR: 1 Can't create/write to file './mysql/time_zone_name.frm' (Errcode: 13)
ERROR: 1 Can't create/write to file './mysql/time_zone.frm' (Errcode: 13)
ERROR: 1 Can't create/write to file './mysql/time_zone_transition.frm' (Errcode: 13)
ERROR: 1 Can't create/write to file './mysql/time_zone_transition_type.frm' (Errcode: 13)
ERROR: 1 Can't create/write to file './mysql/time_zone_leap_second.frm' (Errcode: 13)
050708 21:28:34 [Warning] Asked for 196608 thread stack, but got 126976
050708 21:28:34 [Warning] Can't create test file /var/lib/mysql/fred.lower-test
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_category' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_category' doesn't exist
ERROR: 1146 Table 'mysql.help_category' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_topic' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
ERROR: 1146 Table 'mysql.help_relation' doesn't exist
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h fred password 'new-password'
See the manual for more instructions.
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
Starting MySQL...................................[FALHOU]
[root@fred 4.1.12]#
Logado no arquivo /var/log/mysql.log
[root@fred 4.1.12]# tail -f /var/log/mysqld.log
050708 21:28:35 [Warning] Asked for 196608 thread stack, but got 126976
050708 21:28:35 [Warning] Can't create test file /var/lib/mysql/fred.lower-test
050708 21:28:35 [ERROR] Can't start server : Bind on unix socket: Permission denied
050708 21:28:35 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
050708 21:28:35 [ERROR] Aborting
050708 21:28:35 [Note] /usr/sbin/mysqld: Shutdown complete
050708 21:28:35 mysqld ended
Logado no arquivo /var/log/messages
Jul 8 21:28:34 fred kernel: audit(1120868914.306:0): avc: denied { write } for pid=5549 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99709 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=dir
Jul 8 21:28:34 fred kernel: audit(1120868914.332:0): avc: denied { write } for pid=5553 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99710 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=dir
Jul 8 21:28:34 fred kernel: audit(1120868914.353:0): avc: denied { write } for pid=5553 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99710 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=dir
Jul 8 21:28:34 fred kernel: audit(1120868914.354:0): avc: denied { write } for pid=5553 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99710 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=dir
Jul 8 21:28:34 fred kernel: audit(1120868914.370:0): avc: denied { write } for pid=5553 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99710 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=dir
Jul 8 21:28:34 fred kernel: audit(1120868914.399:0): avc: denied { write } for pid=5553 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99710 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=dir
Jul 8 21:28:34 fred kernel: audit(1120868914.400:0): avc: denied { write } for pid=5553 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99710 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=dir
Jul 8 21:28:34 fred kernel: audit(1120868914.416:0): avc: denied { write } for pid=5553 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99710 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=dir
Jul 8 21:28:34 fred kernel: audit(1120868914.455:0): avc: denied { write } for pid=5553 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99710 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=dir
Jul 8 21:28:34 fred kernel: audit(1120868914.491:0): avc: denied { write } for pid=5557 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99709 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=dir
Jul 8 21:28:35 fred kernel: audit(1120868915.405:0): avc: denied { write } for pid=5606 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99709 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=dir
Jul 8 21:28:35 fred kernel: audit(1120868915.407:0): avc: denied { write } for pid=5606 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99709 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=dir
Jul 8 21:29:11 fred lsb_log_message: failed
Bronca GRAAAANDE mo Mysql
Parece que ele esta dando erro de permissão neste diretorio /var/lib/mysql/ vc ja verificou se ele existe? se existir vc pode mover para outra pasta e veja no que dá. outra solucao seria vc da permissao total ao dir chmod 777 /var/lib/mysql/
Bronca GRAAAANDE mo Mysql
Cara ja nao tem um mysql instalado ae nao??
falows
Bronca GRAAAANDE mo Mysql
Sinceramente e o que ta parecendo !!! hehehe
Bronca GRAAAANDE mo Mysql
O diretório existia, já havia colocado a permissão total nele.
Desinnstaei o mysql, e quando instalava novamente me aparecia esse erro.
Eu deeletava o diretório, removia o usuario e grupo mysql para que o instalador os criasse, e nada feito.
Não sei o que cargas d'água aconteceu.
A solução foi reinstalar o Linux.
Ai funcionou correamente.
Bronca GRAAAANDE mo Mysql
cara quando der esse problemas da um rpm -Uvh nomedoarquivo.rpm pq ae se o arquivo ja exite ele atualiza, se nao existe ele instala
falows
Bronca GRAAAANDE mo Mysql
Meu velho.
Eu já havia tentado isso. Meu mysql era da versão 3.xx tentei atualizálo para 4.1.12 eo problema continuou.
Eu tentei de tudo.