Mysql question...

[-TooL]

Ok.. im going to attempt to make a HOWTO: Make a phpBB work with gentoo..

since im a noob, and my have my mysql misconfigured.. i need to ask some quick questions.. (ohh and i totally destroyed phpmyadmin, cant get it to work anymore.. so im going to attempt to skip that and just go thru the mysql command prompt)

I created a user with "all" mysql permissions, to use with the forums (so I wouldnt have to use mysql's "root"), my question is... was that a bad thing to do? Should I set the permissions diffrently? and.. the biggest thing of all............................ how do i set diffrent permissions?

This is what i used to create the second account:

[TheRAt]

You might want to look at "Getting Started with MySQL" for setting MySQL permissions. There is also some good information on that site on general practices with MySQL.

As for weather it is a good idea, I have not used phpBB (except for these forums) but I do not think it is a good idea to grant any used "full" access to databases. Generally speaking, I have always set up users for their specific uses and needs. I guess it would really depend on the situation.
_________________
All reality is the construct of the observer.

Get Firefox and rediscover the web!

BOFH Excuse #295:
The Token fell out of the ring. Call us when you find it.