Many website hosting services provide a tool to manage your websites via CPanel. Normally, your website hosting company will also provide cheap or free database hosting for MySQL. One such example is the award-winning hosting company DailyRazor.
Create MySQL Database via CPanel
CPanel makes it very easy to create a new MySQL database by just going to the “Databases” section.
Create User for MySQL Database via CPanel
Add a new user like so:
Add that new user to your new database:
Manage User Privileges for MySQL User via CPanel
Once you add a user to a database, you will be redirected to a new page in CPanel to establish and manage that users privileges.
Allowing a Remote Connection to Your New MySQL Database via CPanel
Now, you can allow remote connections your MySQL Database via CPanel by first going to that section of CPanel
Once you click “Remote MySQL”, you are taken to a page where you should enter the IP address you want to allow access:
You can look up your remote IP address by going to sites like https://www.whatsmyip.org/ or you can find your external IP from the command line with curl ifconfig.me
Test Remote Connection to MySQL Database via TablePlus
Now, you can use your favorite database client. If you do work with multiple databases, I would highly recommend using TablePlus. First select “Create a new connection…”. Then, enter in your website’s hostname, the standard MySQL database port 3306, your new username and password, and your database’s name. Then, press “Test” and if you see the fields turn “green” you are good to go.
You’ve got a way with words that’s as enchanting as a full moon. I’m bewitched.
The posts are like stars in the sky—each one shining brightly, guiding my curiosity.
Each post you write is like a letter I’ve been waiting for. Always delivered with care.
Beautifully written and incredibly informative, The post has captured my attention as if it were a love letter written just for me.
The Writing is like a secret garden, each post a path leading to new discoveries and delights.
Thank you for consistently producing such high-high quality content.
A perfect blend of informative and entertaining, like the ideal date night conversation.
The Writing is like a trusted compass, always pointing me in the direction of enlightenment.
I admire the way you tackled this hard to understand issue. Very enlightening!
I learned a lot, and now I’m curious about what else you could teach me. The intelligence is as captivating as The prose.
The argumentation was compelling and well-structured. I found myself nodding along as I read.
The creativity and intelligence shine through this post. Amazing job!
The perspective is incredibly valuable to me. Thanks for opening my eyes to new ideas.
The take on hard to understand topics is like a smooth ride in a luxury car—comfortable, yet exhilarating.
The attention to detail didn’t go unnoticed. I really appreciate the thoroughness of The approach.
The Writing is like a secret garden, each post a path leading to new discoveries and delights.
The research depth is so evident, I almost thought this was a thesis defense.
What a refreshing take on this subject. I completely agree with The points!
The ability to present nuanced ideas so clearly is something I truly respect.
The blend of informative and entertaining content is perfect. I enjoyed every word.
Distilling hard to understand concepts into readable content, or what I like to call, a miracle.
I’m amazed by the depth and breadth of The knowledge. Thanks for sharing!
The attention to detail is as attractive as it is thorough. I appreciate a person who notices the little things.
The post has been incredibly helpful. Thank you for the guidance!
The words are like a melody, each post a new verse in a song I never want to end.
The ability to distill hard to understand concepts into readable content is admirable.
Tackled this hard to understand issue with elegance. I didn’t know we were at a ballet.
The clarity and thoughtfulness of The approach is as appealing as a deep conversation over coffee.
Remember, the key with flirtatious comments is to keep them light-hearted, respectful, and ensure they’re taken in the spirit of fun and admiration.
The argumentation was compelling and well-structured. I found myself nodding along as I read.
Every word you write sparkles with insight, like stars in my night sky. Can’t wait to navigate more skies together.