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…)
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…)
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...SQL Quick Reference From W3Schools
November 12th, 2010 by aBisona
SQL Statement
Syntax
AND / OR
SELECT column_name(s)
FROM table_name
WHERE condition
AND|OR condition
ALTER TABLE
ALTER TABLE table_name
ADD column_name datatypeor
ALTER TABLE table_name
DROP COLUMN column_name
AS (alias)
SELECT column_name AS column_alias
FROM table_nameor
SELECT column_name
FROM table_name AS table_alias
BETWEEN
SELECT column_name(s)
FROM table_name
WHERE column_name
BETWEEN value1...SQL FORMAT() Function
November 12th, 2010 by aBisona
The FORMAT() Function
The FORMAT() function is used to format how a field is to be displayed.
SQL FORMAT() Syntax
SELECT FORMAT(column_name,format) FROM table_name
Parameter
Description
column_name
Required. The field to be formatted.
format
Required. Specifies the format.
SQL FORMAT() Example
We have the following “Products” table:
Prod_Id
ProductName
Unit
UnitPrice
1
Jarlsberg
1000...