~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
			     MYSQL V4.0  (basics)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

shell> mysql -h host -u user -p menagerie
Enter password: ********

START THE DAEMON :
~~~~~~~~~~~~~~~
/usr/local/mysql># bin/mysqld_safe --user=mysql &

Cambiar la contraseņa de "root" :
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
# mysqld restart --skip-grant-tables
  (Ej.: /etc/rc.d/init.d/mysqld restart --skip-grant-tables)
# mysqladmin -u root password 'newPassword'
Reinicia MySQL 
  # /etc/rc.d/init.d/mysqld restart
    OR
  # mysqladmin -h hostname flush-privileges
  
Ejecutar comandos sql :
~~~~~~~~~~~~~~~~~~~~
/usr/local/mysql/bin>./mysql

mysql> SHOW DATABASES;

mysql> use test

mysql> GRANT ALL ON menagerie.* TO your_mysql_name;

mysql> CREATE DATABASE menagerie;

mysql> SHOW TABLES;

mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
    -> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);

mysql> SHOW TABLES;

mysql> DESCRIBE pet;

mysql> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;

mysql> INSERT INTO pet
    -> VALUES ('Puffball','Diane','hamster','f','1999-03-30',NULL);

mysql> SET AUTOCOMMIT=1;  # Used for quick re-create of the table

mysql> SELECT name, species, birth FROM pet
    -> WHERE species = "dog" OR species = "cat";

mysql> SELECT name, birth FROM pet ORDER BY birth;

mysql> SELECT name, birth, CURRENT_DATE,
    -> (YEAR(CURRENT_DATE)-YEAR(birth))
    -> - (RIGHT(CURRENT_DATE,5)<RIGHT(birth,5))
    -> AS age
    -> FROM pet;

mysql> update mdl_user set password='a84dcbd89a27490a4cb99e2420d1fc10' WHERE
id=1;


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
								   Hugo Martin
							     www.hackcraft.com