This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

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
Thanks given by:
#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
Thanks given by: RamboMambo


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

Forum Jump:


Users browsing this thread: 1 Guest(s)