Stop MySQL server /etc/init.d/mysql stop Edit MySQL config file vi /etc/mysql/my.cnf Comment out following lines (or add/change the IP to reflect your desired access) #bind-address = Start mysql server /etc/init.d/mysql start Grant privileges (edit username & password. Note ‘%’ is IP wildcard) grant all privileges on “.” to ‘username’@’%’ identified by ‘password’ with grant […]

To get the current database size just by querying into your query browser or CLI from the INFORMATION_SCHEMA database in table TABLES. SELECT table_schema “Data Base Name”, sum( data_length + index_length ) / 1024 / 1024 “Data Base Size in MB” FROM information_schema.TABLES GROUP BY table_schema ; Get the database free space SELECT table_schema “Data […]

Article/Credits from: TheGeekStuff In MySQL, when you are using InnoDB, all the tables and indexes are stored under the MySQL system tablespace. MySQL system tablespace is ibdata1, which is located under /var/lib/mysql The single ibdata1 file contains all the tables and indexes in your MySQL database. So, if you have a big database, this file size […]