Welcome to Centmin Mod Community
Become a Member

MariaDB Database Creation Error

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by Itworx4me, Sep 15, 2020.

  1. Itworx4me

    Itworx4me Active Member

    303
    28
    28
    Mar 14, 2017
    Ratings:
    +50
    Local Time:
    10:55 AM
    Nginx 1.25.X
    MariaDB 10.6.X
    Please fill in any relevant information that applies to you:
    • CentOS Version: i.e.CentOS 7 64bit ?
    • Centmin Mod Version Installed: i.e. 123.09beta01
    • Nginx Version Installed: i.e. 1.19.2
    • PHP Version Installed: i.e. 5.3.29
    • MariaDB MySQL Version Installed: i.e. 10.3.24
    • When was last time updated Centmin Mod code base ? : i.e. Up to date
    • Persistent Config: Do you have any persistent config file options set in /etc/centminmod/custom_config.inc ? You can check via this command:
      Code (Text):
      cat /etc/centminmod/custom_config.inc
      

      Post output in CODE tags.
    When trying to run this code:
    ./mysqladmin_shell.sh createuserdb YOURDBNAME YOURDBUSERNAME YOURDBPASSWORD
    I get this error message: -bash: !j: event not found


    Any ideas?
     
  2. eva2000

    eva2000 Administrator Staff Member

    54,524
    12,211
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,780
    Local Time:
    4:55 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    no problems here as per mysqladmin_shell.sh Shell based Addon

    Code (Text):
    cd /usr/local/src/centminmod/addons
    ./mysqladmin_shell.sh createuserdb xdb1 xdbuser1 xdbpass1
    --------------------------------------------------------------
    Basic MySQL Admin - create mysql user & databases 
    --------------------------------------------------------------
    --------------------------------------------------------------
    Grants for xdbuser1@localhost
    GRANT USAGE ON *.* TO `xdbuser1`@`localhost` IDENTIFIED BY PASSWORD '*5D4710D88855F48150B13145945CF7A935B84BE6'
    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON `xdb1`.* TO `xdbuser1`@`localhost`
    Ok: MySQL user: xdbuser1 MySQL database: xdb1 created successfully
    


    maybe your password and/or user has some characters the script doesn't like ?
     
  3. Itworx4me

    Itworx4me Active Member

    303
    28
    28
    Mar 14, 2017
    Ratings:
    +50
    Local Time:
    10:55 AM
    Nginx 1.25.X
    MariaDB 10.6.X
    Ended up being the password with some characters that it didn’t like.