phpMyAdmin on Windows Azure Web Sites

RedDoorSupplies
RedDoorSupplies used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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

Commented:
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
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

Author

Commented:
Managed to resolve the issue on my own

Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial