Debian

Importing information_schema from an other mysql server

While investigating some mysql stuff at work I imported the whole mysql dump from our production system into my localhost installation. Among the 2000 or so databases was also information_schema, and I ended up with problems like :

root@pluto:~# /etc/init.d/mysql status
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 
'debian-sys-maint'@'localhost' (using password: YES)'
 * 

The solution was to reset password fr debian-sys-maint user in mysql.

GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' 
IDENTIFIED BY 'password' WITH GRANT OPTION;

Where ‘password’ is found in /etc/mysql/debian.cnf 🙂

I got this one from ubuntuforums.org.

Vim + headless server + syntax highlighting

After installing my favourite distro, which these days seem to have fallen back on Ubuntu I’m usually installing the ‘vim-gnome’ package. It pulls down the necessary packages for me to have a fully fledged Vim editor with syntax highlighting and so on.
But what if I don’t have X installed ?
Trying to install vim-gnome then would pull down xorg + the complete gnome-desktop environment, which really isn’t that necessary.
Since there’s a lot of packages related to vim it could be a bit confusing which one to pull down just to have syntax highlighting.

# aptitude install vim-nox 

gives you, in _my_ opinion, a working and useful Vim editor in a ‘non-X’ environment :p