[EMAIL PROTECTED] wrote:
Dear All,
Still this time I used MySQL 4.0.15 and now I have installed the
4.1.2-alpha. it OR WITH ME. Can anybody help me to solve I have 3 problems with 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.
The password mechanism changed starting with 4.1 to one that is more secure. Unfortunately, that means that clients built with earlier versions of the mysql library don't know how to authenticate. See the manual for an explanation <http://dev.mysql.com/doc/mysql/en/Password_hashing.html> and workarounds <http://dev.mysql.com/doc/mysql/en/Old_client.html>.
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.
I don't believe you can revoke a column privilege unless you've first granted a column privilege, so I would not expect granting select on a table and then revoking all on a column of that table to work. In fact, I'd expect an error message like "ERROR 1147: There is no such grant defined for user ...".
I would expect the second way, revoking all and granting on specific columns to work. What, exactly, do you mean by "can't see the operator table"?
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
I don't know. What type of tables are they (MyISAM, InnoDB,...)?
Thanks in advance,
Best regards,
Gabor Kozari
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]