Create a remote user
CREATE USER 'sammy'@'remote_server_ip' IDENTIFIED WITH mysql_native_password|caching_sha2_plugin BY 'password'; GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD on *.* TO 'sammy'@'remote_server_ip' WITH GRANT OPTION; FLUSH PRIVILEGES;
Change host for a user
UPDATE mysql.user SET Host='%' WHERE Host='localhost' AND User='username';
Show columns statement
SHOW COLUMNS FROM City;
Query for big tables
SELECT table_schema as `Database`, table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES WHERE table_schema = "my_table" ORDER BY (data_length + index_length) DESC;
Disable foreign key checks
SET foreign_key_checks = 0; SET foreign_key_checks = 1;