Posts in 2022
-
Export AWS RDS From One Account to Another Account or Region
Wednesday, August 03, 2022 in MySQL
Categories:
2 minute read
Take a snapshot of the RDS Open AWS RDS console in the source account https://console.aws.amazon.com/rds/home Make sure you are in correct region Select the required instance Click Actions -> Take snapshot Enter a name for snapshot Click Take …
Posts in 2019
-
Mysql Mariadb Set Update Password
Saturday, November 30, 2019 in MySQL
less than a minute
Using mysqladmin CLI If you installed the db with empty password then set the password sudo mysqladmin password "<<new-password>>" -- OR mysqladmin --user=root password "<<new-password>>" Change the existing …
Posts in 2017
-
MySQL MariaDB Export and Import
Tuesday, December 26, 2017 in MySQL
2 minute read
Export the database Use the following command to export the database mysqldump --user=<<db-user>> --password=<<db-password \ --host=<<db-host>> --port=3306 \ --single-transaction --compress --routines \ …
-
MySQL MariaDB Create User
Tuesday, December 26, 2017 in MySQL
less than a minute
Create a user similar to root To create user with all the privileges similar to root. CREATE USER 'superuser'@'%' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'superuser'@'%' WITH GRANT OPTION; …
-
MySQL MariaDB utf8 to utf8mb4
Monday, December 25, 2017 in MySQL
less than a minute
Change server settings Refer: https://yottabrain.org/blog/database/mysql/mysql-mariadb-set-utf8mb4-as-default-charset/ on AWS RDS a parameter group needs to be created to apply above settings: refer: …
-
MySQL MariaDB Set utf8mb4 as default charset
Wednesday, November 22, 2017 in MySQL
2 minute read
By default charset is set to to latin1 and utf8. This can be checked by executing the following command MariaDB [(none)]> SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%'; …
-
Install Mariadb in Aws Ec2
Wednesday, November 22, 2017 in MySQL
Categories:
2 minute read
These steps can be used install mariadb on any Ubuntu based Linux system (local desktop, aws ec2, etc.) Install MariaDB Execute the following commands: curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash sudo apt install …