MrProsser Posted May 22, 2013 Posted May 22, 2013 I am new to web development and I am having some problems figuring out how to deploy databases to the heliohost servers. My account is on johnny as I am doing ASP.NET development. I am trying to either deploy a local database to my heliohost account, or start a remote connection to the heliohost database and work with that directly. I tried to create a connection to johnny in mySQL workbench, but have been having problems. I created a new server instance to johnny and that seems to have worked. Then I attempted to create a new DB connection. This seemed to work as well, but then I attempted to create a new model, created a single table as a test and tried to forward engineer this and export the table but keep getting errors:My hostname was: johnny.heliohost.orgusername: tstewart_rootport: 3306 It successfully connects to the DDMS, but when it tried to Execute Forward Engineered Script I get an error:Executing SQL script in serverERROR: 1044: Access denied for user 'tstewart_root'@'%' to database 'tstewart_test' CREATE SCHEMA IF NOT EXISTS 'tstewart_test' SQL Script execution finish... I was wondering if anyone has any idea what I might be missing or what I should try to get this to work? Just to update this, I realized that I had not associated the user with the tstewart_test database on heliohost, but after doing this and giving it full privileges it still did not work.
Krydos Posted May 23, 2013 Posted May 23, 2013 Are you trying to connect to MySQL from a remote location? If so you need to allow remote conenctions first http://johnny.heliohost.org:2082/frontend/x3/sql/managehost.html
MrProsser Posted May 24, 2013 Author Posted May 24, 2013 Thanks, yes, that is what I was trying to do. I had already allowed access using that form. But I did two other things and got it to work earlier today, I created a schema in mySQL Workbench that was the same name as the database created in cPanel, and I then realized it was not enough to create a user, but that I had to add that user to the database and grant them various privileges.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now