Im trying to create an admin panel for my website and the admin panel will upload new data to the mysql database. Is it possible and secure to keep my admin panel in my local computer and access the database that is in mysql hosting provider? so my admin panel will only be accessible with my computer .
This will depend on your host, and what they allow. The most obvious solution would be to use something like phpMyAdmin – almost all hosting providers (IME, that offer MySQL at all) have something like this set up by default.
The next option would be to SSH to your database server and use the MySQL command line interface. If you literally want your DB to be accessible “only” from your computer, this is what you would need. Adding a GUI on top of this would be more complex, though, and more dependent on what your host wants to allow/accommodate.
= = = = = edit = = = = =
I think I misunderstood your question. Are you looking to create a web-based admin panel, but only have it on your local version of the site (and not on the “live” site)? If so, yes, that should work just fine.
It would depend on the database user/ database host. For example, some hosts restrict how you can connect to your DB from computers other than your website server; or give you a different user (with different privileges) for such access. Or, you might have no problems/restrictions at all. Have you tried yet?