Welcome to Centmin Mod Community
Become a Member

MariaDB Where to create DB for Xenforo

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

  1. quicksalad

    quicksalad Member

    228
    13
    18
    May 31, 2015
    Ratings:
    +20
    Local Time:
    7:03 AM
    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

    53,614
    12,139
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,683
    Local Time:
    11:33 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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).
     
  3. quicksalad

    quicksalad Member

    228
    13
    18
    May 31, 2015
    Ratings:
    +20
    Local Time:
    7:03 AM
    how about phpMyAdmin? which part does it takes into action?
     
  4. eva2000

    eva2000 Administrator Staff Member

    53,614
    12,139
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,683
    Local Time:
    11:33 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  5. quicksalad

    quicksalad Member

    228
    13
    18
    May 31, 2015
    Ratings:
    +20
    Local Time:
    7:03 AM
    does it mean I can create DB and users via phpMyAdmin web interface?
     
  6. eva2000

    eva2000 Administrator Staff Member

    53,614
    12,139
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,683
    Local Time:
    11:33 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    yup or use mysqladmin_shell.sh which can be run from SSH command line instead
     
  7. quicksalad

    quicksalad Member

    228
    13
    18
    May 31, 2015
    Ratings:
    +20
    Local Time:
    7:03 AM
  8. eva2000

    eva2000 Administrator Staff Member

    53,614
    12,139
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,683
    Local Time:
    11:33 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
     
  9. quicksalad

    quicksalad Member

    228
    13
    18
    May 31, 2015
    Ratings:
    +20
    Local Time:
    7:03 AM
    thanks @eva2000 that cleared my confusion ;)
     
  10. quicksalad

    quicksalad Member

    228
    13
    18
    May 31, 2015
    Ratings:
    +20
    Local Time:
    7:03 AM
    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

    53,614
    12,139
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,683
    Local Time:
    11:33 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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

    228
    13
    18
    May 31, 2015
    Ratings:
    +20
    Local Time:
    7:03 AM
    thanks, hopefully other members in here who uses phpMyAdmin can give advise. :)