Monday 6 January 2014

How to skip grants in MySQLdatabase or start without password

If you wants to start MySql in 'skip-grant-tables' mode on Windows or without password.

Please follow the steps below
1). Stop the MySQL service through Administrator tools, Services.

2). Modify the my.ini configuration file (assuming default paths)
     C:\Program Files\MySQL\MySQL Server 5.5\my.ini

3). Change the contents as:
      In the SERVER SECTION, under [mysqld], add the following line:
     skip-grant-tables

    As:

    # SERVER SECTION
    # ----------------------------------------------------------------------
    #
    # The following options will be read by the MySQL Server. Make sure that
    # you have installed the server correctly (see above) so it reads this
    # file.
   #
   [mysqld]

   skip-grant-tables

4). Start the service again and you should be able to log into your database without a password.
share|improve this answer