By samwarren on

Please bear with me if my question is too simple.
I have created the mysql database for my drupal6 site at localhost. I just created the database and start using it. The local site works fine. I know I didn't specifically GRANT anything. I don't see any problem after several months testing. I just checked with MysqlAdmin, there is only one user "root", and it has no Assigned Privileges to my drupal database. My questions are:
1) Will there any problem if I put my site to live host like this?
2) Is this because I installed the mysql locally, that I automatically have all the privileges without specifically saying it?
3) Should I GRANT privileges anyway, even it seems have no effect?

Please help me to clear the confusion.

⋅ Categories: Drupal 6.x

Comments

zbricoleur’s picture

zbricoleur commented

Is the live site going to be on your own server, or on shared hosting somewhere?

If it's to be shared hosting, you will not be able to connect as root. The ISP will not allow that; they will give you (or you will create--depends on the ISP) a username/pwd for your database. You will need to change your settings.php file to reflect the new username, password, database name, and host.

If it's to be your own server, you would still be well advised not to run your Drupal site as 'root.' Better to create a new user with the necessary permissions and, again, modify your settings.php file accordingly.