package: mysql-server version: debian wheezy latest mysql-server Problem: mysql-server did not install correctly. Asked for root database password, but was not able to set it. Retried a lot, purged whole mysql: apt-get purge mysql-server, mysql-common, mysql-client, apt-get autoremove, apt-get clean . Also removed rm -rf /etc/mysql rm -rf /var/lib/mysql
I had no war relevant databases here. -- Now I reinstalled using apt-get install mysql-server, mysql-common, mysql-client Also had problems with setting the root name of database. Did it by hand mysqld -skip-auth-tables or the like using a howto on the web. Here it could not write to user.frm or name.frm or the like. then I had SUCCESS: I fixed the problem by changig the rights from root:root to see below. (please check if the rights are too generous.) The server is deployed in intranet and the users are inable to attack the IT infrastructure, so the danger is low, though) root@debian:/var/lib/mysql# cat mysql_rechte.txt total 28696 drwx------ 4 mysql root 4096 Feb 24 11:38 . drwxr-xr-x 31 root root 4096 Feb 24 11:19 .. -rw-r--r-- 1 root root 0 Feb 24 11:19 debian-5.5.flag -rw-r----- 1 mysql root 5342 Feb 24 11:38 debian.err -rw-rw---- 1 mysql mysql 18874368 Feb 24 11:38 ibdata1 -rw-rw---- 1 mysql mysql 5242880 Feb 24 11:38 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Feb 24 11:19 ib_logfile1 drwx------ 2 mysql mysql 4096 Feb 24 11:19 mysql -rw-r--r-- 1 root root 0 Feb 24 11:38 mysql_rechte1 drwx------ 2 root root 4096 Feb 24 11:19 performance_schema total 1020 drwx------ 2 mysql mysql 4096 Feb 24 11:19 . drwx------ 4 mysql root 4096 Feb 24 11:39 .. -rw-rw---- 1 root mysql 8820 Feb 24 11:19 columns_priv.frm -rw-rw---- 1 root mysql 0 Feb 24 11:19 columns_priv.MYD -rw-rw---- 1 root mysql 4096 Feb 24 11:19 columns_priv.MYI -rw-rw---- 1 root mysql 9582 Feb 24 11:19 db.frm -rw-rw---- 1 root mysql 0 Feb 24 11:19 db.MYD -rw-rw---- 1 root mysql 2048 Feb 24 11:19 db.MYI -rw-rw---- 1 root mysql 10223 Feb 24 11:19 event.frm -rw-rw---- 1 root mysql 0 Feb 24 11:19 event.MYD -rw-rw---- 1 root mysql 2048 Feb 24 11:19 event.MYI -rw-rw---- 1 root mysql 8665 Feb 24 11:19 func.frm -rw-rw---- 1 root mysql 0 Feb 24 11:19 func.MYD -rw-rw---- 1 root mysql 1024 Feb 24 11:19 func.MYI -rw-rw---- 1 root mysql 35 Feb 24 11:19 general_log.CSM -rw-rw---- 1 root mysql 0 Feb 24 11:19 general_log.CSV -rw-rw---- 1 root mysql 8776 Feb 24 11:19 general_log.frm -rw-rw---- 1 root mysql 8700 Feb 24 11:19 help_category.frm -rw-rw---- 1 root mysql 1120 Feb 24 11:19 help_category.MYD -rw-rw---- 1 root mysql 3072 Feb 24 11:19 help_category.MYI -rw-rw---- 1 root mysql 8612 Feb 24 11:19 help_keyword.frm -rw-rw---- 1 root mysql 91999 Feb 24 11:19 help_keyword.MYD -rw-rw---- 1 root mysql 17408 Feb 24 11:19 help_keyword.MYI -rw-rw---- 1 root mysql 8630 Feb 24 11:19 help_relation.frm -rw-rw---- 1 root mysql 9423 Feb 24 11:19 help_relation.MYD -rw-rw---- 1 root mysql 18432 Feb 24 11:19 help_relation.MYI -rw-rw---- 1 root mysql 8770 Feb 24 11:19 help_topic.frm -rw-rw---- 1 root mysql 466836 Feb 24 11:19 help_topic.MYD -rw-rw---- 1 root mysql 21504 Feb 24 11:19 help_topic.MYI -rw-rw---- 1 root mysql 9510 Feb 24 11:19 host.frm -rw-rw---- 1 root mysql 0 Feb 24 11:19 host.MYD -rw-rw---- 1 root mysql 2048 Feb 24 11:19 host.MYI -rw-rw---- 1 root mysql 8778 Feb 24 11:19 ndb_binlog_index.frm -rw-rw---- 1 root mysql 0 Feb 24 11:19 ndb_binlog_index.MYD -rw-rw---- 1 root mysql 1024 Feb 24 11:19 ndb_binlog_index.MYI -rw-rw---- 1 root mysql 8586 Feb 24 11:19 plugin.frm -rw-rw---- 1 root mysql 0 Feb 24 11:19 plugin.MYD -rw-rw---- 1 root mysql 1024 Feb 24 11:19 plugin.MYI -rw-rw---- 1 root mysql 9996 Feb 24 11:19 proc.frm -rw-rw---- 1 root mysql 0 Feb 24 11:19 proc.MYD -rw-rw---- 1 root mysql 2048 Feb 24 11:19 proc.MYI -rw-rw---- 1 root mysql 8875 Feb 24 11:19 procs_priv.frm -rw-rw---- 1 root mysql 0 Feb 24 11:19 procs_priv.MYD -rw-rw---- 1 root mysql 4096 Feb 24 11:19 procs_priv.MYI -rw-rw---- 1 root mysql 8800 Feb 24 11:19 proxies_priv.frm -rw-rw---- 1 root mysql 1386 Feb 24 11:19 proxies_priv.MYD -rw-rw---- 1 root mysql 5120 Feb 24 11:19 proxies_priv.MYI -rw-rw---- 1 root mysql 8838 Feb 24 11:19 servers.frm -rw-rw---- 1 root mysql 0 Feb 24 11:19 servers.MYD -rw-rw---- 1 root mysql 1024 Feb 24 11:19 servers.MYI -rw-rw---- 1 root mysql 35 Feb 24 11:19 slow_log.CSM -rw-rw---- 1 root mysql 0 Feb 24 11:19 slow_log.CSV -rw-rw---- 1 root mysql 8976 Feb 24 11:19 slow_log.frm -rw-rw---- 1 root mysql 8955 Feb 24 11:19 tables_priv.frm -rw-rw---- 1 root mysql 0 Feb 24 11:19 tables_priv.MYD -rw-rw---- 1 root mysql 4096 Feb 24 11:19 tables_priv.MYI -rw-rw---- 1 root mysql 8636 Feb 24 11:19 time_zone.frm -rw-rw---- 1 root mysql 8624 Feb 24 11:19 time_zone_leap_second.frm -rw-rw---- 1 root mysql 0 Feb 24 11:19 time_zone_leap_second.MYD -rw-rw---- 1 root mysql 1024 Feb 24 11:19 time_zone_leap_second.MYI -rw-rw---- 1 root mysql 0 Feb 24 11:19 time_zone.MYD -rw-rw---- 1 root mysql 1024 Feb 24 11:19 time_zone.MYI -rw-rw---- 1 root mysql 8606 Feb 24 11:19 time_zone_name.frm -rw-rw---- 1 root mysql 0 Feb 24 11:19 time_zone_name.MYD -rw-rw---- 1 root mysql 1024 Feb 24 11:19 time_zone_name.MYI -rw-rw---- 1 root mysql 8686 Feb 24 11:19 time_zone_transition.frm -rw-rw---- 1 root mysql 0 Feb 24 11:19 time_zone_transition.MYD -rw-rw---- 1 root mysql 1024 Feb 24 11:19 time_zone_transition.MYI -rw-rw---- 1 root mysql 8748 Feb 24 11:19 time_zone_transition_type.frm -rw-rw---- 1 root mysql 0 Feb 24 11:19 time_zone_transition_type.MYD -rw-rw---- 1 root mysql 1024 Feb 24 11:19 time_zone_transition_type.MYI -rw-rw---- 1 root mysql 10630 Feb 24 11:19 user.frm -rw-rw---- 1 root mysql 420 Feb 24 11:38 user.MYD -rw-rw---- 1 root mysql 2048 Feb 24 11:38 user.MYI I am looking forward to see a fixed mysql-server debian package. And BTW: THANKS FOR DEBIAN! KEEP UP DOING ALL THE GOOD WORK! Greetings -- Ludwig Jaffe CTO Goodster GmbH Landwehrstr. 60/62 80336 München Fon +49 (89) 41 42 43 95 Fax +49 (89) 41 42 43 955 business.goodster.eu München HRB 203 781 CEO: Andreas Eric Meyer USt.-IdNr. DE 288 495 679 Diese E-Mail kann vertrauliche und/oder rechtlich geschützte Informationen enthalten. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
