QSqlQuery::prepare: database not open

[RekTek249]

@SGaist When I go to the "remote mysql" part of the site, it gives an access host... do i gotta use this as the hostname ?

[RekTek249]

@RekTek249 If that's what i do, it gives that error:

QSqlError("1045", "QMYSQL: Unable to connect", "Access denied for user 'rektek_write'@'*ip here*.' (using password: YES)")

If it's a permission problem, what do I need to do ? I have the insert one because that's the only thing I need to do...

[SGaist]

Is this user authorised to access the database from outside that machine ?

[RekTek249]

@SGaist Well it's a website host.... They wouldn't allow you to create hosts that can only connect on that machine i guess.

[SGaist]

That I don't know, you should ask them.

[RekTek249]

@SGaist Alright... I checked something and apparently for remote you need the user's ip. The control panel needs the ip so I guess I can't make this application public because they wont be able to access the database ?

[SGaist]

Then implement a REST service to expose what you need for your application.

What exactly are you trying to implement ? Because currently it seems you are trying to do server-side stuff from your application.

[RekTek249]

@SGaist I just need to store (INSERT) things in a database... And what is a REST ?

[the_]

@RekTek249
See https://www.tutorialspoint.com/restful/

[jsulm]

@RekTek249 Yes, you should implement a REST interface - exposing a SQL database to the public internet isn't a good idea.

[SGaist]

To add to @the_, the tutorial explains thing nicely but there are more lightweight options than a full Java + eclipse + tomcat setup to get started.

Python wise there's the Django REST framework or Flask RESTful

PHP wise there's PHP Slim

There are also other options but you'd have to first share what you have available on your server.