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(idINT NOT NULL AUTO_INCREMENT,uuidCHAR NOT NULL,usernameVARCHAR NULL DEFAULT NULL,passwordVARCHAR NOT NULL,roleENUM NOT NULL DEFAULT ‘USER’,statusTINYINT NOT NULL DEFAULT 1,date_createdTIMESTAMP NULL DEFAULT NULL,date_modifiedTIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (id), UNIQUE INDEXusername_UNIQUE(usernameASC), UNIQUE INDEXuuid_UNIQUE(uuidASC)) 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?