You will be be redirected to the blog in a moment...

Or you can click the link below to proceed:
MySQL: Quick Create of User and Database of Same Name

Here is the necessary sql to create a user and database of the same name. Note to my future self.CREATE USER 'username'@'%' IDENTIFIED BY 'password';GRANT USAGE ON * . * TO 'username'@'%' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_ HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;CREATE DATABASE IF NOT EXISTS `username` ;GRANT ALL PRIVILEGES ON `username` ...

 

Want to be redirected immediately?
Register yourself at Ping.sg to get rid of this page and also to get your read counted as Pong.