Rainsbrook - mysql

bashqueries

Anonymous (anonymous@undisclosed.example.com) — 2025-02-21T09:36:16+00:00

Run queries from BASH BASH is not used often for interrogating a database, but it can be done. It would not be regarded as secure to have passwords embedded in the command, but this can be extracted to a file protected by appropriate permissions. Of course the

general

Anonymous (anonymous@undisclosed.example.com) — 2026-03-18T15:19:06+00:00

MySQL General Info Log in to mysql monitor Using mysql monitor:- # mysql -h 127.0.0.1 -u dbuser -pletmein Note, if you are giving a password on the command line, do not add a space between -p and the password. -h is not necessary if you are logging in to the same machine you are working on.

links

Anonymous (anonymous@undisclosed.example.com) — 2023-09-20T10:48:03+00:00

Web Links SQL designer:-

mysql-commands

Anonymous (anonymous@undisclosed.example.com) — 2022-04-06T10:38:03+00:00

MySQL Commands Log in to MySQL command shell To log in to the MySQL command shell, use:- mysql -u #username# -p You will be prompted to enter the password for #username# Basic commands mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | test | +--------------------+ 3 rows in set (0.00 sec)

mysql-rootpasswordreset

Anonymous (anonymous@undisclosed.example.com) — 2022-04-06T10:39:48+00:00

MySQL Password Reset Reset the root MySQL password * Stop mysqld and restart it with the '--skip-grant-tables' option. This enables anyone to connect without a password and with all privileges. * Connect to the mysqld server with this command:

mysql-stuff

Anonymous (anonymous@undisclosed.example.com) — 2022-04-06T10:41:19+00:00

MySQL General Info Initial setup Recommended to run following script after starting mysqld (service mysqld start & chkconfig mysqld on) /usr/bin/mysql_secure_installation Dump database to sql file /usr/bin/mysqldump -u #username# -p --add-drop-database #database# > #dump_file.sql#

percona_mysql_replication

Anonymous (anonymous@undisclosed.example.com) — 2024-12-23T12:56:55+00:00

Percona MySQL MySQL version Server version: 5.5.34-32.0-log Percona Server (GPL), Release 32.0 Storage engine is InnoDB. to re-download the exact version that we are using on the Production database servers: Backup commands from db on Linode Included for reference only

perfmonitor

Anonymous (anonymous@undisclosed.example.com) — 2026-03-18T14:10:44+00:00

Nagios MySQL Performance Data This is the config used to allow nagios user to connect over the network in order to extract performance data. Create user mysql> GRANT usage ON *.* TO 'nagios'@'10.10.10.0/255.255.255.0' IDENTIFIED BY 'password'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT usage ON *.* TO 'nagios'@'localhost' IDENTIFIED BY 'password'; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql>

start

Anonymous (anonymous@undisclosed.example.com) — 2023-09-20T10:46:34+00:00

MySQL Pages in this namespace: * bashqueries * general * links * mysql-commands * mysql-rootpasswordreset * mysql-stuff * percona_mysql_replication * perfmonitor * start * tablesizecheck

tablesizecheck

Anonymous (anonymous@undisclosed.example.com) — 2016-02-24T16:00:35+00:00

Check Table sizes between replication master and slave #!/bin/bash # Written Andrew Stringer 01/02/2015 # Purpose is to check table sizes on a master and slave replication server # to ensure they are the same size prior to swapping slave to master. #$1 should be the database to test if [ "$1" = "" ] then echo "Usage compare-table-size.sh [databaase name]" exit 1 fi MASTER='primarydb.example.pri' SLAVE='slavedb.example.pri' DATABASE=$1 #Get list of tables in databas…