I'm using phpmyadmin to start a database (it's always worked well).

This time I'm also adding a new user so they don't have permissions on the other databases. I add them, authorize them everywhere, and try to run an install script and it faily. If I use my master user & password it works fine.

Anything I should try to get phpmyadmin to ADD a user to mysql successfully?

I may not be understanding the whole add user thing. Do I need to click "mysql" on the left first, then select user? I was simply clicking "users" in the middle of the phpmyadmin page and adding them there. Maybe that doesn't add them to mysql?

If phpmyadmin won't work, how would I manually add a user to mysql on the raq?

Thanks!



Sean

http://www.mysql.com/doc/A/d/Adding_users.html


____________________________________
Keith

"CREATE DATABASE creates a database with the given name. Because there are no tables in a database when it is initially created, the CREATE DATABASE statement only creates a directory under the MySQL data directory. "


so when I try to assign permissions to the user / database relationship, it seems to say "hey dummy, the thing is empty, I can't do anything."

Do I have to create a dummy table, and if I do that, will most programs (phplist mailing list manager is the one I'm trying to get to work here) initialize the database and get rid of my dummy table?

anyway, I'm farther along. The key I was missing was to hit "reload mysql" inside phpmyadmin. getting closer...

the other question is, once I link permissions to the user and that database (which I think I've done), do I ALSO have to give permissions for that user with the "mysql" database? (since the mail list script still appears to be unhappy with something mysql).

thanks very much in advance. This is quite the learning experience.
Sean

http://www.raqzone.com/tools.htm

This is a great tool to setup mysql accounts.

Just make sure you protect the directories with a .htaccess file. If you don't have one do a search. Chicken but one up for me just a day or two ago.

_____________
Keith

After you add the user to the users table and database table (and other tables that may apply) you must FLUSH PRIVILEGES before the changes take effect.

-dr

Maybe this is useful for you?

http://www.hostingdiscussions.com/showthread.php?threadid=210

Let me know...
Good luck