Skip to content

MySQL Chuleta.sql

Pierre Germain edited this page May 11, 2017 · 6 revisions

CONECTARSE CON USUARIO ROOT

mysql -u root -p

#COMPROBACIÓN USUARIOS

use mysql SELECT host, user, password FROM user;

#SHOW DATABASES

show databases;

#USE DATABASE

use

#SHOW TABLES

show tables;

#SHOW COLUMNS;

describe

#ANULAR COMMAND (CLEAR)

\c select * from users\c

#PRINT COMMAND

\p select * from users\p

#GET HELP

\h

#CREATE USER:

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON databaseName . databaseTable TO 'newuser'@'localhost'; GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

#Crear Contraseñas

Después de Mysql 5.7.6

ALTER USER 'jeffrey'@'localhost' IDENTIFIED BY 'newPassword' PASSWORD EXPIRE NEVER;

Antes de Mysql 5.7.6

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('nuevaContraseña');

#RELOAD PRIV'S:

FLUSH PRIVILEGES;

Clone this wiki locally