Tuesday 11 March 2014

adding a data base to putty mysql

login putty
type mysql

type
create database typedatabasenamehere;
 
should say : Query OK, 1 row affected (0.16 sec)
 
 
add: 
grant all privileges on typedatabasenamehere.* to 'typeusernamehere'@'localhost' identified by "typepasswordhere"; 


should say : Query OK, 1 row affected (0.16 sec)
 
add: 
flush privileges;
 
 
add:
exit; 

No comments:

Post a Comment