?
Solved

phpMyAdmin on Windows Azure Web Sites

Posted on 2014-03-04
4
Medium Priority
?
2,843 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

When ransomware hits your clients, what do you do?

MSPs: Endpoint security isn’t enough to prevent ransomware.
As the impact and severity of crypto ransomware attacks has grown, Webroot has fought back, not just by building a next-gen endpoint solution capable of preventing ransomware attacks but also by being a thought leader.

Question has a verified solution.

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

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
There’s a movement in Information Technology (IT), and while it’s hard to define, it is gaining momentum. Some call it “stream-lined IT;” others call it “thin-model IT.”
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
Both in life and business – not all partnerships are created equal. Spend 30 short minutes with us to learn:   • Key questions to ask when considering a partnership to accelerate your business into the cloud • Pitfalls and mistakes other partners…
Suggested Courses

762 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