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
Solved

phpMyAdmin on Windows Azure Web Sites

Posted on 2014-03-04
4
2,590 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 34

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

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Suggested Solutions

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
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 …
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

792 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