MySQL new user SQL statements
A quick and dirty explanation to create a new MySQL datbase with a user Create the user: CREATE USER ‘hibtest’@’localhost’ IDENTIFIED BY ‘*******’; Set some permissions: GRANT USAGE ON * . * TO ‘hibtest’@’localhost’ IDENTIFIED BY ‘*******’ WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0MAX_USER_CONNECTIONS 0 ; Create the database: CREATE DATABASE IF NOT EXISTS `hibtest`… Continue reading “MySQL new user SQL statements”