this is just tedious...

[zambizzi]

I simply want to create a new mysql user, why is this so frickin' complicated?

I tried this:

http://dev.mysql.com/doc/mysql/en/Adding_users.html

...no good, it must be outdated; I'm using 4.0.20

It won't insert because I'm not filling all of the fields in the mysql.users table, this is what makes me think the documentation above is outdated.

I can't do it w/ the "grant" method as the database doesn't exist yet, I need the user first.

Any ideas?

-v

[TimG]

How about:

[hanj]

Hello zambizzi

Why do you need the user first? I'm just trying to understand the problem.

TimG's solution should work nicely, another option to make things easier.. is to emerge phpmyadmin. If you do this, make sure you limit access to it, if this is going on a public webserver.

hanji

[TimG]

[zambizzi]

I don't after all, I misread the documentation for an e-commerce web app I'm trying to install.

I'll try this out and let you know what I find.

Thanks!

[zambizzi]

everything's cool!

Thanks again!