How to Create MySQL database and user | Here is quick way to create a MySQL database and user. This is useful for WordPress, Drupal, or other LAMP apps. Login to MySQL with the MySQL root password: $ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version:
Monitor MySQL Performance with mytop | mytop is an excellent app to monitor mysql performance. Let’s check it out! Firstly, install mytop: $ sudo apt-get install mytop Run mytop with tack tack prompt to have mytop prompt for the root mysql password: $ mytop –prompt Done! You can now monitor the number of mysql queries the server is processing as well
PHP 5.4 Packages for Red Hat | Red Hat Enterprise Linux is an excellent stable distro for mission critical enterprise environments. However the PHP and MySQL versions included are a tad behind mainstream. There is a great community repository from Rackspace that offers recent PHP, MySQL, and Python versions for Red Hat. The project page is: http://iuscommunity.org For Red Hat 5 and
TechSNAP 82 Viewer Feedback – scottlinux | Thanks Chris and Allan,
A Closer Look at WordPress Password Hashes | Check out this write up on WordPress password hashes: A Closer Look at WordPress Password Hashes If you find this topic interesting, you may also be interested in Expert Pen Testing or CISSP training. Check it out!
GUI for sqlmap | An excellent python based GUI for sqlmap is available here: https://code.google.com/p/gui-for-sqlmap/ On Debian or Ubuntu, here is how to install: $ sudo apt-get install python-tk python2.7 sakura $ git clone git://github.com/sqlmapproject/sqlmap.git $ cd sqlmap $ wget http://gui-for-sqlmap.googlecode.com/files/sqm-17612.zip $ unzip sqm-17612.zip $ python2.7 sqm.pyw Cool!
Use mysqlcheck to Optimize and Repair MySQL Databases | mysqlcheck is a simple command line app that can check mysql databases for corruption, make repairs, and also optimize your databases. Here are three quick commands that are useful to check, optimize, and also repair your mysql databases! 1. Check Databases $ mysqlcheck -cA -u root -p (-c for check database, -A for all databases)
MySQL my.cnf Performance Tuning | Debian and Ubuntu include a package called mysqltuner which can analyze your MySQL database and provide some performance metrics as well as tuning advice for my.cnf. Here is how it works! Install mysqltuner: $ sudo apt-get install mysqltuner Run the app, it will prompt for your MySQL admin credentials. Looks like I need to bump
Add Professional Looking Theme to phpMyAdmin | phpMyAdmin is the great web-based mysql administration tool. To enhance the appearance of phpMyAdmin, install the clear and modern looking theme pmamhomme. Here is a quick peek! This theme is called pmamhomme because the theme designer is Mike Homme. First, grab the pmamhomme theme (.zip) from phpmyadmin.net’s theme page. Next, unzip this in phpMyAdmin’s theme
How to MySQL Dump and Recovery | MySQL has the ability to dump or backup an entire database to a single recoverable file. I’ll show you how to dump and also recover! Dump a MySQL database To dump a mysql database, the command is: $ mysqldump -u mysqlusername -p databasename > mybackup.sql Enter password: (enter your mysqlusername’s mysql password) For example if