Blog Archives

Create MySQL Database, User And Password On The Terminal

MySQL terminal We are going to create a new database, user and password and grant that user access to the new database. Let’s first login to MySQL in the terminal.

Hit return and that will log you in, provided

Tagged with: , ,
Posted in System Admin, Web Development

Speed Up Your Database Using MySQL Query Cache

MySQL 5.1.69 Modern web applications place a massive load on the database. I’ve been working extensively with Magento lately and the demand on the database is enormous. We could argue all day about which language is easier on the database

Tagged with: ,
Posted in MySQL, System Admin, Web Development

MySQL Dump Script For Database Backups

Mac OS X (10.6.8), CentOS, Linux Do you perform regular database backups? Maybe you take copies of your live database and push that data somewhere else (like, your staging site)? And maybe you’ve accidentally overwritten your live database coz you

Tagged with: , , ,
Posted in MySQL, System Admin, Web Development
Tech Talk?

These articles hope to offer insight and solutions to some of the techie problems out there!

They say sharing is caring, so if you find these useful, please share (and comment). Thanks.

By Category