Posts in 2022

Posts in 2019

  • Mysql Mariadb Set Update Password

    Saturday, November 30, 2019 in MySQL

    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 …

    Read more

Posts in 2017

  • MySQL MariaDB Export and Import

    Tuesday, December 26, 2017 in MySQL

    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 \ …

    Read more

  • MySQL MariaDB Create User

    Tuesday, December 26, 2017 in MySQL

    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; …

    Read more

  • MySQL MariaDB utf8 to utf8mb4

    Monday, December 25, 2017 in MySQL

    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: …

    Read more

  • MySQL MariaDB Set utf8mb4 as default charset

    Wednesday, November 22, 2017 in MySQL

    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%'; …

    Read more

  • Install Mariadb in Aws Ec2

    Wednesday, November 22, 2017 in MySQL

    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 …

    Read more