mysqladmin_shell.sh Shell based Addon

if you use https://strongpasswordgenerator.com/ you can generate passwords with advanced options to avoid punctuation used in programming languages

---

 

Yeah use that online generator whenever i need to for stuff

 

could be a bug, will look into it

 

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

 

yes FLUSH PRIVILEGES is needed after deleting. Known procedure

mysqladmin_shell.sh already does this

 

Reminder when creating database names make sure you do not use hyphens on invalid identifier characters in the names. For database names and tables, hyphens aren't really a valid mysql identifiers allowed MySQL :: MySQL 5.6 Reference Manual :: 9.2 Schema Object Names. Underscores yes, hyphens no.

 

none right now those some of it's available in my own mysqlmymonlite.sh script at mysqlmymonlite.sh Addon

Code (Text):

/root/tools/mysqlmymonlite.sh dblist

mysql performance_schema

and dbbackup.sh MariaDB - dbbackup.sh - quick mysql database backups for Centmin Mod stack

Code (Text):

/root/tools/dbbackup.sh dblist
+--------------------+
| Database           |
+--------------------+
| db1                |
| db2                |
| db3                |
| db4                |
| db5                |
| db6                |
| information_schema |
| mysql              |
| performance_schema |
+--------------------+

Code (Text):

/root/tools/dbbackup.sh dbinfo 
                         db1 [idx: 0.00 MB data: 0.00 MB]
                         db2 [idx: 0.00 MB data: 0.00 MB]
                         db3 [idx: 0.08 MB data: 0.11 MB]
                         db4 [idx: 1.72 MB data: 7.52 MB]
                         db5 [idx: 0.25 MB data: 1.52 MB]
                         db6 [idx: 0.78 MB data: 5.52 MB]
  verylongdbnameexampletested [idx: 0.00 MB data: 0.00 MB]

 

that could be a possibility eventually

 

updated Centmin Mod 130.00beta01's addons/mysqladmin_shell.sh 0.1.2 setuserdb menu option for a 3rd and 4th option for adding an existing database name to existing MySQL username or adding an existing database to a new MySQL username. Full details and updated documentation at https://community.centminmod.com/threads/mysqladmin_shell-sh-shell-based-addon.543/

 

fixed in latest 130.00beta01 update

new exit keyword

Code (Text):

./mysqladmin_shell.sh deluser
--------------------------------------------------------------
Basic MySQL Admin - create mysql user & databases
--------------------------------------------------------------
--------------------------------------------------------------
---------------------------------
Delete MySQL username:
---------------------------------
 Enter MySQL username you want to delete (type exit to abort): exit
 Aborted: No MySQL username entered

empty input

Code (Text):

./mysqladmin_shell.sh deluser
--------------------------------------------------------------
Basic MySQL Admin - create mysql user & databases 
--------------------------------------------------------------
--------------------------------------------------------------
---------------------------------
Delete MySQL username:
---------------------------------
 Enter MySQL username you want to delete (type exit to abort): 
 Aborted: No MySQL username entered

 

setpass should work for all MySQL usernames except MySQL root user.