[debian-mysql] Bug#739970: MYSQL-SERVER bug while installing. Debian wheezy newest mysql server
Ludwig Jaffe
jaffe at goodster.eu
Mon Feb 24 13:27:54 UTC 2014
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 at 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.
More information about the pkg-mysql-maint
mailing list