Solved

phpMyAdmin on Windows Azure Web Sites

Posted on 2014-03-04
4
2,641 Views
Last Modified: 2014-11-12
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
0
Comment
Question by:RedDoorSupplies
  • 2
4 Comments
 
LVL 11

Expert Comment

by:Amar Bardoliwala
ID: 39905775
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
 
LVL 35

Expert Comment

by:Dan Craciun
ID: 39906646
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
 

Accepted Solution

by:
RedDoorSupplies earned 0 total points
ID: 39908765
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
 

Author Closing Comment

by:RedDoorSupplies
ID: 39917024
Managed to resolve the issue on my own

Thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn how the use of a bunch of disparate tools requiring a lot of manual attention led to a series of unfortunate backup events for one company.
The Nano Server Image Builder helps you create a custom Nano Server image and bootable USB media with the aid of a graphical interface. Based on the inputs you provide, it generates images for deployment and creates reusable PowerShell scripts that …
The viewer will learn how to count occurrences of each item in an array.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question