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
users- --—-—-—-—-—-—-—-—-—-—- CREATE TABLE IF NOT EXISTS
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 INDEX
usernameASC), UNIQUE INDEX
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?