I have a script system that refuse to be installed because of error that breaks installation.
I tryied to import the data by import the data via .sql file at phpmyadmin and it still cant import.
When i try to menully import the file jcqm.sql its fail and i get this message:
SQL query: - --—-—-—-—-—-—-—-—-—-—- —Table
jqcm_import
.users
- --—-—-—-—-—-—-—-—-—-—- CREATE TABLE IF NOT EXISTSjqcm_import
.users
(id
INT NOT NULL AUTO_INCREMENT,uuid
CHAR NOT NULL,username
VARCHAR NULL DEFAULT NULL,password
VARCHAR NOT NULL,role
ENUM NOT NULL DEFAULT ‘USER’,status
TINYINT NOT NULL DEFAULT 1,date_created
TIMESTAMP NULL DEFAULT NULL,date_modified
TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (id
), UNIQUE INDEXusername_UNIQUE
(username
ASC), UNIQUE INDEXuuid_UNIQUE
(uuid
ASC)) ENGINE = InnoDB AUTO_INCREMENT = 0 DEFAULT CHARACTER SET = utf8; MySQL said: Documentation #1142 – CREATE command denied to user ‘xxx’@’localhost’ for table ‘users’
I try to grant some privilegies by do:
GRANT ALL PRIVILEGES ON `costo_jmat`.* TO 'costo_matis'@'localhost'
By using this method:
GRANT ALL on dbname.* to 'username'@'localhost' identified by 'password'
But still, no sucsess!
Here is the installation path: Installation path
Can you please solve this so i can use the script?