Jikdor Posted November 2, 2010 Share Posted November 2, 2010 I got this problem on step 3 when trying to install prestashop on a new host. Never got this problem before does anyone know how to solove it?Error while inserting data in the database:'CREATE TABLE `ps_access` ( `id_profile` int(10) unsigned NOT NULL, `id_tab` int(10) unsigned NOT NULL, `view` int(11) NOT NULL, `add` int(11) NOT NULL, `edit` int(11) NOT NULL, `delete` int(11) NOT NULL, PRIMARY KEY (`id_profile`,`id_tab`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8'CREATE command denied to user \'admin@s31114\'@\'s80.loopia.se\' for table \'ps_access\'(Error: : 1142) Link to comment Share on other sites More sharing options...
Jikdor Posted November 2, 2010 Author Share Posted November 2, 2010 My database user has all privileges as it should... Link to comment Share on other sites More sharing options...
Jikdor Posted November 2, 2010 Author Share Posted November 2, 2010 Nevermind! Aparently I Having Reed/Write/Delte checked was not enought I had to check all of the boxes... Link to comment Share on other sites More sharing options...
Mr. Saif Posted November 24, 2010 Share Posted November 24, 2010 Check again that your user has Insert privileges on prestashop database Link to comment Share on other sites More sharing options...
Webd007 Posted February 18, 2011 Share Posted February 18, 2011 Error while inserting data in the database:'CREATE TABLE `ps_access` ( `id_profile` int(10) unsigned NOT NULL, `id_tab` int(10) unsigned NOT NULL, `view` int(11) NOT NULL, `add` int(11) NOT NULL, `edit` int(11) NOT NULL, `delete` int(11) NOT NULL, PRIMARY KEY (`id_profile`,`id_tab`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8'CREATE command denied to user \'xxxxxxx\'@\90.90.90.90\' for table \'ps_access\'(Error: : 1142)I`m still having this problem. I have all the privileges to my database username. I can`t figure it out whats the problem. Can anyone help me please. Link to comment Share on other sites More sharing options...
Kintaro Posted March 25, 2011 Share Posted March 25, 2011 I'm having the exact same problem!Any one having a clue?Regards,Chris Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now