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