SET FOREIGN_KEY_CHECKS = 0; SET GROUP_CONCAT_MAX_LEN=32768; SET @tables = NULL; SELECT GROUP_CONCAT(table_name) INTO @tables FROM information_schema.tables WHERE table_schema = (SELECT DATABASE()); SELECT IFNULL(@tables,’dummy’) INTO @tables;…
Create database mysql> CREATE DATABASE databasename; Query OK, 1 row affected (0,02 sec) Create user mysql> CREATE USER ‘abadowski’@’localhost’ IDENTIFIED BY ‘passwordname’; mysql> GRANT ALL…