You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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');