Common MySQL Queries

Updating User Credentials:

UPDATE user SET Host = '132.235.63.115' WHERE Host = '132.235.63.23';

 GRANT ALL PRIVILEGES ON p2p.* TO 'web'@'132.235.8.%' IDENTIFIED BY 'SOMEPASS' WITH GRANT OPTION;

 UPDATE mysql.user SET Password=PASSWORD('SOMPASS') WHERE User='web';
 UPDATE user SET password = '5a5fe3017692a028' WHERE user = 'web';

SELECT * FROM MASTER47_DESCRIPTIONS WHERE mrID = 30027;

Redacting data

SELECT * FROM MASTER47_DESCRIPTIONS WHERE mrID = 14448;

UPDATE MASTER47_DESCRIPTIONS SET `mrDESCRIPTION` = replace(`mrDESCRIPTION`, "2222-2222-2222-2222", "REDACTED") WHERE mrID = 14448;

Updates

UPDATE `openfire`.`ofProperty` SET propValue = "ou=people;dc=ohio,dc=edu" WHERE name = "ldap.baseDN";



Comments