This is simple, run the below query This will list all the databases and show their size in Mb. Similarly we can get the size of tables in a particular database as
Category Archives: MySQL
RDS Mariadb Grant All permission access denied for user
This is a peculiar error with Mariadb on RDS, this problem does not happen if you select the MySQL or Aurora Engine. If you try to run a GRANT ALL ON query you get an error like
AWS RDS You do not have the SUPER Privilege and Binary Logging is Enabled
When importing a mysql database dump to RDS you receive this error “You do not have the SUPER Privilege and Binary Logging is Enabled”. This usually happens when your database has views or triggers defined. Although MySQL/Mariadb/Aurora RDS supports them but they are disabled by default. Lets see how we can enable them.
MySQL 5.7 Reset root password
With mysql 5.7 the mysql.user table do not have the Password column, it has been replaced by the authentication_string column. Another notable difference is the plugin column, which allows for different authentication methods. In Ubuntu 18.04 LTS and later release the default authentication plugin/method for root user is auth_socket. This plugin uses the SO_PEERCRED socket […]
Running multiple MySql servers with mysqld_multi
Concept Sometime there are are situations when we require to run multiple MySql servers on same server for example, two group of developers working on separate projects where they may need to have database with different setting for e.g sql_mode or innodb-file-format or any others.We can either install separate MySQL servers or they make use […]