Posts Tagged ‘warranty’

How to change MySQL server root password

Friday, July 29th, 2011

MySQL pass dialog Debian

I had to change my mysql root password for one of the servers since during the install I mispasted the password in the MySQL password prompt I needed the pwd to be changed.

Here is how I changed it to my desired one:

linux:~# /usr/bin/mysqladmin -u root -p'OLD_PASSWORD_STRING' password NEW_PASSWORD_STRING

The password gets changed immediately 😉

If a new password has to be set to a passwordless mysql server, the command to be issued is:

linux:~# /usr/bin/mysqladmin -u root password PASSWORD_STRING

Changing the MySQL password is also possible with mysql cli, after connecting to the sql server, though this method is a bit more time consuming. Here is how to do it from mysql console:

linux:~# mysql -u root -p
Server version: 5.1.49-3 (Debian)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.
mysql> use mysql;
mysql> update user set password=PASSWORD(“NEW_PASSWORD”) where User=’root’;mysql> flush privileges;

Of course it’s possible to do change the root pass via phpmyadmin
Cheers 😉

Ubuntu on Laptop

Friday, November 2nd, 2007


Here the story a cousin of my father has called me to help them to buy a laptop. We have checked different types of laptops in TechnoMarket and TechnoPolis, Vali and Bergon. In vali we asked about GPS devices (a device only connecting with a Satellite, which needs software to be used). I asked the seller in Vali is there a chance if the Holux GPS to work with Linux.He said he have no idea I'm citing his words "Only a few people use Linux today" :). Also the Computer sellers in TechnoMarket weren't much of a competent, I myself also didn't have enough experience with Laptops. Before everything began I asked God to guide me in the choice. We choose to take a Toshiba Sattelite L40 12G or something like this. The machine is a pretty neat one (2G of ram, Intel video, 120 SATA Disk). I gave the suggestion to install Linux on the laptop and spend money of the Operating System (because they would need the laptop when they travel out of the country, buying furniture to resell and they don't want to have illegal software. There was an international warranty issue. The sellers in Technomarket didn't have data is the laptop with International warranty later we understood that there is international warranty of 1 year. We bought the laptop I successfully installed Ubuntu and a ton of useful software. Today I have installed qemu qemu-launcher and qemulator. Ubuntu seems to work pretty flawlessly. The idea in the beginning was to buy a flash memory and install a windows on it because they needed also to have Windows to install a TBI Credit (SmartInfo) program. I tried Windows XP/2000/XP Small but all them required a minimum of 2G of hard disk space to install (!) pretty annoying and this wasn't possible because the flash memory we had was only a 1G one. In the end I ended installing the Windows on the HDD. Thanks to God everything seems to go on in a good way. Thanks Lord! 🙂 The only thing that's left to do is install the Wireless card properly under Linux and Windows.Glory be to God The Father, The Son and The Holy Spirit! Now and Forever and Ever. Amen!END—–