MySQL modify access privileges or create new users
Posted on 2004-11-20
I am attempting to create script installation Wizard, that would guide administrator through installation steps and as one of the steps configures new MySQL database to be used by the script.
I have no problem in creating a new database, however it is created without any access rights for any user, including root.
I need to modify access privileges for the configured user to allow this new database access from the Web host, where the Wizard was executed.
This is equivalent to MySQL command:
GRANT ALL ON dbname.* TO root@'webserver' IDENTIFIED BY 'password' WITH GRANT OPTION;
What DBI or DBD::MySQL command should I use for this?