CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'password';
	

			
	
			

		
	

	GRANT ALL ON *.* TO 'dbuser'@'localhost' WITH GRANT OPTION;
	

			
	
			

		
	

	ALTER USER 'dbuser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
	

			
	
			

		
	

	flush privileges;
	

			
	
			

		
	

	create database dbname;
	

			
	
			

		
	

	GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';
	

			
	
			

		
	

	mysql://<username>:<password>@<host>:<port>/<db_name>
	

			
	
			

		
	

	SELECT TABLE_NAME, COLUMN_NAME,  CONSTRAINT_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_NAME = 'table' group by constraint_name;
	

			
	
			

		
	

	
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE table1;
SET FOREIGN_KEY_CHECKS = 1;```