Results 1 to 7 of 7
Thread: Error problems
Nov 26, 2012, 11:38 #1
- Join Date
- Nov 2012
- 0 Post(s)
- 0 Thread(s)
Hello, I have only just started using mysql. I created a database and named it "databasename" and my username is "marcus". I have given my database all the privileges. I copy and pasted this code below into my database from a tutorial i read.
CREATE TABLE `databasename`.`users` (`id` INT(11) NOT NULL AUTO_INCREMENT,
`username` VARCHAR(300) NOT NULL, `password` VARCHAR(300) NOT NULL, PRIMARY KEY (`id`)) ENGINE = MyISAM;
When i pressed the go button this error popped up. #1142 - CREATE command denied to user 'me'@'localhost' for table 'users'
I know nothing about php so i am unable to figure out what the problem is. I really appreciate if someone can tell me what i have done wrong and how i can fix this. Thanks