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 <database-name>

SHOW TABLES

show tables;

SHOW COLUMNS;

describe <table-name>

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