MySQL new user SQL statements

A quick and dirty explanation to create a new MySQL datbase with a user Create the user: CREATE USER ‘hibtest’@’localhost’ IDENTIFIED BY ‘*******’; Set some permissions: GRANT USAGE ON * . * TO ‘hibtest’@’localhost’ IDENTIFIED BY ‘*******’ WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0MAX_USER_CONNECTIONS 0 ; Create the database: CREATE DATABASE IF NOT EXISTS `hibtest`… Continue reading “MySQL new user SQL statements”

Apache and redirecting a url

This is a quick blog for me to remember how to do a proxy in apache: <VirtualHost *:80> ServerName ServerAlias ServerAdmin ProxyPreserveHost On ProxyRequests Off <Proxy *> Order deny,allow Allow from all </Proxy> ProxyPass / http://999.888.777.666:8080/ ProxyPassReverse / http://999.888.777.666:8080/ </VirtualHost>

VMWare 6 and Ubuntu Hardy: vmmon compile error

Just a quick post to documentate how I got my VMWare config to work: Problem: include/asm/bitops_32.h:9:2: error: #error only <linux/bitops.h> can be included directly, and vmmon-only compile failes Solution: change line 74 in vmmon-only source file to read: #include “linux/bitops.h” Steps: cd /usr/lib/vmware/modules/source cp vmmon.tar vmmon.tar.orig sudo tar xvf vmmon.tar cd vmmon-only/include/ sudo vi vcpuset.h… Continue reading “VMWare 6 and Ubuntu Hardy: vmmon compile error”