create user dbuser@localhost identified by 'dbpassword'; create database IF NOT EXISTS dbname; grant all privileges on dbname.* to dbuser@localhost; User read only CREATE USER dbuser@localhost IDENTIFIED BY 'dbpassword'; GRANT SELECT ON *.* TO dbuser@localhost