Welcome to Centmin Mod Community
Register Now

MariaDB Where to create DB for Xenforo

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by quicksalad, Jun 8, 2015.

  1. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    10:30 PM
    I already installed PHPMyAdmin, now I'm on the way to install Xenforo. Where can I create DB username and password during installation of the software? Can i use root? Please advise.. Thanks
     
  2. eva2000

    eva2000 Administrator Staff Member

    30,945
    6,914
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,411
    Local Time:
    3:00 AM
    Nginx 1.13.x
    MariaDB 5.5
    For creating MySQL databases and MySQL username and password you have a few options all outlined via the following linked information (including mysqladmin_shell.sh addon below).
     
    • Informative Informative x 1
  3. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    10:30 PM
    how about phpMyAdmin? which part does it takes into action?
     
  4. eva2000

    eva2000 Administrator Staff Member

    30,945
    6,914
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,411
    Local Time:
    3:00 AM
    Nginx 1.13.x
    MariaDB 5.5
    • Informative Informative x 1
  5. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    10:30 PM
    does it mean I can create DB and users via phpMyAdmin web interface?
     
  6. eva2000

    eva2000 Administrator Staff Member

    30,945
    6,914
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,411
    Local Time:
    3:00 AM
    Nginx 1.13.x
    MariaDB 5.5
    yup or use mysqladmin_shell.sh which can be run from SSH command line instead
     
    • Informative Informative x 1
  7. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    10:30 PM
  8. eva2000

    eva2000 Administrator Staff Member

    30,945
    6,914
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,411
    Local Time:
    3:00 AM
    Nginx 1.13.x
    MariaDB 5.5
     
    • Informative Informative x 1
  9. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    10:30 PM
    thanks @eva2000 that cleared my confusion ;)
     
  10. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    10:30 PM
    by checking on the via phpMyAdmin, I see "No" on users grant field. I checked the privileges all is unchecked. While running
    /root/tools/mysqladmin_shell.sh showgrants tells below.

    ---------------------------------------------------------------------+
    | GRANT USAGE ON *.* TO 'username'@'localhost' IDENTIFIED BY PASSWORD '*rwerwerwerwerwerwerwerwerwr' |
    | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TA BLES, LOCK TABLES, EXECUTE ON `dbname`.* TO 'username'@'localhost' |
    +-------------------------------------------------------------------------------

    seeing the output, the grant select, insert etc is ON but it's different on phpMyAdmin users tab. Please advise. Thanks
     
  11. eva2000

    eva2000 Administrator Staff Member

    30,945
    6,914
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,411
    Local Time:
    3:00 AM
    Nginx 1.13.x
    MariaDB 5.5
    i never use phpmyadmin for such user privileges so no idea what phpmyadmin users show.. i use mysqladmin_shell.sh commands usually done manually via SSH
     
  12. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    10:30 PM
    thanks, hopefully other members in here who uses phpMyAdmin can give advise. :)