Page 2 of 2

Posted: Wed Apr 26, 2006 10:01 am
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;

Well...

Posted: Wed Apr 26, 2006 10:23 am
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

Posted: Wed Apr 26, 2006 11:15 am
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 .