Ubuntu/mysql
From r00tedvw.com wiki
- mysql is one of the most popular database applications on the market today
mysql login
mysql -u <user> -p
will then prompt you for a password
mysqladmin login
mysqladmin -u <user> -p
you can also run other commands after -p, such as:
see if the database is running
status
change MySQL root pass
sudo dpkg-reconfigure mysql-server-5.1
verify MySQL is running
sudo netstat -tap | grep mysql
backup wiki mysql database
sudo -s mysqldump -u user -p db.name > wikidatabasebackup.sql i.e. mysql -u wikiuser -p wikidb > /var/www/mediawiki/backup/wikidatabasebackup10_4_12.sql