MySQL error 1449: The user specified as a definer does not exist

How to change the definer for views

    Run this SQL to generate the necessary ALTER statements

    SELECT CONCAT("ALTER DEFINER=`youruser`@`host` VIEW ",
    table_name, " AS ", view_definition, ";")
    FROM information_schema.views
    WHERE table_schema='your-database-name';

    Copy and run the ALTER statements

How to change the definer for stored procedures

Example:

UPDATE `mysql`.`proc` p SET definer = 'user@%' WHERE definer='root@%'

Fuente: http://stackoverflow.com/questions/10169960/mysql-error-1449-the-user-specified-as-a-definer-does-not-exist

PHP cambiar el tamaño máximo para subir archivos

PHP change the maximum upload file size

En el archivo de configuración de php (php.ini) usualmente ubicado en /etc/php.ini hay que cambiar los valores:

upload_max_filesize
post_max_size

; Maximum allowed size for uploaded files.
upload_max_filesize = 40M

; Must be greater than or equal to upload_max_filesize
post_max_size = 40M

Fuente: http://stackoverflow.com/questions/2184513/php-change-the-maximum-upload-file-size

Impresora HP LaserJet Pro 400 serie M401 La configuración está en curso por otra herramienta de gestión

Problema:

Error al cambiar el DNS

La configuración está en curso por otra herramienta de gestión.

o

Configuration in progress by another Management Application


Solución:

Hacer un factory reset o Cool reset.


Impresora con LCD

1. Turn the product off.
2. Perform one of the following steps:
 - LCD control panel models: Simultaneously press and hold the right arrow button and the Cancel button. Keep these buttons depressed as you turn the product on.
 - Touchscreen control panel models: Press and hold the lower right quadrant of the touchscreen. Keep the quadrant depressed as you turn the product on.
3. When the Permanent Storage Init. message appears on the display, release the buttons.
4. When the product has finished the NVRAM initialization, it returns to the Ready state.


Impresora si LCD

Power off the printer.

Hold the RIGHT ARROW button + the CANCEL X button.

Power on the printer.

Hold those buttons down until you see see the resetting system and then release. cuando aparece "Permanent storage init"

Cambiar nombre cuenta local Windows 10

3 ways to change user account name in Windows 10:

Way 1: Change account name in Control Panel.
Step 1: Access Control Panel/User Accounts and Family Safety/User Accounts.
Step 2: Choose Change your account name.

Step 3: Type a new name in the box and tap Change Name.

Way 2: Change account name in Local Users and Groups.
Step 1: Open Run by Windows+R, enter lusrmgr.msc and hit OK to open Local Users and Groups.

Step 2: Open the Users folder, right-click a user and select Rename in the menu.

Step 3: Type a new name in the name box.

Way 3: Change administrator or guest name in Local Group Policy Editor.
Step 1: Access Local Group Policy Editor.
Step 2: Open Computer Configuration/Windows Settings/Security Settings/Local Policies/Security Options/Accounts: Rename administrator account (or Accounts: Rename guest account).

Step 3: Type new name and hit OK.






Fuente: http://www.isunshare.com/windows-10/3-ways-to-change-user-account-name-in-windows-10.html

Cambiar la hora time date en fedora según la timezone

Instalar y configurar NTP en Linux CentOS para sincronizar el reloj del sistema

How do I install and configure NTP under CentOS Linux version 5.x or 6.x server to synchronize the system clock?

You can easily install NTP (Network Time Protocol, a means of transmitting time signals over a computer network) using the yum command under Red Hat or CentOS/Fedora Linux server or workstation based systems. You need to install the following packages:

1. ntp : ntpd server which continuously adjusts system time and utilities used to query and configure the ntpd daemon.
2. ntpdate : Utility to set the date and time via NTP.
3. ntp-doc : NTP documentation

Procedure: Setup NTPD on CentOS Linux

Open the terminal or login over the ssh session. You must login as as the root user. Type the following yum command to install ntp
# yum install ntp ntpdate ntp-doc

Turn on service, enter:
# chkconfig ntpd on

Synchronize the system clock with 0.pool.ntp.org server (use this command only once or as required):
# ntpdate pool.ntp.org

Start the NTP server. The following will continuously adjusts system time from upstream NTP server. No need to run ntpdate:
# /etc/init.d/ntpd start

o

# service ntpd start

Configure ntpd (optional)

Edit /etc/ntp.conf, enter:
# vi /etc/ntp.conf

Set public servers from the pool.ntp.org project:

server 0.rhel.pool.ntp.org
server 1.rhel.pool.ntp.org
server 2.rhel.pool.ntp.org

See this tutorial on how to configure NTPD for LAN based client on RHEL / CentOS Linux for more information.

Fuente: http://www.cyberciti.biz/faq/howto-install-ntp-to-synchronize-server-clock/

00 mass storage devices found and configured

Solución 1: reiniciar el BIOS a la configuración por defecto

Solución 2: quitar las memorias, quitar la pila. Encender el equipo sin las partes anteriores. Reconfigurar el BIOS.

htpasswd

You can generate the username and password using htpasswd. New file:

$ htpasswd -c /srv/auth/.htpasswd squire

To append to existing file:

$ htpasswd -b /srv/auth/.htpasswd squire2 tickleme2


Checar en la directiva httpd.conf

AuthUserFile '/some/other/dir/.htpasswd'

Fuente:  http://serverfault.com/questions/127708/how-to-configure-basic-authentication-in-apache-httpd-virtual-hosts