Sentora Support Forums

Full Version: Creating database
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
hi when creating mysql database and mysql user for example

zadmin_xxx

and user

yyy

then when click map database i choose zadminxx to join with yyy user, its that correct?
I believe that is correct.

The correct way is:
  1. Menu: Database > MySQL Database
  2. Create a new MySQL database :
    | Database name: zadmin_exampledb
  3. Menu: Database > MySQL Users
  4. Create a new MySQL user :
    | User name: myexample
    | Map Database: zadmin_[b]exampledb[/b])
    | Remote Access: Allow from any IP
You can also add more than one Database to the same user:
  1. Menu: Database > MySQL Users
  2. Select the user myexample (click on "Edit")
  3. Add Database
    | Database: zadmin_testdb

I hope this helped you Smile