MySql User "Root" - are permissions automatically set up upon DB creation?

[mlm2005]

Hello,

I've gathered the database server name, database name, user name and password.  When I created the MySql database it created a user called "Root" but I had another rep from my webhost tell me the user was "my domain name."  When I installed MySql the database was created automatically.  I used PHPAdmin to change the database name to something related to Coppermine.  I noticed the server name in the PHPAdmin control panel and also "Root@localhost."  So if Root is the user can I assume the permissions are also set up or do I have to do something further before starting the installation (after changing the folder permissions?)

Thanks

[Joachim Müller]

if coppermine is already set up and you entered "root" as the mySQL user during coppermine install, you will have to edit this setting when changing the mySQL user coppermine in suppossed to use. Edit the file your_coppermine_folder/include/config.inc.php on your webserver. It's recommended not to use the root user as mySQL user. Usually your webhost sets up a mySQL user for you that is suppossed to be used for web apps, it's a security risk to use the root user.

Joachim

[jpaffett]

When you install MySQL it creates the root user with all permission, which you should make sure is password protected. You should then set up users and assign permissions to them as required by the application. You mention your webhost, which makes me think you may be getting confused between your local installation of MySQL and the MySQL installation on your webhost, which would be for your 'live' system.

If you're not sure about the above, you should read the documentation for MySQL at http://www.mysql.com.

[mlm2005]

Hi and thanks for responding.  At this point I have the Coppermine folder/subfolders uploaded to my webserver.  I had already "installed" MySql earlier but this was just a one click installation and the only thing I had to do was enter a password.  I found out the Server, DB, and User info after the fact (by looking at the DB via PhpAdmn and calling my webhost.)  Then I did read up on MySql.com last night and decided to uninstall MySql and PHPAdmin until I can learn more about setting it up. 

My webhost said I should not have renamed the default database but instead should have created a new one.  I searched via Google and found anouther webhost that had done a "tutorial" of setting up a MySql database for use when installing Coppermine.  The problem I have is that my Control Panel looks nothing like this other webhost's control panel (which had fields for creating a new database, adding users and then assigning permissions.  My next step is to see if my Control Panel has this option elsewhere.  I also want to be sure that when I "install" MySql via my Control Panel and assign a password that this is all that is needed to secure the database and that no additional work is needed on my part.

Thanks for your patience as I learn as I go along.

[jpaffett]

What most hosting companies have is a single instance of MySQL server running, which contains n user databases and their control panel will handle just the setting up of your user name and password and a database name. If this is running on the same server as the site, the dbserver will be 'localhost', if it's on another server the dbserver will be that servers IP address. By default this should give all permissions on the named database to the user you created, which is generally fine for Coppermine, unless you want to get tough about security. Once you have the user name and password and database name, you can set up Coppermine.

Jeff