On 17/10/13 12:34, Fabián Bonetti wrote:
On Thu, 17 Oct 2013 11:26:52 -0300 tq<[email protected]> wrote:Aquí tengo algo para hacerlo en la consola de tu MySQL Crear user: CREATE USER usuario1 IDENTIFIED BY 'password'; Crear bd: CREATE DATABASE nombre_de_la_base_de_datos; Privilegios user: GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON nombre_de_la_base_de_datos.* TO usuario1@"%" IDENTIFIED BY 'password' WITH GRANT OPTION; Privilegios admin: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES ON nombre_de_la_base_de_datos.* TO usuario1@"%" IDENTIFIED BY 'password' WITH GRANT OPTION; Borrar privilegios: REVOKE SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON nombre_de_la_base_de_datos.* FROM usuario1; Borrar user: DROP USER usuario1; Editar pass: UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='usuario1'; FLUSH PRIVILEGES; Espero te allá servido, saludos.
Gracias Fabian! Saludos. -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected] Archive: http://lists.debian.org/[email protected]
