Tag Archives: MySQL

Change MySQL variables without restart

Posted on 16 abril, 2008 by Jonathan

A simple way to change runtime variables wihtout restarting mysql server. First check the running value: mysql> show variables like ‘long_query%’; +—————–+——-+ | Variable_name | Value | +—————–+——-+ | long_query_time | 10 | +—————–+——-+ Change the value: mysql> set @@long_query_time=2; … Continue reading →

Posted in MySQL | Tagged | 1 Comment

Could not connect to database for SQL SessionHandler

Posted on 3 abril, 2008 by Jonathan

When you try to login in Horde you see this error: A fatal error has occurred Could not connect to database for SQL SessionHandler. Details have been logged for the administrator. There are some different reasons that causes this error. … Continue reading →

Posted in Linux | Tagged , , , | 2 Comments

Cambiar password de root de MySQL

Posted on 18 diciembre, 2007 by Jonathan

Pasos para cambiar la contraseña del usuario root para el servicio MySQL: 1º Parar cualquier instancia del servicio /etc/init.d/mysql stop 2º Iniciar MySQL en modo seguro /usr/bin/mysqld_safe –skip-grant-tables 3º Ejecutamos el cliente de MySQL y seleccionamos la base de datos … Continue reading →

Posted in Linux, MySQL | Tagged , | Leave a comment