Stop Mysql Service service mysql stop Start MySql in Safe Mode mysqld_safe –skip-grant-tables Reset password mysql –user=root mysql update user set Password=PASSWORD(‘new-password’) where user=’root'; flush privileges; exit; Stop Safe Mode ps aux | grep Mysql kill MySql-Prozess-Pid Start MySql Service service mysql stop
Tag: linux
Operating Systems
old repositories for ubuntu
by Mike • • 0 Comments
if ubuntu isn’t updated on a regular base, one time you can’t use the repo’s sooner or later. Then you have to modify your repo list. Read how..
Operating Systems
crontab and cronjobs
by Mike • • 1 Comment
write your command best in a shellscript and add runnable to it chmod +x /home/scripts/yourscriptfile.sh add it to /etc/crontab # /etc/crontab: system-wide crontab # Unlike any other crontab you don’t have to run the `crontab’ # command to install the new version when you edit this file # and files in /etc/cron.d. These files…
Software / Hardware
start and handle a VirtualBox without GUI
by Mike • • 0 Comments
to show all vm’s $ vboxmanage list vms and only the running ones $ vboxmanage list runningvms to start one (without attaching it to the console) $ nohup vboxheadless -s [VM-Name] & now you can cancel with Strg-C without aborting the start of the vm to shutdown the vm $ vboxmanage contolvm [VM-Name] poweroff getting…
Aside
mp3 player for linux & windows
for collection and maintainance of the mp3 collection, not only listening 😉
windows:
AMAROK!
linux with gtk:
amarok
linux on commandline:
– CMus via apt-get – cmus manpage
– mp3blaster via apt-get (a bit more flexible at the library view)
Aside
Add Script to Startup
$ nano /etc/init.d/startscript.sh $ chmod +x /etc/init.d/startscript.sh $ nano /etc/init.d/rc.local //add the call to the script at the end
Aside
browse files on a server with ssh
with gnome:
- File-Browser->Menue
- File->Connect to Server
- choose SSH Protokoll
else use konquerer or dolphin with:
- fish://servername
Operating Systems
Remote Access MySql
by Mike • • 0 Comments
$ nano /etc/mysql/my.cnf comment out: skip-networking on fixed ip-address: bind-address=xxx.xxx.xxx.xxx else comment out restart mysql $ /etc/init.d/mysql restart open firewall: $ /sbin/iptables -A INPUT -i eth0 -p tcp –destination-port 3306 -j ACCEPT
Operating Systems
Change Resolution of Console / Bash in a VM Image
by Mike • • 0 Comments
$ nano /etc/default/grub GRUB_GFXMODE=1024x768x32 GRUB_GFXPAYLOAD_LINUX=keep $ update-grub of course everything as root/superuser!
Software / Hardware
Galaxy Note Serie als Grafik Tablet (mit dualscreens)
by Mike • • 0 Comments
Apps Linux: Android: https://play.google.com/store/apps/details?id=at.bitfire.gfxtablet PC: http://rfc2822.github.io/GfxTablet/#part-1-uinput-driver Apps Windows: Android: https://play.google.com/store/apps/details?id=com.sunnysidesoft.VirtualTablet.lite PC: http://www.sunnysidesoft.com/virtualtablet/ I only tested the Linux Version, so here a short manual: – download android app and install – download pc programm from site (chmod a+x networktablet-x86_64) – run in a terminal the download pc programm (./networktablet-x86_64) – run app on smartphone If you…
Operating Systems
Desktop App Starter
by Mike • • 0 Comments
create a file with anyname.desktop [Desktop Entry] Version=1.0 Type=Application Name=DebDev.sh Comment=DebDev Exec=/home/mount_debdev.sh Icon=utilities-terminal Terminal=true StartupNotify=false GenericName=Test – Name: Text that will be displayed – Exec: script/file to run
Operating Systems
Batch Bilder Resize auf Commando Zeile
by Mike • • 0 Comments
ganz ohne zusatzprogramm gehts leider nicht, aber Imagemagic is sehr klein und fein und faellt kaum auf 😉 apt-get install imagemagick Das eigentliche “Script” der Kommando Zeile (fügt den neuen Dateien das vorzeichen “resized_” hinzu): for i in $( ls *.jpg); do convert -resize 50% $i resized_$i; done Will man die Dateien auch gleich konvertieren…
Operating Systems
CD/DVD -> ISO -> USB Stick mit DD Befehl
by Mike • • 0 Comments
Der Befehl “dd” unter linux eignet sich hervorragend um ISO Images zu erstellen oder um ISO’s auf andere medien zu schreiben. Die Erklaerung vom Befehl dd unter Linux. Um ein ISO einer CD / DVD zu erstellen: um mittels dd ein Image erstellen zu können, darf das Ursprungsmedium nicht gemountet sein umount /dev/cdrom oder umount…
Operating Systems
really blank webserver with ubuntu
by Mike • • 0 Comments
i got a tipp from a friend to setup a even faster webserver with less hardware resources, and faster to setup (you dont have to remove the gaming crap) to make it virtual get a copy of VirtualBox (its free, cross plattform and fast https://www.virtualbox.org/wiki/Downloads Instead of Xubuntu Desktop Version grab the server edition at…
Operating Systems
Setting Up an Ubuntu Webserver
by Mike • • 0 Comments
quick and dirty 😉 i guess you can setup ubuntu yourself i use xubuntu (less eyecandy, more performance with less memory) before i install the server i remove all games, mail clients and such useless things for a webserver. set the pc name with sudo gedit /etc/hostname download lampp from http://www.apachefriends.org/de/xampp-linux.html#52 set root password with…