No Permission in PHPMyAdmin for SQLServer

Web hosting discussion, programming, and shared and dedicated servers.
2 posts Page 1 of 1
by calsoft » Thu Jun 20, 2019 5:02 pm
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.
by drew.phillips » Thu Jun 20, 2019 5:20 pm
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.
Drew Phillips
Programmer / System Operations, Sonic.net
2 posts Page 1 of 1

Who is online

In total there are 17 users online :: 0 registered, 0 hidden and 17 guests (based on users active over the past 5 minutes)
Most users ever online was 999 on Mon May 10, 2021 1:02 am

Users browsing this forum: No registered users and 17 guests