_HiStOrY_V2_
show\040databases;
SELECT\040user\040FROM\040mysql.user;
exit;
CREATE\040USER\040'contr370_mipfor'@'localhost'\040IDENTIFIED\040BY\040'mipfor@2023';
GRANT\040ALL\040PRIVILEGES\040ON\040*.*\040TO\040'contr370_mipfor'@'localhost'\040WITH\040GRANT\040OPTION;
CREATE\040DATABASE\040contr370_controlfor;
GRANT\040ALL\040PRIVILEGES\040ON\040contr370_controlfor.*\040TO\040'contr370_mipfor'@'localhost';
FLUSH\040PRIVILEGES;
GRANT\040ALL\040PRIVILEGES\040ON\040*.*\040TO\040'phpmyadmin'@'localhost'\040WITH\040GRANT\040OPTION;
CREATE\040DATABASE\040contr370_alterosa;
GRANT\040ALL\040PRIVILEGES\040ON\040*.*\040TO\040'controlfor'@'179.108.11.93'\040IDENTIFIED\040BY\040'(gv+MrpH}EG8';
SHOW\040GRANTS\040FOR\040'controlfor'@'179.108.11.93';
GRANT\040ALL\040PRIVILEGES\040ON\040nome_do_banco.*\040TO\040'laravel_user'@'SEU_IP_DA_VPS'\040IDENTIFIED\040BY\040'sua_senha';
FLUSH\040PRIVILEGES;
SELECT\040user,\040host\040FROM\040mysql.user;
DROP\040USER\040'laravel_user'@'host';
DROP\040USER\040'laravel_user'@'localhost';
SELECT\040user,\040host\040FROM\040mysql.user;
esse\040usuario\040que\040acabei\040de\040criar,\040criei\040errado
DROP\040USER\040'laravel_user'@'localhost';
esse\040usuario\040que\040acabei\040de\040criar,\040criei\040errado\040DROP\040USER\040'laravel_user'@'localhost';
SELECT\040user,\040host\040FROM\040mysql.user;
DROP\040USER\040'laravel_user'@'%';
DROP\040USER\040'laravel_user'@'localhost';
DROP\040USER\040'laravel_user'@'seu_ip_da_vps';
SELECT\040user,\040host\040FROM\040mysql.user;
GRANT\040ALL\040PRIVILEGES\040ON\040contr370_alterosa.*\040TO\040'laravel_user'@'85.209.92.22'\040IDENTIFIED\040BY\040'(gv+MrpH}EG8';
SELECT\040user,\040host\040FROM\040mysql.user;
FLUSH\040PRIVILEGES;
SELECT\040user,\040host\040FROM\040mysql.user;
CREATE\040USER\040'contr370'@'localhost'\040IDENTIFIED\040BY\040'(gv+MrpH}EG8';
FLUSH\040PRIVILEGES;
SELECT\040user,\040host\040FROM\040mysql.user;
SHOW\040GRANTS\040FOR\040'controlfor'@'179.108.11.93';
SELECT\040ROUTINE_NAME,\040ROUTINE_SCHEMA,\040DEFINER
FROM\040INFORMATION_SCHEMA.ROUTINES
WHERE\040ROUTINE_SCHEMA\040=\040'contr370_alterosa';
SELECT\040ROUTINE_NAME,\040ROUTINE_SCHEMA,\040DEFINER\040FROM\040INFORMATION_SCHEMA.ROUTINES\040WHERE\040ROUTINE_SCHEMA\040=\040'contr370_alterosa';
SELECT\040user,\040host\040FROM\040mysql.user;
DROP\040USER\040'controlfor'@'179.108.11.93';
DROP\040USER\040'laravel_user'@'85.209.92.22';
DROP\040USER\040'contr370'@'localhost';
DROP\040USER\040'contr370_mipfor'@'localhost';
DROP\040USER\040IF\040EXISTS\040'controlfor'@'179.108.11.93';
DROP\040USER\040IF\040EXISTS\040'laravel_user'@'85.209.92.22';
DROP\040USER\040IF\040EXISTS\040'contr370'@'localhost';
DROP\040USER\040IF\040EXISTS\040'contr370_mipfor'@'localhost';
FLUSH\040PRIVILEGES;
SELECT\040user,\040host\040FROM\040mysql.user;
agora\040que\040criar\040um\040usuario\040que\040tenha\040acesso\040total\040ao\040banco\040contr370_alterosa\040e\040pode\040acessar\040as\040procedure\040conforme\040esta\040no\040esquema,\040o\040usuario\040vai\040chamar\040ontr370_mipfor\040e\040a\040senha\040vai\040ser\040(gv+MrpH}EG8
CREATE\040USER\040'contr370_mipfor'@'%'\040IDENTIFIED\040BY\040'(gv+MrpH}EG8';
GRANT\040ALL\040PRIVILEGES\040ON\040contr370_alterosa.*\040TO\040'contr370_mipfor'@'%';
GRANT\040EXECUTE\040ON\040PROCEDURE\040contr370_alterosa.*\040TO\040'contr370_mipfor'@'%';
GRANT\040EXECUTE\040ON\040FUNCTION\040contr370_alterosa.*\040TO\040'contr370_mipfor'@'%';
FLUSH\040PRIVILEGES;
GRANT\040EXECUTE\040ON\040PROCEDURE\040contr370_alterosa.*\040TO\040'contr370_mipfor'@'%';
GRANT\040ALL\040PRIVILEGES\040ON\040contr370_alterosa.*\040TO\040'contr370_mipfor'@'%';
FLUSH\040PRIVILEGES;
SELECT\040user,\040host\040FROM\040mysql.user;
exir
exit
SHOW\040DATABASES;
SELECT\040user,\040host\040FROM\040mysql.user;
SHOW\040DATABASES;
SELECT\040user,\040host\040FROM\040mysql.user;
CREATE\040DATABASE\040novo_nome_banco;
CREATE\040DATABASE\040contr370_controlfor;
SHOW\040DATABASES;
GRANT\040ALL\040PRIVILEGES\040ON\040contr370_controlfor.*\040TO\040'contr370_mipfor'@'%'\040IDENTIFIED\040BY\040'(gv+MrpH}EG8';
FLUSH\040PRIVILEGES;
USE\040contr370_controlfor;
SELECT\040COUNT(*)\040AS\040numero_de_tabelas\040
FROM\040information_schema.tables\040
WHERE\040table_schema\040=\040'contr370_controlfor';
SELECT\040COUNT(*)\040AS\040numero_de_tabelas\040\040FROM\040information_schema.tables\040\040WHERE\040table_schema\040=\040'contr370_controlfor';
USE\040contr370_alterosa;
SELECT\040COUNT(*)\040AS\040numero_de_tabelas\040
FROM\040information_schema.tables\040
WHERE\040table_schema\040=\040'contr370_controlfor';
SELECT\040COUNT(*)\040AS\040numero_de_tabelas\040\040FROM\040information_schema.tables\040\040WHERE\040table_schema\040=\040'contr370_controlfor';
mysqldump\040-u\040contr370_mipfor\040-p\040--routines\040--no-create-info\040--no-data\040--no-create-db\040--skip-triggers\040contr370_alterosa\040>\040alterosa_objects.sql
(gv+MrpH}EG8
mysqldump\040-u\040contr370_mipfor\040-p\040--routines\040--no-create-info\040--no-data\040--no-create-db\040--skip-triggers\040contr370_alterosa\040>\040alterosa_objects.sql
exit
yes
exit
USE\040contr370_controlfor;
SELECT\040COUNT(*)\040AS\040numero_de_tabelas\040
FROM\040information_schema.tables\040
WHERE\040table_schema\040=\040'contr370_controlfor'\040AND\040table_type\040=\040'BASE\040TABLE';
SELECT\040COUNT(*)\040AS\040numero_de_tabelas\040\040FROM\040information_schema.tables\040\040WHERE\040table_schema\040=\040'contr370_controlfor'\040AND\040table_type\040=\040'BASE\040TABLE';
SELECT\040COUNT(*)\040AS\040numero_de_procedures\040
FROM\040information_schema.routines\040
WHERE\040routine_schema\040=\040''contr370_controlfor\040'\040AND\040routine_type\040=\040'PROCEDURE';
WHERE\040routine_schema\040=\040'contr370_controlfor'\040AND\040routine_type\040=\040'PROCEDURE';
SELECT\040COUNT(*)\040AS\040numero_de_procedures\040
FROM\040information_schema.routines\040
WHERE\040routine_schema\040=\040''contr370_controlfor\040'\040AND\040routine_type\040=\040'PROCEDURE';
SELECT\040COUNT(*)\040AS\040numero_de_procedures\040\040FROM\040information_schema.routines\040\040WHERE\040routine_schema\040=\040''contr370_controlfor\040'\040AND\040routine_type\040=\040'PROCEDURE';\012\012WHERE\040routine_schema\040=\040'contr370_controlfor'\040AND\040routine_type\040=\040'PROCEDURE';\012SELECT\040COUNT(*)\040AS\040numero_de_procedures\040\012FROM\040information_schema.routines\040\012WHERE\040routine_schema\040=\040''contr370_controlfor\040'\040AND\040routine_type\040=\040'PROCEDURE';
SELECT\040COUNT(*)\040AS\040numero_de_procedures\040FROM\040information_schema.routines\040\040WHERE\040routine_schema\040=\040'contr370_controlfor'\040AND\040routine_type\040=\040'PROCEDURE';
use\040contr370_alterosa
SELECT\040COUNT(*)\040AS\040numero_de_procedures\040FROM\040information_schema.routines\040\040WHERE\040routine_schema\040=\040'contr370_controlfor'\040AND\040routine_type\040=\040'PROCEDURE';
SELECT\040COUNT(*)\040AS\040numero_de_procedures\040FROM\040information_schema.routines\040\040WHERE\040routine_schema\040=\040'contr370_alterosa'\040AND\040routine_type\040=\040'PROCEDURE';
CREATE\040DATABASE\040contr370_arcelor;
GRANT\040ALL\040PRIVILEGES\040ON\040contr370_controlfor.*\040TO\040'contr370_mipfor'@'%'\040IDENTIFIED\040BY\040'(gv+MrpH}EG8';
FLUSH\040PRIVILEGES;
GRANT\040ALL\040PRIVILEGES\040ON\040contr370_arcelor.*\040TO\040'contr370_mipfor'@'%'\040IDENTIFIED\040BY\040'(gv+MrpH}EG8';
FLUSH\040PRIVILEGES;
show\040tables;
SHOW\040DATABASES;
CREATE\040DATABASE\040contr370_cmpc;
GRANT\040ALL\040PRIVILEGES\040ON\040contr370_cmpc.*\040TO\040'contr370_mipfor'@'%'\040IDENTIFIED\040BY\040'(gv+MrpH}EG8';
FLUSH\040PRIVILEGES;
CREATE\040DATABASE\040contr370_cmpc_old;
GRANT\040ALL\040PRIVILEGES\040ON\040contr370_cmpc_old.*\040TO\040'contr370_mipfor'@'%'\040IDENTIFIED\040BY\040'(gv+MrpH}EG8';
FLUSH\040PRIVILEGES;
CREATE\040DATABASE\040contr370_eucatex;
GRANT\040ALL\040PRIVILEGES\040ON\040contr370_eucatex.*\040TO\040'contr370_mipfor'@'%'\040IDENTIFIED\040BY\040'(gv+MrpH}EG8';
FLUSH\040PRIVILEGES;
CREATE\040DATABASE\040contr370_gerdau;
GRANT\040ALL\040PRIVILEGES\040ON\040contr370_gerdau.*\040TO\040'contr370_mipfor'@'%'\040IDENTIFIED\040BY\040'(gv+MrpH}EG8';
FLUSH\040PRIVILEGES;
CREATE\040DATABASE\040contr370_norflor;
GRANT\040ALL\040PRIVILEGES\040ON\040contr370_norflor.*\040TO\040'contr370_mipfor'@'%'\040IDENTIFIED\040BY\040'(gv+MrpH}EG8';
FLUSH\040PRIVILEGES;
CREATE\040DATABASE\040contr370_sadabio;
GRANT\040ALL\040PRIVILEGES\040ON\040contr370_sadabio.*\040TO\040'contr370_mipfor'@'%'\040IDENTIFIED\040BY\040'(gv+MrpH}EG8';
FLUSH\040PRIVILEGES;
CREATE\040DATABASE\040contr370_ttgbrasilms;
GRANT\040ALL\040PRIVILEGES\040ON\040contr370_ttgbrasilms.*\040TO\040'contr370_mipfor'@'%'\040IDENTIFIED\040BY\040'(gv+MrpH}EG8';
FLUSH\040PRIVILEGES;
SHOW\040DATABASES;
SHOW\040VARIABLES\040LIKE\040'collation%';
SET\040collation_connection\040=\040'utf8mb4_general_ci';
ALTER\040DATABASE\040contr370_controlfor\040CHARACTER\040SET\040utf8\040COLLATE\040utf8_unicode_ci;
SHOW\040VARIABLES\040LIKE\040'collation%';
ALTER\040DATABASE\040contr370_controlfor\040CHARACTER\040SET\040utf8mb4_general_ci\040COLLATE\040utf8_unicode_ci;
SHOW\040VARIABLES\040LIKE\040'collation%';
cd\040/
GRANT\040FILE\040ON\040*.*\040TO\040'contr370_mipfor'@'%';
FLUSH\040PRIVILEGES;
SHOW\040GRANTS\040FOR\040'contr370_mipfor'@'%';
SHOW\040GLOBAL\040VARIABLES\040LIKE\040'local_infile';
show\040tables
show\040databases
SHOW\040TABLES;
show\040tables\040\040\040show\040databases\040\040\040SHOW\040TABLES;
SHOW\040databases;
SELECT\040VERSION();
CREATE\040DATABASE\040swcomp47_sincwebdb;
SHOW\040DATABASES;
CREATE\040USER\040'swcomp47_sincwebdb'@'localhost'\040IDENTIFIED\040BY\040'bd03052018!.';
GRANT\040ALL\040PRIVILEGES\040ON\040swcomp47_sincwebdb.*\040TO\040'swcomp47_sincwebdb'@'localhost';
CREATE\040USER\040'swcomp47_sincwebdb'@'localhost'\040IDENTIFIED\040BY\040'bd03052018!.';
GRANT\040ALL\040PRIVILEGES\040ON\040swcomp47_sincwebdb.*\040TO\040'swcomp47_sincwebdb'@'localhost';
FLUSH\040PRIVILEGES;
SELECT\040User,\040Host\040FROM\040mysql.user\040WHERE\040User='swcomp47_sincwebdb';
DROP\040USER\040IF\040EXISTS\040'swcomp47_SincWeb'@'%';
DROP\040USER\040IF\040EXISTS\040'swcomp47_SincWeb'@'localhost';
CREATE\040USER\040'swcomp47_SincWeb'@'%'\040IDENTIFIED\040BY\040'bd03052018!.';
GRANT\040ALL\040PRIVILEGES\040ON\040swcomp47_sincwebdb.*\040TO\040'swcomp47_SincWeb'@'%';
GRANT\040ALL\040PRIVILEGES\040ON\040swcomp47_SincWeb.*\040TO\040'swcomp47_SincWeb'@'%';
FLUSH\040PRIVILEGES;
SELECT\040User,\040Host\040FROM\040mysql.user\040WHERE\040User='swcomp47_SincWeb';
systemctl\040restart\040mysql
exit
SELECT\040User,\040Host\040FROM\040mysql.user
SELECT\040User,\040Host\040FROM\040mysql.user\040WHERE\040User='swcomp47_SincWeb';
SELECT\040User,\040Host\040FROM\040mysql.user;
DROP\040USER\040'swcomp47_sincwebdb'@'%';
SELECT\040User,\040Host\040FROM\040mysql.user\040WHERE\040User='swcomp47_sincwebdb';
SELECT\040User,\040Host\040FROM\040mysql.user;
GRANT\040ALL\040PRIVILEGES\040ON\040swcomp47_sincwebdb.*\040TO\040'swcomp47_SincWeb'@'%';
FLUSH\040PRIVILEGES;
SHOW\040GRANTS\040FOR\040'swcomp47_SincWeb'@'%';
SHOW\040DATABASES;
GRANT\040ALL\040PRIVILEGES\040ON\040swcomp47_sincwebdb.*\040TO\040'contr370_mipfor'@'%';
FLUSH\040PRIVILEGES;
SHOW\040GRANTS\040FOR\040'contr370_mipfor'@'%';
mysql\040-h\040162.241.2.67\040-u\040swcomp47_SincWeb\040-p'bd03052018!.'\040swcomp47_sincwebdb\040-e\040"SHOW\040TABLES;"
SHOW\040DATABASES;