phpMyAdmin on Windows Azure Web Sites

Hi im trying to setup phpMyAdmin on site hosted on Windows Azure but im having some trouble.

I have found the following article (http://ruslany.net/2012/12/phpmyadmin-on-windows-azure-web-sites/) which has some steps to follow but not knowing anything about creating sites etc im a bit lost.

Can someone tell me exactly what the config.inc.php files needs to look like as I don't think I have created it correctly.

I can get to the login screen but all I get is a error saying "#2002 Cannot log in to the MySQL server"

Any help would be great thanks
RedDoorSuppliesAsked:
Who is Participating?

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

x
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.

Amar BardoliwalaCommented:
Hello RedDoorSupplies,

did you set proper hostname, username and password in config file of phpmyadmin ?

Look at step 3 on following link for settings of config file.

http://www.wikihow.com/Install-phpMyAdmin-on-Your-Windows-PC

Hope this will help you.

Thank you.

Amar Bardoliwala
0
Dan CraciunIT ConsultantCommented:
You can try Adminer. It's a single php file, much simpler to configure than phpmyadmin.

Just download the file, unzip and drop it somewhere inside your web path. I recommend renaming it to simply adminer.php
Then navigate to the localhost/adminer.php, fill in the user (root?) and password and you're set.

HTH,
Dan
0
RedDoorSuppliesAuthor Commented:
Ok thanks for that my web designer wanted to use phpMyAdmin so that was the only reason I was looking to use that.

Managed to get it working when you add the connection string as per the instructions I copied the entire string not just the database path.

So the line should read in my case

$cfg['Servers'][$i]['host'] = 'eu-cdbr-azure-west-b.cloudapp.net';

Thanks again
0

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
RedDoorSuppliesAuthor Commented:
Managed to resolve the issue on my own

Thanks
0
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
PHP

From novice to tech pro — start learning today.