|
Replies:
9
-
Pages:
1
-
Last Post:
Aug 28, 2012 8:14 AM
by: Rick Fox
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
1
Registered:
9/29/10
|
|
|
|
Schema Compare Error in Shared Hosting Environment
Posted:
Sep 29, 2010 7:52 AM
|
|
|
|
|
I am running Toad for MySQL Version 4.6.0.531
I access a shared hosting environment over SSH.
I can connect to the database and see the information_schema and my test and production database schema and can browse them.
If I perform a database schema compare, I can select the test and live databases for comparison.
When I start the comparison a status box displays as follows:
Gathering information...Server 'localhost'.database 'my.testdomain.com'. Gathering information on users...
This is then overlayed with and error message as follows:
SELECT command denied to user 'myuserid@localhost' for table 'db' Quest.Compare.Schema.MySQL.DBModel
I have attempted the same with the V 5.0 Beta and receive the same error.
My suspicion is that the schema compare is relying on a SQL request that is no authorized in a shared hosting environment. Can anyone confirm?
If I am correct, would there be a way for you to provide a schema compare that does not rely on such access (even if that might limit the extent of the comparison, for example not comparing authorizations)
|
|
|
Posts:
1
Registered:
7/3/11
|
|
|
|
Re: Schema Compare Error in Shared Hosting Environment
Posted:
Jul 3, 2011 3:27 PM
in response to: Dino1
|
|
|
I too feel the same, I need help
|
|
|
Posts:
1
Registered:
3/28/12
|
|
|
|
Re: Schema Compare Error in Shared Hosting Environment
Posted:
Mar 28, 2012 1:46 AM
in response to: elbert.castaneda
|
|
|
Does anybody know a way around this? I've been searching the last couple of days and can't seem to find a way around this problem
|
|
|
Posts:
1
Registered:
3/28/12
|
|
|
|
Re: Schema Compare Error in Shared Hosting Environment
Posted:
Mar 28, 2012 4:38 PM
in response to: Dino1
|
|
|
Ditto here. Same problem today.
|
|
|
Posts:
1
Registered:
5/29/12
|
|
|
|
Re: Schema Compare Error in Shared Hosting Environment
Posted:
May 29, 2012 10:32 AM
in response to: de Hilster
|
|
|
hello all,
i am also facing the same problen, can some one help on this
thanks for the support
dino
|
|
|
Posts:
1
Registered:
8/16/12
|
|
|
|
Re: Schema Compare Error in Shared Hosting Environment
Posted:
Aug 16, 2012 2:02 AM
in response to: Dino1
|
|
|
Same here.
Seems strange that so many users experience the same problem and for 2 years! not a single reply.
|
|
|
Posts:
3
Registered:
8/16/12
|
|
|
|
Re: Schema Compare Error in Shared Hosting Environment
Posted:
Aug 16, 2012 2:57 AM
in response to: Dino1
|
|
|
Hello all,
I can confirm that it is a user-privilege problem.
I tried to do a schema-compare between a local development and a remote production enviroment using my default mysqlusers which are used by php and got the same error you all got.
After reading this thread i tried the same using local and remote root users and succeeded.
Next step is figuring out the differences in the users privs of both users. I'll get back on this soon i hope.
|
|
|
Posts:
3
Registered:
8/16/12
|
|
|
|
Re: Schema Compare Error in Shared Hosting Environment
Posted:
Aug 16, 2012 3:13 AM
in response to: Sebbie
|
|
|
Right,
Using MySQL Workbench i toyed around with the admin privileges of the mysql user i also use with php and narrowed the privileges down to the following 5:
- CREATE USER
- GRANT OPTION
- RELOAD
- SHOW DATABASES
* Modify access control
One of these, or a combination of these provide you with the necessary privs to do a schema compare.
I put my money on the GRANT AND Modify access control options however derived from their names i still don't have a clue as to why a user should have modify access control privs to do a schema compare since you're not really modifying anything.
I hope this works for you too.
|
|
|
Posts:
3
Registered:
8/16/12
|
|
|
|
Re: Schema Compare Error in Shared Hosting Environment
Posted:
Aug 16, 2012 3:16 AM
in response to: mkaz58
|
|
|
By now, All the previous posters will probably have moved on to using other software. I hope the solution i posted earlier works out.
|
|
|
Posts:
1
Registered:
8/28/12
|
|
|
|
Re: Schema Compare Error in Shared Hosting Environment
Posted:
Aug 28, 2012 8:14 AM
in response to: Dino1
|
|
|
I got this working by granting select access on the mysql database to the user trying to do the compare.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
