MySQL Command

CREATE DATABASE NAme of the Database;
SHOW Databases;
CREATE USER ‘Name of User’@’localhost’ IDENTIFIED BY ‘Password’;
GRANT ALL PRIVILEGES ON actressi_dbinbollwood TO ‘actressi_dbinbollwood’@’localhost’;
mysqldump -u tbsingerdev -p tbsingerdev > tbsingerdev.sql
mysql -u tbdev -p Singer_Tbclone < singerbdmagento_testdb_live.sql
GRANT ALL ON phpmyadmin.* TO singerbdmagento_testdb@’157.245.50.42′ IDENTIFIED BY ‘TBSingerbdDev@2020’;
GRANT ALL ON phpmyadmin.* TO singerbdmagento_testdb@’localhost’ IDENTIFIED BY ‘TBSingerbdDev@2020’;
SHOW GRANTS FOR ‘phpmyadmin’@’localhost’;
SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘singerbdmagento_testdb’;
SELECT count(*) AS TOTALNUMBEROFTABLES FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘singerbdmagento_testdb’;
service mysql restart
service mysql status
SELECT DISTINCT `name`, `email` , `themecafe_mobile` FROM `s_customer_grid_flat` WHERE `themecafe_mobile` LIKE ‘%0%’
SELECT * FROM `s_customer_entity` WHERE `email` like ‘%qq%’
SELECT * FROM `s_customer_entity` WHERE `name` like ‘%众%’
DELETE FROM `s_customer_entity` WHERE `name` like ‘%【q860-l88-3O6】’ 众高 qq tgraph singo icu mony 费 60O4 www .ru
DELETE FROM `s_customer_grid_flat` WHERE `name` like ‘%.ru%’
DELETE FROM `s_customer_entity` WHERE `name` like ‘%qq%’
DELETE FROM `s_customer_grid_flat` WHERE `email` like ‘%qq.com’ AND `entity_id` BETWEEN 289410 AND 289416;
SELECT * FROM `s_customer_entity` WHERE `email` like ‘%qq%’ WHERE ROWNUM <= 3;
echo X | telnet -e X 202.54.10.20 3306
update db set Host=’206.189.46.115′ where Db=’tbsingerdev’;
SELECT * FROM `s_core_config_data` WHERE `config_id` = 2;
UPDATE `s_core_config_data` SET value=’http://etihash.com’ WHERE `config_id` = 2;