MySql – Create read-only user
March 21st, 2012 by Youzhny
Most useful for second or third level support people where people have skills to check db directly but in case you do not want them to make changes, Read only user can be created for them in Mysql DB. (more…)
Common Useful MySQL Commands
March 8th, 2012 by Youzhny
Basic description of what will be done and what is expected. (more…)
How-to config MySQL Master/Slave Replication
December 29th, 2011 by Youzhny
How To Set Up Database Replication In MySQL
This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy...Create and Delete Users in MySQL
December 29th, 2011 by Youzhny
MYSQL which forms the M of the LAMP series is a widely used open source relational database management system (RDBMS).
While working on a project, i learnt that some of the developers who were too much addicted with tools like PhpMyAdmin didn’t actually know how to create / delete users from a command line. For the information of them and for all others, this is the post to read. (more…)
MySQL root Password Change and Reset for GNU/Linux
May 17th, 2011 by Youzhny
MySQL root Password Change and Reset for GNU/Linux
Other then the ways specified here to reset and change the root password for mySQL database in the case that the password is forgotten or lost, the following instructions explain in details the alternative way at the last part of the guide, where no additional file needs to be created:
(more…)
jQuery: Toggling select boxes when one changes
November 30th, 2010 by VarIncart
I was asked a couple of days ago on my get and set form values with jQuery post how to make a secondary select box appear with jQuery when the first one is changed. The first might contain a list of countries and the second one some cities which changes as the country changes, allowing the user to select both their country and city. This post shows how to do this with several hidden sub-selects, and...
Installing Apache2 With PHP5 And MySQL Support On Fedora 14 (LAMP)
November 28th, 2010 by jennyamy
Installing Apache2 With PHP5 And MySQL Support On Fedora 14 (LAMP)
LAMP is short for Linux, Apache, MySQL,
PHP. This tutorial shows how you can install an (more…)
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Fedora 14 x86_64)
November 28th, 2010 by jennyamy
Virtual Users And Domains With Postfix, Courier, MySQL And
SquirrelMail (Fedora 14 x86_64)
This document describes how to install a Postfix mail server that is
based on virtual users and domains, i.e. users and domains that are in a
MySQL database. I’ll also demonstrate the installation and
configuration of Courier (Courier-POP3, Courier-IMAP), so that Courier (more…)
Multi-DB Plugin Updated For Improved WordPress Multisite Scaling
November 25th, 2010 by Youzhny
Our Multi-DB plugin allows for massive scaling of your WordPress Multisite network to hundreds, even thousands of sites. It allows you to split your single database into 16, 256 or 4096 database – and if you are using cPanel, even incorporates a script that will do that for you.
We’ve recently taken it up a couple notches with improvements that will help to keep everything running smoothly.
What...
SQL Quiz
November 12th, 2010 by aBisona
You can test your SQL skills with W3Schools’ Quiz.
The Test
The test contains 20 questions and there is no time limit.
The test is not official, it’s just a nice way to see how much you know, or don’t know, about SQL.
Your Score Will be Counted
You will get 1 point for each correct answer. At the end of the Quiz, your total score will be displayed. Maximum score is 20 points.
Good...You Have Learned SQL, Now What?
November 12th, 2010 by aBisona
SQL Summary
This SQL tutorial has taught you the standard computer language for accessing and manipulating database systems.
You have learned how to execute queries, retrieve data, insert new records, delete records and update records in a database with SQL.
You have also learned how to create databases, tables, and indexes with SQL, and how to drop them.
You have learned the most important aggregate...SQL Hosting
November 12th, 2010 by aBisona
SQL Hosting
If you want your web site to be able to store and display data from a database, your web server should have access to a database system that uses the SQL language.
If your web server will be hosted by an Internet Service Provider (ISP), you will have to look for SQL hosting plans.
The most common SQL hosting databases are MySQL, MS SQL Server, and MS Access.
You can have SQL databases...