Discover Centmin Mod today
Register Now

mysqladmin_shell.sh Shell based Addon

Discussion in 'Add Ons' started by eva2000, Jun 23, 2014.

  1. eva2000

    eva2000 Administrator Staff Member

    30,163
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    3:00 PM
    Nginx 1.13.x
    MariaDB 5.5
    if you use https://strongpasswordgenerator.com/ you can generate passwords with advanced options to avoid punctuation used in programming languages

    upload_2017-5-10_14-17-3.png
     
    • Winner Winner x 1
    • Informative Informative x 1
  2. Jimmy

    Jimmy Premium Member Premium Member

    1,114
    247
    63
    Oct 24, 2015
    East Coast USA
    Ratings:
    +596
    Local Time:
    1:00 AM
    1.13.x
    MariaDB 10.1.x
    • Agree Agree x 1
  3. eva2000

    eva2000 Administrator Staff Member

    30,163
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    3:00 PM
    Nginx 1.13.x
    MariaDB 5.5
    Yeah use that online generator whenever i need to for stuff :)
     
  4. noly

    noly Premium Member Premium Member

    69
    10
    8
    Jul 24, 2017
    Frankfurt/Germany
    Ratings:
    +20
    Local Time:
    7:00 AM
    1.13.x
    10.x
    Hmmm...strange...

    Code (Text):
    cd /usr/local/src/centminmod/addons/
    
    ./mysqladmin_shell.sh createuserdb xdb1 xdbuser1 xdbpass1

    creates a db named "createuserdb" instead of xdb1.

    Syntax or Bug?
     
    Last edited: Jul 30, 2017
    • Informative Informative x 1
  5. eva2000

    eva2000 Administrator Staff Member

    30,163
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    3:00 PM
    Nginx 1.13.x
    MariaDB 5.5
    could be a bug, will look into it :)
     
    • Like Like x 1
  6. noly

    noly Premium Member Premium Member

    69
    10
    8
    Jul 24, 2017
    Frankfurt/Germany
    Ratings:
    +20
    Local Time:
    7:00 AM
    1.13.x
    10.x
    Oh....i just recognized that my fresh phpmyadmin throws these messages...

    Code:
    The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
    Or alternately go to 'Operations' tab of any database to set it up there.
    Code:
    Configuration of pmadb... not OK
    General relation features Disabled
     
    Last edited: Jul 30, 2017
    • Informative Informative x 1
  7. eva2000

    eva2000 Administrator Staff Member

    30,163
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    3:00 PM
    Nginx 1.13.x
    MariaDB 5.5
    bug fixed in 123.09beta01 Beta Branch - fix addons/mysqladmin_shell.sh createuserdb option bug

    Code (Text):
    ./mysqladmin_shell.sh createuserdb xdb2 xdbuser2 xdbpass2
    --------------------------------------------------------------
    Basic MySQL Admin - create mysql user & databases
    --------------------------------------------------------------
    --------------------------------------------------------------
    
    Grants for xdbuser2@localhost
    GRANT USAGE ON *.* TO 'xdbuser2'@'localhost' IDENTIFIED BY PASSWORD '*3399103BC71C868431660AC2C4B2128D4002C5BB'
    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE ON `xdb2`.* TO 'xdbuser2'@'localhost'
    
    Ok: MySQL user: xdbuser2 MySQL database: xdb2 created successfully
    
     
  8. noly

    noly Premium Member Premium Member

    69
    10
    8
    Jul 24, 2017
    Frankfurt/Germany
    Ratings:
    +20
    Local Time:
    7:00 AM
    1.13.x
    10.x
    Thank you @eva2000 .

    Can't really tell you how to exactly reproduce it but during testing sometimes it worked flawless and sometimes i got an error when adding, deleting and adding a user again:

    Code (Text):
    --------------------------------------------------------------
    Basic MySQL Admin - create mysql user & databases
    --------------------------------------------------------------
    --------------------------------------------------------------
    
    ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'dbuser'@'localhost'
    
    Error: command was unsuccessful


    Here is a possible solution:
    ERROR 1396 (HY000): Operation CREATE USER failed for 'jack'@'localhost'
     
  9. eva2000

    eva2000 Administrator Staff Member

    30,163
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    3:00 PM
    Nginx 1.13.x
    MariaDB 5.5
    yes FLUSH PRIVILEGES is needed after deleting. Known procedure :)

    mysqladmin_shell.sh already does this
     
    • Like Like x 1