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.
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
When setting up openvpn on my Debian vps daemon.log said
Note: Cannot open TUN/TAP dev /dev/net/tun: No such file or directory (errno=2)
On vps I’ve come over other things too missing from /dev , this time I had to create the /dev/net/tun device manually by issuing:
mknod /dev/net/tun c 10 200
chmod 600 /dev/net/tun
Supporting syntax highlighting in less, how cool is that !
According to linux-tips.org
In debian/ubuntu install source-highliting and set up these variables:
export LESSOPEN="| /usr/share/source-highlight/src-hilite-lesspipe.sh %s"
export LESS=' -R '