Re: Any one can drop a table or database

2003-12-21 Thread plutoplanet
> I am new to mysql. I have installed, created a database and also some created tables. Now any one who can login to the host are able to drop the table or also the database. How do I protect it? You should read this: http://www.mysql.com/doc/en/User_Account_Management.html or maybe install phpmya

Why do indices crash

2003-10-28 Thread plutoplanet
Hi can anybody tell me the most common reason WHY an index file get's corrupted? I have tested this on differernt versions of MySQL (3.23.37 - 4.1) on Linux and on Windows. It happens on tables containing A MEDIUMTEXT or LONGTEXT column, A fulltext index on these columns I am mostly work