Delete user

mysql
DROP USER 'user'@'localhost';

List of all users

mysql
SELECT host,user,plugin,host FROM mysql.user;

Rename database

To rename database you need to create new database and dump old database into the new, you can use a script to execute this

~/bin/rename_database.sh
#!/bin/bash
set -e # terminate execution on command failure

mysqlconn="mysql -u root -ppassword"
olddb=$1
newdb=$2
$mysqlconn -e "CREATE DATABASE $newdb"
params=$($mysqlconn -N -e "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES \
                           WHERE table_schema='$olddb'")
for name in $params; do
      $mysqlconn -e "RENAME TABLE $olddb.$name to $newdb.$name";
done;
$mysqlconn -e "DROP DATABASE $olddb"

sh ~/bin/rename_database.sh old_database new_database
Edit this page on GitHub
Table of Contents