can't connect to mysql database on godaddy server

can't connect to mysql database on godaddy server may be mistake in syntax or understanding environment please help ,and you should know that localhost on pc work good with (appserv 8.6.0) nearby
AHMED SAMYownerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tomas Helgi JohannssonCommented:
Post the error you get when connecting.

    Tomas Helgi
nociSoftware EngineerCommented:
You mean from a godaddy server to godaddy mysql or from your home server to godaddy?...
for the latter you may need to first create a tunnel to the godaddy system, of installer pphpmysql on your server.

The first case seems unlikely.
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
As noci said, your original question seems to indicate you're running a local database instance.

If this is true, best move your database to GoDaddy first, if that's where your site will be running.
SolarWinds® IP Control Bundle (IPCB)

Combines SolarWinds IP Address Manager and User Device Tracker to help detect IP conflicts, quickly identify affected systems, and help your team take near instantaneous action. Help improve visibility and enhance reliability with SolarWinds IP Control Bundle.

Dave BaldwinFixer of ProblemsCommented:
Godaddy lets you set up MYSQL databases either with external access or only localhost.  The default is localhost and you can only access those from code on your web server, not from home.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Adding to Dave's comment or possibly through the admin portal, phpmyadmin interface.
AHMED SAMYownerAuthor Commented:
peace be upon you and mercy


i think code was wrong i changed it it works but now i have two problems:

         1- language arabic not right i make it utf8_general_ci and still shows ??????????? why ?
         2- i need to make loop in loop to bring categories and sub categories.

Not sure changing the character-set after the data was stored in such a case would auto-fix.
Check using substring to pull one character to see what value it has from the utc/ASCII table.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.