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.
Hi,
I don’t see any recent reviews on your Google Business Profile.
I can fix that for you if you would like, simply reply to this message and I’ll send you a quick explainer video.
Regards
Joe
(714) 617-7866
txNXuoHiZelO
I simply wished to appreciate you once more. I’m not certain the things I would’ve worked on without the type of tips shown by you concerning such topic. It previously was a alarming difficulty in my view, but noticing your well-written manner you solved the issue forced me to weep with fulfillment. I’m just thankful for the guidance and thus have high hopes you are aware of a great job that you’re providing teaching the others by way of your site. More than likely you haven’t come across all of us.
I wanted to make a brief note to be able to express gratitude to you for all of the precious tricks you are sharing on this site. My extensive internet look up has finally been compensated with beneficial ideas to go over with my friends and classmates. I ‘d believe that we site visitors actually are very endowed to dwell in a magnificent site with so many special individuals with very helpful pointers. I feel very much fortunate to have come across the web page and look forward to some more fun minutes reading here. Thanks a lot again for a lot of things.
FPUNXpijamoy
Thanks for each of your labor on this web site. My mom loves carrying out research and it’s obvious why. My spouse and i notice all regarding the lively form you present useful tips and hints via your website and as well as cause contribution from some others about this matter and my daughter is truly starting to learn a great deal. Enjoy the remaining portion of the year. You are always conducting a good job.
I am just commenting to make you know of the remarkable experience my friend’s princess undergone visiting yuor web blog. She realized lots of issues, most notably what it is like to possess a marvelous helping heart to have others easily fully understand a number of grueling issues. You undoubtedly exceeded our own expected results. Thank you for giving the great, trusted, explanatory and as well as cool tips on this topic to Julie.
kXfvRmhAJIHi
I wanted to jot down a brief word so as to appreciate you for all of the unique recommendations you are giving out on this website. My prolonged internet research has finally been rewarded with sensible facts to talk about with my friends. I would point out that we website visitors are unequivocally endowed to live in a wonderful site with very many brilliant professionals with good ideas. I feel quite happy to have come across your site and look forward to so many more excellent times reading here. Thank you again for a lot of things.
Howdy just wanted to give you a quick heads up. The text in your article seem to be running off the screen in Ie. I’m not sure if this is a format issue or something to do with internet browser compatibility but I thought I’d post to let you know. The design look great though! Hope you get the problem fixed soon. Kudos
I’m so glad I stumbled upon this article. It was exactly what I needed to enjoy reading!
Your post was a beacon of knowledge. Thank you for illuminating this subject.
This post is a testament to your expertise and hard work. Thank you!
dQTqKnzxXRFlykM
Your creativity and intelligence shine through this post. Amazing job!
This post was a breath of fresh air. Thank you for your unique insights!
Your creativity and intelligence shine through this post. Amazing job!
I appreciate the unique viewpoints you bring to your writing. Very insightful!
Such a well-researched piece! It’s evident how much effort you’ve put in.
Your writing style is captivating! I was engaged from start to finish.
I appreciate the balance and fairness in your writing. Great job!
I’m so glad I stumbled upon this article. It was exactly what I needed to enjoy reading!
The consistency and high quality of The content are something I really appreciate. Thank you for The dedication.
You have a gift for explaining things in an understandable way, much like a smooth talker who knows just what to say.
A masterpiece of writing! You’ve covered all bases with elegance.
This piece was beautifully written and incredibly informative. Thank you for sharing!
This post is packed with insights, each one a gentle nudge to my intellect and curiosity.
Refreshing take on the subject, like a cold splash of water to my long-held beliefs.
Explaining things in an understandable way is a skill, and you’ve mastered it. Thanks for clearing things up for me.
The elegance of The arguments is as captivating as a sunset. I could admire it all day.
I appreciate the clarity and thoughtfulness you bring to this topic.
I’m so grateful for the information you’ve shared. It’s been incredibly enlightening!
The way you articulate The thoughts is as refreshing as the first sip of coffee in the morning.
Thoroughly insightful read, or so I thought until I realized it was The expertise shining through. Thanks for making me feel like a novice again!
This post has been incredibly helpful to me. The guidance is something I’m truly grateful for.
The writing style is captivating. Finally, something that can keep my attention longer than a TikTok video.
The ability to break down tough concepts is as impressive as a magician’s trick. Color me amazed.
Explaining things in an understandable way is a skill, and you’ve mastered it. Thanks for clearing things up for me.
I appreciate the balance and fairness in The writing. Great job!
The consistency and high quality of The content are something I really appreciate. Thank you for The dedication.
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 post resonated with me on many levels. Thank you for writing it!
The insights are like a favorite book; I find new treasures each time I return.
uhxfKdimTlF
The insights dazzled me more than a candlelit dinner. Thanks for lighting up my intellect.
Each post is a journey, and The words are the map. Thanks for leading the way.
The writing is a masterpiece. You managed to cover every aspect with such finesse.
The perspective is incredibly valuable to me. Thanks for opening my eyes to new ideas.
The insights add so much value, like an unexpected compliment that brightens one’s day. Thanks for sharing.
The grace and authority with which you handle topics are awe-inspiring. I always come away with new knowledge.