Generic mysql database creation

 GRANT USAGE ON *.* TO database_a;  
 DROP USER database_a;  
 CREATE USER database_a IDENTIFIED BY 'password';  
 DROP DATABASE IF EXISTS database;  
 CREATE DATABASE database COLLATE utf8_general_ci;  
 GRANT ALL PRIVILEGES ON database.* TO database_a IDENTIFIED BY 'password';  
 FLUSH PRIVILEGES;  
 USE database;  

How to obtain next id in mysql

SELECT Auto_increment FROM information_schema.tables WHERE table_name='the_table_you_want';