Table of contents:
SELECT CONCAT(ROUND(KBS/POWER(1024, IF(PowerOf1024<0,0,IF(PowerOf1024>3,0,PowerOf1024)))+0.49999), SUBSTR(' KMG',IF(PowerOf1024<0,0, IF(PowerOf1024>3,0,PowerOf1024))+1,1)) recommended_innodb_buffer_pool_size FROM (SELECT SUM(data_length+index_length) KBS FROM information_schema.tables WHERE engine='InnoDB') A, (SELECT 2 PowerOf1024) B;
DELETE FROM mysql.user WHERE user = 'root' AND host = 'localhost';
INSERT INTO mysql.user SET user = 'root', host = 'localhost', authentication_string = Password('some_password'), Select_priv = 'y', ssl_cipher = 'y', x509_issuer = 'y', x509_subject = 'y', Insert_priv = 'y', Update_priv = 'y', Delete_priv = 'y', Create_priv = 'y', Drop_priv = 'y', Reload_priv = 'y', Shutdown_priv = 'y', Process_priv = 'y', File_priv = 'y', Grant_priv = 'y', References_priv = 'y', Index_priv = 'y', Alter_priv = 'y', Show_db_priv = 'y', Super_priv = 'y', Create_tmp_table_priv = 'y', Lock_tables_priv = 'y', Execute_priv = 'y', Repl_slave_priv = 'y', Repl_client_priv = 'y', Create_view_priv = 'y', Show_view_priv = 'y', Create_routine_priv = 'y', Alter_routine_priv = 'y', Create_user_priv = 'y', Event_priv = 'y', Trigger_priv = 'y', Create_tablespace_priv = 'y';
skip_grant_tables
under my.cnfskip-networking
or bind-address = 127.0.0.1
to my.cnfselect User, Host from mysql.user;
SHOW PROCEDURE STATUS where db = 'dbname';
SHOW CREATE PROCEDURE dbname.procedurename \G
CALL procedure_name;