Installation of IIS 5/PHP/PHPMYADMIN most evil [SOLVED]

Need help installing PHP, configuring a script, or configuring a server? Then come on in and post your questions! We'll try to help the best we can!

Moderator: General Moderators

User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

What I mean is that PMA is a standalone application. Just like any other web app that requires php and mysql, you should be a able to put the application on your server, set a few parameters in a configuartion file, then point your browser to the start page of the app and begin using it.

When I have set up a new web server in the past (which is far too many times for a web developer, in my opinion), I have got the server running (whether it be IIS or Apache or both), then installed PHP and made sure PHP was running (simple phpinfo() page), then installed the database app and made sure it was running (command line or administrator), then I made sure the web server and db server were talking by installing PMA or by writing a small DB connection script.

I can't think of a reason why phpMyAdmin should need it's own database. What it looks like with following code is that you are trying to assign priviledges to the user 'root' on the database 'phpmyadmin'. But I think that 'root' has global priviledges and wouldn't require priviledges assigned for any database, let alone a phpyadmin database. It just looked odd to me.

Code: Select all

GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO
    'root'@localhost;
User avatar
Helicoprion
Forum Newbie
Posts: 10
Joined: Tue Apr 25, 2006 11:07 am
Location: Sweltering Florida

Well...

Post by Helicoprion »

Your right, that made more sense now, I guess my problems are solved.

I am going out to get some books on PHP and MYSQL now, I am really interested in application of both tools fully 8O

Thx much Everah :D
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Make sure to get books that are easy to understand. Kevin Yank's book (Build Your Own Database Driven Website Using PHP & MySQL) from Sitepoint is a really good starter book. There are few from O'Reilly that are good also. And I think SAMS has a few books out there that are helpful.

Of course, you could just keep browsing the forums here for all sorts of goodies and teachings :D .
Post Reply