Creating database
#1
Creating database
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?
Reply
#2
RE: Creating database
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
My Sentora Resources
[Module] Mail Quota Count | Vagrant Box with Sentora

[Image: vanguardly-logo-micro.png]
Graphic and Web Design. Development.
www.vanguardly.com


Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
MySQL Database user prefix MosleyCale 1 6 ,677 10-17-2020, 09:11 PM
Last Post: Ron-e
Critical Error: [0100] - Unable to connect or authenticate to the Sentora database whatshisface77 1 5 ,461 07-31-2020, 10:58 AM
Last Post: whatshisface77
repo browser Critical Error: [0144] - Sentora database 'query' error (42000). zustudios 0 5 ,003 12-21-2019, 08:08 AM
Last Post: zustudios

Forum Jump:


Users browsing this thread: 1 Guest(s)