MySQL Script

#Create Database
CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;
#Create New User
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
#Set Permission
GRANT ALL PRIVILEGES ON mydatabase. * TO 'newuser'@'localhost';
#Refresh Privileges
FLUSH PRIVILEGES;

By Ray Lee (System Analyst)

iDempeire ERP Contributor, 經濟部中小企業處財務管理顧問 李寶瑞

Leave a Reply

Your email address will not be published. Required fields are marked *