LinuxGalore Blogs

Worrying of LOST the ROOT Password. Don’t have to worry. Here is the trick, to get it solved and recover the reset the password, so that you can login to MySQL again.

Firstly, stop theMySQL Server as below:

# /etc/init.d/mysql stop

Then start the MySQLD daemon with -skip-grant-tables as shown below:

# mysqld_safe --skip-grant-tables &

Now Connect to MySQL server as shown below with the root user:

# mysql -u root

Now you can reset the password with your choice as shown below:

mysql> use mysql;

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

mysql> flush privileges;

mysql> quit

Now exit from the MySQL prompt and Stop the MySQL server as shown below:

# /etc/init.d/mysql stop

Start the MySQL Server:

# /etc/init.d/mysql start

Connect to the MySQL database server as shown the below with root user and the password you set.

# mysql -u root -p

Popularity: 51% [?]

Share This

No Comments »
Filed under: Mysql Tips & Tricks

If you are not giving the below said privileges to the user, then you
can only give permissions to appropriate database as shown below:

mysql> grant all privileges on guest.* to

    -> 'guest'@'localhost' identified

    -> by '1234567890' with grant option;

mysql> flush privileges;

Here ‘guest’ is the Database name and ‘guest.*’ means granting the permissions to all the tables in that database.

Powered by ScribeFire.

Popularity: 42% [?]

Share This

1 Comment »
Filed under: Mysql Tips & Tricks

Method 1#If you have never set a root password for MySQL, the server does not
require a password at all for connecting as root. To setup root
password for first time, use mysqladmin command at shell prompt as
follows:
       

 $ mysqladmin -u root password NEWPASSWORD

However if you want to change (or update) a root password, then you need to use following command:

 $ mysqladmin -u root -p oldpassword newpass

Enter password:

To change a normal user password you need to type (let us assume you would like to change password for Suresh):

     $ mysqladmin -u suresh -p oldpassword newpass

Method #2: MySQL stores username and passwords in user table inside
MySQL database. You can directly update password using following method
to update or change password for user suresh:

1. Login to mysql server, type following command at shell prompt:

    $ mysql -u root -p

   2. Use mysql database (type command at mysql> prompt):

      mysql> use mysql;

   3. Change password for user suresh:

      mysql> update user set password=PASSWORD("NEWPASSWORD") where User='suresh';

   4. Reload privileges (very important):

      mysql> flush privileges;

      mysql> quit

Powered by ScribeFire.

Popularity: 43% [?]

Share This

No Comments »
Filed under: Mysql Tips & Tricks, Uncategorized