datos/pagina:            

Datos:156

Titulo: multiple move
Contenido: Ex: name.1 name.2 .... name.n
mmv name* file#1
results: file.1 file.2 .... file.n

conversion from *.jpeg to *.jpg
mmv '*.jpeg' '#1.jpg'
Titulo: my pagina google santaclara5
Contenido: https://plus.google.com/100019117193246820894
Titulo: mysql
Contenido: MySQL server version 3.22.32
Port 3306
Data directory: /var/lib/mysql

Change password:
# mysqladmin password newpassword
or:
mysql> update user set password=passwor('new_password') where user='username';
mysql>flush privileges;
Example:
mysql> update user set password=password('gu') where user='root';
mysql> update user set password=password('penta') where user='mart';
or:
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON lm_db.*
TO mart@localhost
IDENTIFIED BY 'penta';
Example:
mysql> grant select,insert,update,delete,create,drop on lm_db.* to mart@"%" identified by 'penta';
mysql> flush privileges;

mysql commands:
mysql> select version();courrentdate();
+-----------+
| version() |
+-----------+
| 3.22.32 |
+-----------+

mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2001-01-24 11:15:41 |
+---------------------+

pc12:~% mysql -u root -pgu

mysql> use mysql;
Database changed
mysql> show tables;
+-----------------+
| Tables in mysql |
+-----------------+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user |
+-----------------+
mysql> create database m_db;
mysql> exit;

lheppc12:~% mysqlshow -u root -pgu mysql user
Database: mysql Table: user Rows: 5
+-----------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+---------------+------+-----+---------+-------+
| Host | char(60) | | PRI | | |
| User | char(16) | | PRI | | |
| Password | char(16) | | | | |
| Select_priv | enum('N','Y') | | | N | |
| Insert_priv | enum('N','Y') | | | N | |
| Update_priv | enum('N','Y') | | | N | |
| Delete_priv | enum('N','Y') | | | N | |
| Create_priv | enum('N','Y') | | | N | |
| Drop_priv | enum('N','Y') | | | N | |
| Reload_priv | enum('N','Y') | | | N | |
| Shutdown_priv | enum('N','Y') | | | N | |
| Process_priv | enum('N','Y') | | | N | |
| File_priv | enum('N','Y') | | | N | |
| Grant_priv | enum('N','Y') | | | N | |
| References_priv | enum('N','Y') | | | N | |
| Index_priv | enum('N','Y') | | | N | |
| Alter_priv | enum('N','Y') | | | N | |
+-----------------+---------------+------+-----+---------+-------+

mysql> select host,user,password from user;
+-------------------+----------+------------------+
| host | user | password |
+-------------------+----------+------------------+
| localhost | root | 6db8a3ad1c53bcbe |
| pc12.unibe.ch | root | 6db8a3ad1c53bcbe |
| localhost | | |
| pc12.unibe.ch | | |
| % | mart | 2ae2f8a422678189 |
+-------------------+----------+------------------+
--------------------------------------------------------------------------------------------------------------
Database accessable from other computer:



mysql> grant all privileges on *.* to myadmin@"%" identified by 'penta' with grant option;

mysql> grant all privileges on *.* to myadmin@localhost identified by 'penta' with grant option;

En MySQL 5.0 o superior hay que comentar la frase en
/etc/mysql/my.cnf
que dice:
#bind-address = 127.0.0.1


-----------------------------------------------------------------------------------------------------------
Titulo: mysql Dump database definitions
Contenido: mysqldump -h"host" -u"user" -p"passwd" -d --add-drop-table "myDatabase" > Mytmp.sql
Página 21 de 39