Dive into the archives.
- Change MySQL variables without restart
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;
Check again:
mysql> show variables like ‘long_query%’;
+—————–+——-+
| Variable_name | Value |
+—————–+——-+
| long_query_time | 2 |
+—————–+——-+
Success!
- Could not connect to database for SQL SessionHandler
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. This is a checklist to solve the problem.
- Cambiar password de root de MySQL
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 mysql
mysql
use mysql;
4º Actualizamos la contraseña del usuario root
update user set Password=(’password’) where user=’root’;
5º Recargar las tablas de permisos
flush privileges
6º [...]
