Page 1 of 1

No Permission in PHPMyAdmin for SQLServer

Posted: Thu Jun 20, 2019 5:02 pm
by calsoft
I'm trying to add a new DB to my SQLServer via a SQL Dump File. When I try to upload the file I am prompted that I do not have permission create new databases.
I then tried to manually create the database, but I don't have permission to do that either.

Re: No Permission in PHPMyAdmin for SQLServer

Posted: Thu Jun 20, 2019 5:20 pm
by drew.phillips
Hi calsoft,

To create a new MySQL database, you'll need to log in to Member Tools and go to https://members.sonic.net/databases/add/?MySQL55

The MySQL users created by this tool do not have the ability to create new databases; this must be done through Member Tools.

Once the new database is created, you should be able to log in to phpMyAdmin and import the SQL file. If the SQL file has any instructions like DROP DATABASE IF EXISTS and/or CREATE DATABASE, these will need to be removed.