You can use the following command sequence to add admin user:
shell> mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO admin@localhost
IDENTIFIED BY 'some_password' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO admin@"%"
IDENTIFIED BY 'some_password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES
You also can make a script executing this SQL-queries from root user.
--
============
Mike Tsapenko
Chief of Web-development Dept.
AlarIT
http://www.AlarIT.com
"Leif K-Brooks" <[EMAIL PROTECTED]> ???????/???????? ? ????????
?????????: [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I need to add mysql users to some databases, but my dumb control panel
> (ensim) doesn't seem to have a feature to do that, and I'm nothing in
> the mysql database. Does anyone have a script to let me add them
> automaticly if I supply it with the root password?
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
