[Bug 221188] New: MySQL shows "tmp" as database and allows deletion
https://bugzilla.novell.com/show_bug.cgi?id=221188 Summary: MySQL shows "tmp" as database and allows deletion Product: openSUSE 10.2 Version: Beta 2 Platform: Other OS/Version: Other Status: NEW Severity: Major Priority: P5 - None Component: Basesystem AssignedTo: mmarek@novell.com ReportedBy: suse-beta@cboltz.de QAContact: qa@suse.de MySQL shows the tempdir /var/lib/mysql/tmp as database (without any tables) and allows to delete it with "DROP DATABASE tmp" - which can cause several problems because of the missing tempdir. "tmp" should be filtered out from the SHOW DATABASES output. Better alternative: move the directory to another place as the databases. (This bugreport is also valid for 10.1, I didn't test older versions.) -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug, or are watching someone who is.
https://bugzilla.novell.com/show_bug.cgi?id=221188 mmarek@novell.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED ------- Comment #1 from mmarek@novell.com 2006-11-15 03:31 MST ------- Yes, I'm avare of it. A solution would be to rename it to .tpm or somethink like that ('.' is not allowed in database names). -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug, or are watching someone who is.
https://bugzilla.novell.com/show_bug.cgi?id=221188 ------- Comment #2 from mmarek@novell.com 2006-11-15 03:32 MST ------- OTOH only root can drop it. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug, or are watching someone who is.
https://bugzilla.novell.com/show_bug.cgi?id=221188 ------- Comment #3 from suse-beta@cboltz.de 2006-11-15 10:54 MST ------- (In reply to comment #2)
OTOH only root can drop it.
Of course - but when someone is wondering what this strange "tmp" database is for, chances are good that he will DROP it. You know Murphy? ;-) Anyway, according to opensuse-commit, this bug should be fixed. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug, or are watching someone who is.
https://bugzilla.novell.com/show_bug.cgi?id=221188 mmarek@novell.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED ------- Comment #4 from mmarek@novell.com 2006-11-15 12:13 MST ------- ;-) yes, it's fixed. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug, or are watching someone who is.
https://bugzilla.novell.com/show_bug.cgi?id=221188 suse-beta@cboltz.de changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |VERIFIED ------- Comment #5 from suse-beta@cboltz.de 2006-11-26 06:54 MST ------- VERIFIED in RC1. TMPDIR is now /var/lib/mysql/.tmp which is not shown in "show databases" output. Thanks for fixing! -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug, or are watching someone who is.
https://bugzilla.novell.com/show_bug.cgi?id=221188 ------- Comment #6 from mmarek@novell.com 2007-01-08 01:39 MST ------- Also fixed for sles10-sp1. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug, or are watching someone who is.
participants (1)
-
bugzilla_noreply＠novell.com