How to reset MySql root password

If you had forgot the password of MySql and stuck at the point, Let me help you :)
Following are the steps to recover the password/ root password and get through  root user.


Step # 1: Stop the MySQL server process.

Step # 2: Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for password.

Step # 3: Connect to mysql server as the root user.

Step # 4: Setup new mysql root account password i.e. reset mysql password.

Step # 5: Exit and restart the MySQL server.

Here you have to write commands for each step:

Step # 1 : Stop mysql service

# /etc/init.d/mysql stop

Output:

Stopping MySQL database server: mysqld.

Step # 2: Start to MySQL server w/o password:

# mysqld_safe --skip-grant-tables &

Output:
[1] 5988
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[6025]: started

Step # 3: Connect to mysql server using mysql client:

# mysql -u root

Output:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>

Step # 4: Setup new MySQL root user password

mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit

Step # 5: Stop MySQL Server:

# /etc/init.d/mysql stop

Output:
Stopping MySQL database server: mysqld
STOPPING server from pid file /var/run/mysqld/mysqld.pid mysqld_safe[6186]: ended [1]+ Done mysqld_safe --skip-grant-tables

Step # 6: Start MySQL server and test it

# /etc/init.d/mysql start
# mysql -u root -p

What next after 12th with PCB ?

 pic credit to "open.ac.uk"




Here after 12th it become too important to choose your career wisely. Many students being confused choose wrong direction and end up regretting whole life. Also many social helpers come to give their advise and views without even asking them. So it been so hard for students to choose their career which really mean to them. The best way which always been best is to choose on base of your interest. No matter what the field is but if you really have "fire" in that field which never ever let you bore then choosing such will be wise enough. Here someone requested me to upload all fields available taking Biology after 12th.

List of all available course after 12th with PCB(India):

• MBBS
• BAMS (Ayurvedic)   <----- Click Here to see full syllabus
• BHMS (Homeopathy)
• BUMS (Unani)
• BDS (Dental)   

              BDS     <----- Click Here to download full syllabus Part1
                          <----- Click Here to download full syllabus Part2

• Bachelor of Veterinary Science & Animal Husbandry (B.VSc AH)
• Bachelor of Naturopathy & Yogic Science (BNYS)
• Bachelor of Physiotherapy 

                      <----- Click Here to download full syllabus according to Gujarat University  ( pdf )                             <----- Click Here to download full syllabus according to Charusat University  ( pdf )

                      <----- Click Here to download full syllabus:   Image1

                                                                                           Image2

                                                                                           Image3

                                                                                           Image4

• Integrated M.Sc
• B.Sc. Nursing 
• B.Sc. Dairy Technology
• B.Sc. Home Science
• Bachelor of Pharmacy
• Biotechnology
• BOT (Occupational Therapy)
• General Nusrsing
• BMLT (Medical Lab Technology)
• Paramedical Courses
• BA
• LLB 
• Education/Teaching
• Travel & Tourism Courses
• Environmental Science
• Fashion Technology
• Hotel Management
• Designing Courses
• Media/ Journalism courses
• Film/Television courses
• CA program
• ICWA Program
• CS Program 

 Click on the particular categories to see full details containing syllabus, scope, colleges, jobs...etc
For more details fill up contact form with your questions available at the righ-hand side corner of this site.

"Mental Mathematics"

 

If, for some reason, you’re not crazy about math, read a little further. Of course I, as the Science Guy, hope you do like math.
    Well, actually, I hope you love math. But no matter how you feel about math, hatred or love, I’d bet that you often find yourself   just wanting to know the answer right away, without having
to write down everything carefully and work slowly and diligently—
or without even having to stop and grab a calculator.
You want the answer, as we say, “as if by magic.” It turns out
that you can solve or work many, many math problems almost magically. 

This book will show you how.

 Download this amazing book which have many tricks to solve calculations at your finger tip rather using calculator. You may impress your classmates :D LOL.

1. SECRETS OF MENTAL MATHS

       >>>>>DOWNLOAD<<<<< 

 

.... Comments, Share, and Like below. Your comments will value most.

 

 

 

 

Reference: www.bookboon.com, google, wikipedia

Introduction to JAVA(redefined)

 Java is a general-purpose computer programming language that is concurrent, class-based, object-oriented, and specifically designed to have as few implementation dependencies as possible. 

Hi Guys, this is second part of my post on JAVA which is little advanced than the previous one. Beginners still find their tutorials in the "Label" section in home page. ==> 

 

Are you little bit handy with JAVA and want to know more about JAVA? Then see below and download amazing tutorials in the form of "Slides".

Previous version was for beginners with JAVA. Have a look at that: JAVA   for   Beginners

For those who know JAVA-

1. Introduction to JAVA (PPT)     
    >>>>DOWNLOAD<<<<

2. Building JAVA programs
    >>>>DOWNLOAD<<<<

3. Donot fear OOP (Object Oriented Programming)
    >>>>DOWNLOAD<<<<
 
4. Important Concepts
    >>>>DOWNLOAD<<<<
 
5. Internet and JAVA
    >>>>DOWNLOAD<<<<
 
6. JAVA Mailserver
    >>>>DOWNLOAD<<<<
 
7. JAVA Networking
    >>>>DOWNLOAD<<<<
 
8. JAVA OOP Concepts
    >>>>DOWNLOAD<<<<
 
9. JAVA with databases
    >>>>DOWNLOAD<<<<
 
10. JAVA Virtual Machine
    >>>>DOWNLOAD<<<<
 
11. JAVA Threads
    >>>>DOWNLOAD<<<<
 
12. Web Programming with JAVA
    >>>>DOWNLOAD<<<<

Reference: www.bookboon.com, google, wikipedia