Amit Verified User Joined Mar 24, 2020 Messages 129 Location India Sep 18, 2020 #1 Hello, i am getting no previlage error in phpmyadmin while trying to create database.Please see screenshot. Attachments Untitled.png 22.1 KB · Views: 9
Hello, i am getting no previlage error in phpmyadmin while trying to create database.Please see screenshot.
k1l0b1t Verified User Joined May 10, 2020 Messages 526 Location Belgium Sep 18, 2020 #2 Yes, that's because you have to create databases from whitin directadmin.
Amit Verified User Joined Mar 24, 2020 Messages 129 Location India Sep 18, 2020 #3 Got it But its creating issue while importing data base from phpmyadmin
k1l0b1t Verified User Joined May 10, 2020 Messages 526 Location Belgium Sep 18, 2020 #4 Hmm, does the sql file you import try to create a table with a diffirent name than the one in directadmin?
Hmm, does the sql file you import try to create a table with a diffirent name than the one in directadmin?
Amit Verified User Joined Mar 24, 2020 Messages 129 Location India Sep 18, 2020 #5 No database is exported from cpanel when you export database from cpanel the SQL file also contain statement of create database which causing privilege issue while importing to direct admin.
No database is exported from cpanel when you export database from cpanel the SQL file also contain statement of create database which causing privilege issue while importing to direct admin.
S sysdev Verified User Joined Jul 16, 2007 Messages 391 Sep 18, 2020 #6 Then delete te create database statement from the sql file before you import it
floyd Verified User Joined Mar 29, 2005 Messages 6,269 Sep 19, 2020 #7 You have create the database first in DA and then import.