Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

MySQL Root Password Recovery

Having trouble with a lost MySQL root password or root login not working?
Here's a step-by-step MySQL Root Password Recovery tutorial.
./M6

Painless Django Kickoff

I'm learning Django and, so far, I'm enjoying it.
But putting it to work, as a simple development environment on my laptop, was harder than I expected. Specially when it came to install the MySQL-Python connector.

If you'r looking for a great step-by-step tutorial, I recommend Starting a Django 1.6 Project the Right Way.

If you're starting with Django, or are having trouble setting Python with MySQL, maybe this will help: Painless Django with MySQL Install.

./M6

MySQL Partitioning

I was researching about MySQL performance for a new web project when I came across whit partitioning.

After reading Improving Database Performance with Partitioning and MySQL Partitioning, I thought "this is great, I'll use it", but after reading MySQL partitions tutorial, and since I'm using InnoDB, I though "maybe this is not such a good idea since storage may be a problem and the performance boost may not be that significant for this project".

In short, one has to perform some tests in order to decide.
./M6

Common MySQL Queries

While looking for a MySQL Rank function, which does not currently exist, I've found this useful Common MySQL Queries.

./M6