MySQL connection fails with one database and not the other
0
votes
1
answer
208
views
I have 2 databases on mysql. **ge** and **ge_sc001.**
I can access both of these through my asp.net mvc application locally.
**Web.config**
Later on when i deployed my application on the web server, and tried to access them from a remote machine. I changed **server=localhost** to my machine's external-facing IP address. Now I can access only one **ge**. when i try to access the second it gives me error.
> Access denied for user 'root'@'' to database 'ge_sc001'
Notice there is no localhost above i.e. 'root'@'localhost'
**SHOW GRANTS**
'GRANT ALL PRIVILEGES ON . TO \'root\'@\'localhost\' IDENTIFIED BY PASSWORD \'*xxx\' WITH GRANT OPTION' 'GRANT PROXY ON \'\'@\'\' TO \'root\'@\'localhost\' WITH GRANT OPTION'
UPDATE
-------
I ran
GRANT ALL ON ge_sc001.* TO 'root'@'';
Now the error has change to
> The provider did not return a ProviderManifestToken string.
This is now happening on both of my schemas
Asked by Samra
(1 rep)
Oct 4, 2017, 12:33 AM
Last activity: Jun 16, 2025, 06:01 AM
Last activity: Jun 16, 2025, 06:01 AM