Hi, installed the cobalt mysql package on my raq4.

I installed phpmyadmin on my main domain and everything works fine.

Question, if i want add users to MySQL I would normally do this via telnet. Can I add users through PHPmyadmin by adding users to the "user" table in the MySQl database? or will this make the users profiles corrupt!

thanks

[Edited by Surfer on 03-12-2001 at 08:42 AM]

where did you download PHPmyadmin from?

http://phpwizard.net/projects/phpMyAdmin/

To add users I *thought* you'd have to do it from the command line, or possibly use the add-on that someone posted not too long ago. I keep forgetting to add it (but I downloaded it, heh).

on another note, how can I view all users and their info?

I tried "show grants for user@localhost" but I get an error!

thanks

Get the user addon from http://www.planetdps.com/useradmin.zip to maintain user rights

for displaying current users & their rights do either

1.) command prompt:
- use mysql (to select mysql system database)
- select * from db (rights to specific databases)
- select * from users (global mysql rights)

2.) within phpMyAdmin select the "mysql" database and browse
the "db" und "users" table; you need to be logged in as a user with system select rights, ie. root