wordpress uninstall script

ahmed · Jul 17, 2020

Hi

I wish to add an option to write the command for

mysqladmin drop ........

so that if the user wish to delete the db also (which is very likely) he will just copy and paste the code

Jimmy · Jul 17, 2020

MYSQLADMIN_SHELL
##############################################################

# ./mysqladmin_shell.sh {multidb|setglobaluser|setuserdb|setpass|createuserdb|deluser|showgrants}

multidb
multiple mysql databse/user creation mode passing a file name containing db, user, pass 3 column entries

setglobaluser
create a mysql username with access to all databases on server without SUPER ADMIN privileges (non-root)

setuserdb
create individual mysql username and databases or assign a new database to an existing mysql username

setpass
change mysql username password

createuserdb
unattended create individual mysql username & databases fields required are dbname dbuser dbpass

deluser
delete a mysql usernames

showgrantS
show existing mysql username granted privileges

CREATEUSERDB
##############################################################

# cd /usr/local/src/centminmod/addons/
# ./mysqladmin_shell.sh createuserdb <database_name> <database_user> <database_password>
Click to expand...

##############################################################
####
#### DATBASE INFO
####
##############################################################

Will show all information about the tables in a database:

# mysql
# use <database>;
# show table status;
Click to expand...

##############################################################
####
#### MANUALLY ADD USERS
####
##############################################################

LIST USERS
##############################################################

# mysql
> SELECT User FROM mysql.user;
or
mysql -e "SELECT User FROM mysql.user;"

CREATE USER
##############################################################

# mysql
> CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';
OR
# mysql -e "CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';"

DELETE USER
##############################################################

# mysql
> DROP USER '<username>'@'localhost';
> FLUSH PRIVILEGES;
OR
# mysql -e "DROP USER '<username>'@'%';"

CHANGE USER PASSWORD
##############################################################

# mysql
> SET PASSWORD FOR '<username>'@'localhost' = PASSWORD('<newpassword>');
> FLUSH PRIVILEGES;

LIST DATABASES
##############################################################

# mysql
# show databases;
OR
# mysql -e "show databases;"

CREATE DATABASE
##############################################################

# mysqladmin -u root -p create <database>

ADD USER PERMISSIONS ON DATABASE
##############################################################

# mysql
> use <database>;
> GRANT ALL PRIVILEGES ON <database>.* TO '<username>'@'localhost';
OR
> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON <database>.* TO '<username>'@'localhost';
> FLUSH PRIVILEGES;
OR
# mysql -e "GRANT select, insert, delete, update, create, drop, alter, create temporary tables, execute, lock tables ON <database>.* TO '<username>'@'localhost'; flush privileges; show grants for '<username>'@'localhost';"

DELETE DATABASE
##############################################################

# mysqladmin -u root -p drop <database>
OR
# mysql -e "DROP DATABASE <database>;"

mysql -e "DROP DATABASE createuserdb;"

Using specific user in Mysql Command Line
# mysql --user=<username> --password=<password> <database>
Click to expand...

Log in / Register

Forums

Welcome to Centmin Mod Community

wordpress uninstall script

ahmed Active Member

Jimmy Well-Known Member

.

Log in / Register

Useful Searches

Welcome to Centmin Mod Community

wordpress uninstall script

ahmed Active Member

Jimmy Well-Known Member

.