Adding User for MYSQL Access

[tjrush]

I am currently connecting to my MYSQL database using the 'root' user. However, I would like my website to connect to the database using a user with limited privileges. My question is, Where do I create this user?

Thanks,
Tom

[Wiedmann]

e.g. with phpMyAdmin.

[tjrush]

I understand that I have to use phpmyadmin. However, to what do I add it.

I tried adding a row to the user table in the mysql database. However, when I added that user and password to my connection script I got a MYSQL access error. I assumed that I was adding to the wrong place. Please confirm that this is the correct place to add the user or let me know where to add the user.

Tom

[Wiedmann]

I understand that I have to use phpmyadmin. However, to what do I add it.

http://wiki.cihar.com/pma/user_management

[tjrush]

I new I had to use phpMyadmin, now I know how to use it. All is now well.

Thanks,
Tom