Braindump:
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 ;
Tag: database
Changing the MySQL root password
just so I don’t forget it …
(still need it EVERYTIME I set up a new server *sigh*)
root@u-1:/home/u-1# mysql -u root mysql
mysql> SET PASSWORD FOR root@localhost=PASSWORD('whatever');