Editing NetHere (section)

=== MySQL     ===


All unixweb-## boxes have MySQL processes running on them. DB provisioning is done on the same server as which hosts the domain.
For Windows 2000 MySQL provisioning, all DBs are placed on ntdb-2.nethere.net


==== MySQL DB provisioning ====


Use https://phpmyadmin.nethere.net 
User: root
PW: <root db pw>

1) Select the server that the DB needs to be hosted on, typically the same server that the website is hosted on.
2) Create the DB
  a) Under "MySQL" - "Create new database" - the DB name is typically the website username; click "Create"
3) Create the User, set permissions for user on DB
  a) Click "Home" (upper left), then click "Privileges" (Under "MySQL")
  b) Click "Add a new User" make sure "Any host" selected, "User name" is typically the website username, "Password" is typically the website password. !LEAVE "Global Privileges" settings deselected! Click "Go" (bottom right corner) when finished.
  c) Under "Database-specific privileges" be sure to add the user database
  d) Select DB, then for "Privileges:" make sure the following are checked:
     Select, Insert, Update, Delete, Create, Alter, Index, Drop, Create Temporary Tables, Lock Tables, References