Como criar view no mySQL 4?

eu tento:

CREATE
VIEW alexsand_photoflux.teste
AS
(SELECT * FROM cad_user);
e me da o segunte erro

Error Code : 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VIEW alexsand_photoflux.teste

AS

(SELECT * FROM cad_user)' at line 2

(0 ms taken)

o que pode ser?