Reset Mysql Root password in Ubuntu

For last couple of months when I tried to access my mysql,I sadly discover that I forgot the root password.
And google a lot to know the reset details.

I know in future I will need the steps again as why thought It would be better to write it down.
Its very simple,all I did.

1.Stop running Mysql


service mysql stop

or using

sudo /etc/init.d/mysql stop

2.Starting the mysql configuration ,login as a root in mysql and update the root user’s password.

sudo mysqld --skip-grant-tables &

Access to mysql using

mysql -u root mysql

And the type update the root user password using following command

UPDATE user SET Password=PASSWORD('new pass') WHERE User='root'; FLUSH PRIVILEGES; exit;

Then you will see “OK” confirmation like below:

Query OK, 3 rows affected (0.00 sec)
Rows matched: 3  Changed: 3  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Bye

Then you can access to your mysql using following command

mysql -u root -p

Thats it.

Check out mysql doc for details

Just featured in Ubuntu Cloud!

I am a hardcore Ubuntu user.At home for entertainment and development I use Ubuntu.I fall in love with it when I was 2nd year University student.At that time I used for doing programming in c and later I used it for networking labs.

With time and try I came to know how to play with Ubuntu,how I can get most out of it.The community helped me a lot to making this relationship mature.
After leaving university my love didnt end up,got new boost I bought a rack space cloud to make myself expert in cloud system also to deploy applications that I develop for my clients.I choose ubuntu as OS in my cloud because of its community and familiarity.I love ubuntu community for its active participation.
A week ago I was interviewed by cloud ubuntu administrator.And yesterday night my interview featured in the cloud ubuntu home.
Check that out from here 🙂

Hope it will inspire me as well as others to spread FOSS in larger space and make ubuntu cloud as ultimate solution for cloud computing 🙂

Internet connection configuring in Ubuntu

Couple of days ago I was trying to set all the network information in system to “Network Connections”(System>Preferences> Network Connection).I put all the necessary information in the fields as those are necessary to set the wired broad band connection.Unfortunately the connection could been established.So I tried to find out the configuration file which one writes down the network information to establish a connection.And found “/etc/network/interfaces “.So,I wrote the following commands to the terminal:

sudo gedit /etc/network/interfaces

The file was containing: “auto lo”

” iface lo inet loopback “.

As I guessed the network information were not wriitten to the file so I wrote follwoing informations:

auto eth0
iface eth0 inet static
address 192.168.100.118(put you internet address provided by the ISP)
gateway 192.168.100.1(gateway address)
netmask 255.255.255.0
network 192.168.100.0

Then I saved the file.And restarted the network using following command:

sudo /etc/init.d/networking retstart

For DHCP connection just have to put the following line into the /etc/network/interface  file


auto eth0

iface eth0 inet dhcp

The have to restart network.The connection will be established 🙂