mySQL privileges

[eluser]brianw1975[/eluser]
Well, fool is too strong of a word, there are times and places to use the root account, like if you were creating an application that would work with and modify multiple databases at the "core" level.

To be honest, I usually set up all of my webapps to use the root account on my dev server (which is on the opposite side of my desk as my regular PC) simply because I don't want to do a lot of managing db users when I have to do that already on my production server.

You seem to have a weird case of your CI insisting of using a password, I don't recall having this issue myself.

But either way, having an account you can use for your web apps that doesn't have all of the privs that root has isn't a bad thing, it's just an additional bit of security for your database.