Dear All, Still this time I used MySQL 4.0.15 and now I have installed the 4.1.2-alpha. I have 3 problems with it OR WITH ME. Can anybody help me to solve them?
1. I can't set password for users. If I set password I can't login into database, I get the next message: '1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client' If password is empty then I can login. I have already tried to run mysql_fix_privilege_tables.sql script, but it doesn't help. 2. I read in manual there is possibility to set privileges for column in a table. There is a salary column in operators table, which should be hidden for a simply user. If I set select privilege for operators table then I see all columns in spite of revoking all privilege at salary column. But if I revoke all from operators table and set select to the other columns, I can't see the operator table. I hope you can understand it. I use MySQL Front 2.4, but I tried 3.1 too. 3. When I use the next multi-delete query I see it deletes data only from od and dd tables. Why doesn't it delete from pd table? DELETE pd, od, dd FROM prod_data as pd left join operator_data as od on pd.id=od.pd_id left join downtime_data as dd on pd.id=dd.pd_id WHERE pd.id=16 Thanks in advance, Best regards, Gabor Kozari