Preguntas sobre mysql

[xin]

hola a todos... alguien que sepa sobre mysql version 6.0.4-alpha....

¿como darle privilegios a un suario ya creado???
me podrian decir la sintaxis plissss. es urgenteeee....

[baduser]

Bienvenida XIN, Es con el comando GRANT, al igual que Oracle y Sql, aqui la muestra:

GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ... ON [object_type] {tbl_name | * | *.* | db_name.*} TO user [IDENTIFIED BY [PASSWORD] 'password'] [, user [IDENTIFIED BY [PASSWORD] 'password']] ... [REQUIRE NONE | [{SSL| X509}] [CIPHER 'cipher' [AND]] [ISSUER 'issuer' [AND]] [SUBJECT 'subject']] [WITH with_option [with_option] ...] object_type = TABLE | FUNCTION | PROCEDURE with_option = GRANT OPTION | MAX_QUERIES_PER_HOUR count | MAX_UPDATES_PER_HOUR count | MAX_CONNECTIONS_PER_HOUR count | MAX_USER_CONNECTIONS count REVOKE priv_type [(column_list)] [, priv_type [(column_list)]] ... ON [object_type] {tbl_name | * | *.* | db_name.*} FROM user [, user] ... REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ...

tambien visita esto:

http://dev.mysql.com/doc/refman/5.0/es/grant.html
http://mysql.conclase.net/curso/?cap=013
http://www.webtaller.com/construccio...s_en_mysql.php
http://www.programacionweb.net/foros/mensaje/?num=14433


salu2