Because every time I forget handling to set new users and Mysql account privileges, I decided to write the following example:
//create of a new Mysql database create database testdb; //set grant usage options for user grant usage on *.* to username@'%' identified by 'userpassword'; //set privileges from any hosts grant all privileges on testdb.* to username@'%' ;
Regards
Rafael Sobek
Technorati Tags: mysql create user add priviliges
Mysql New User
Blog - Programming Languages , Technologies and Visions. Topics: Visions, Architecture Issues, Programming Languages , … Read the original here: Mysql New User Tags: