Building your own SMTP server
https://www.linode.com/docs/email/postfix/email-with-postfix-dovecot-and-mysql/#dovecot
Category: MySQL
Mysql DB allowing old user from different IP with same grants
Firstly, We have to create a new user from different ip , so we have to run the below command. The first “Select” query is to get all column in user table and the...
Mysql Procedure creation
Procedure Creation Example MariaDB [stress]> DELIMITER ;; MariaDB [stress]> CREATE PROCEDURE ABC() -> BEGIN -> WHILE 1 -> DO -> SELECT COUNT(*) FROM stresstable; -> DO SLEEP(1); -> END WHILE; -> END;; MariaDB [stress]>...
MysqlDump without locking Tables
# dumping data without lock table mysqldump -u[USER] -p[PASS] –skip-lock-tables –single-transaction –flush-logs –hex-blob –master-data=2 –max_allowed_packet=1G globe_sdp > globe_sdp_v2.sql
Server & Sql Monitoring (PMM-Server)
Hi, i’ve recently created a pmm-server ( monitoring system for server & mysql ). A pmm-server act as a server and client can connect to pmm-server to look on their information by using the...
How to dump and import sql into mysql (Command Line)
#EXPORT mysqldump -u {USER} -h {IP} -p {DB_NAME} {DB_TABLE (OPTIONAL)} | gzip > dump.sql.gz #IMPORT CREATE DATABASE {DB_NAME} mysql -u {USER} -h {IP} -p {DB_NAME} < dump.sql option:- -d : to dump only table...
mysql replace character
UPDATE game SET g_game_path = REPLACE(g_game_path,”s1.g”,”um”); For the query above, is to update the “game” table , to replace g_game_path’s “s1.g” into “um”
MYSQL INSERT INTO SELECT
To select data from table a to insert into b INSERT INTO ‘DB_NAME’.’TABLE_NAME'(TABLE_FIELD) SELECT ‘FIELDS_TO_INSERT_MUST_BE_TELE_WITH_INSERT_FIELD’ FROM ‘DB_NAME’.’TABLE_NAME’ WHERE (CONDITION);
Mysql root password change
1.Stop mysql service 2.then run this command mysqld_safe –skip-grant-tables & 3.mysql -u root 4.Run Below Command:- use mysql; update user set password=PASSWORD(“mynewpassword”) where User=’root’; flush privileges; quit 5.stop start mysql service and you’re good...
Master slave mysql configuration
https://www.stephenrlang.com/2016/08/setting-up-mysql-master-slave-replication-with-xtrabackup/
