How to Recover MYSQL Password

Q: My root password lost?; can’t manage existing database can anyone help me?

A: Solution is simple just follow the steps below:

Recover MYSQL Password
#/etc/init.d/mysql stop

Please wait until MySQL shuts down completely. Then run#/usr/bin/mysqld_safe –skip-grant-tables –skip-networking &

then you will be able to login as root with no password.#mysql -uroot mysql

In MySQL command line prompt issue the following command:mysql>UPDATE user SET password=PASSWORD(”letmein”) WHERE user=”root”;
FLUSH PRIVILEGES;
mysql>exit

kill all the mysql processes #/etc/init.d/mysql stop

Start MySQL again #/etc/init.d/mysql start

At this time your root password is reset to “letmein” and MySQL will now
know the privileges and you’ll be able to login with your new password:mysql -uroot -pletmein mysql

Congratulations you have successfully changed your new password

Feedbacks: We appreciate your feedbacks and suggestions about our website bala@techgyaan.org
Check out Bala's Google+ profile. Follow @techgyaan

Comments

Download of the Day!

Amarok 2.0.2 has released Amarok is an open source alternative music player for iTunes. Amarok supports Linux, Unix, MacOSX and windows Operating system. It is smiliar to iTunes just drag & drop the songs to play list. Amarok also lets you listen to internet radio ( mp3 streaming ) including music from last.fm . Features Automatic cover Lyrics download Dynamic playlists Visualizations and Podcasting. These are only some of the great new features of Amarok 2. Give it a try! Download here An least but not last - Amarok will also synchronize your music to your iPod. For the more technical users a scripting interface allows you to extend the functionality of Amarok. Print Page Feedbacks: We appreciate feedbacks and suggestions about our website info@techgyaan.org

How to fix Solaris "/lib/svc/method/net-physical "network settings is misconfigured”

Yesterday I came across an issue with the server being unable to access it switched to the maintenance mode with some a strange message; “ How to fix Solaris "/lib/svc/method/net-physical "network settings is misconfigured”. Dec 9 10:05:59 techgyaansvr svc.startd[7]: [ID 652011 daemon.warning] svc:/network/physical:default: Method "/lib/svc/method/net-physical" failed with exit status 96. Dec 9 10:05:59 techgyaansvr svc.startd[7]: [ID 748625 daemon.error] network/physical:default misconfigured: transitioned to maintenance (see 'svcs -xv' for details) Actual message is that the IP address already exists, but is not configured. We need to clear the network & flush the settings to make it accessible Resolution: Check the service which is disabled #svcs –xv [this command will show you the services which is disabled by system] Take the network interface offline #ifconfig eri0 down [this command will bring the interface down] #ifconfig eri0 unplumb [this co...

Increase your RAM? free of cost…Really Worth It!!!!

A Very useful tip . Please try this and use RAM efficiently. Now this is called a tip of the year! While working with the Task Manager I observed the following. You can also try it out. 1.Start any application, say Word. Open some large documents. 2.Now start the Task Manager processor tab and sort the list in descending order on Memory Usage. You will notice that Winword.exe will be somewhere at the top, using multiple MBs of memory. Note down the number. 3.Now switch to Word and simply minimise it. (Do not use the Minimize All option of the task bar). 4. Now go back to the Task Manager and see where Winword.exe is listed. Most probably you will not find it at the top. You will typically have to Scroll to the bottom of the list to find Word. Now check out the amount of RAM it is using. Compare it with the original. Surprised? The memory utilisation has reduced by a huge amount. 5.So where is the tip of the year? Simple? Minimise each application that you are currently not working on ...

CloudGyaan

Search This Blog