Display Mysql database size in MB Query SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;

1. Removing users from the database. DROP USER 'USERNAME'@'HOSTNAME'; 2. Creating users – 3 common ways: A) The default way: CREATE USER 'USERNAME'@'HOSTNAME' IDENTIFIED BY 'USERPASSWORD'; B) As an insert statements: INSERT INTO `mysql`.`user` (Host,User,Password) VALUES('localhost','dummy',''); FLUSH PRIVILEGES; #it is neccessary, when creating users this way C) Batch adding users. Create a file (useradd.sql for example) which contains all create users statements : CREATE USER 'USERNAME'@'HOSTNAME' IDENTIFIED BY 'USERPASSWORD'; GRANT SELECT ON `DATABASE`. ...

To remove all leading and trailing whitespaces : UPDATE `table_name` SET `column`=trim(`column`); To remove only the trailing whitespaces : UPDATE `table_name` SET `column`=trim(TRAILING ' ' FROM `column`); The above example could be used to remove any character or characters from the begging or end of a text field. For more examples look into mysql function reference.

Recover root password for mysql

Backing up MySQL database mysqldump – a quick way to dump small databases using sql files Make a backup of One database mysqldump --default-character-set=utf8 -u db_user -p -h db_host db_name > dump_file.sql Make a backup of All databases mysqldump --default-character-set=utf8 -u db_user -p -h db_host -all-databases > dump_file.sql Include routines,triggers and events mysqldump --default-character-set=utf8 --single-transaction --set-gtid-purged=OFF --add-drop-database --triggers --routines --events -u db_user -p -h db_host db_name > dump_file. ...