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 3 users online :: 1 registered, 0 hidden and 2 guests (based on users active over the past 5 minutes)
Most users ever online was 422 on Sat May 26, 2012 5:28 am

Users browsing this forum: Bing [Bot] and 2 guests