How to start MySQL with –skip-grant-tables?

by

I had the same problem as the title of this question, so incase anyone else googles upon this question and wants to start MySql in ‘skip-grant-tables’ mode on Windows, here is what I did.

Stop the MySQL service through Administrator tools, Services.

Modify the my.ini configuration file (assuming default paths)

C:\Program Files\MySQL\MySQL Server 5.5\my.ini

or for MySQL version >= 5.6

C:\ProgramData\MySQL\MySQL Server 5.6\my.ini

In the SERVER SECTION, under [mysqld], add the following line:

skip-grant-tables

so that you have

# 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

Start the service again and you should be able to log into your database without a password.

More Related Contents:

  1. How can I restore the MySQL root user’s full privileges?
  2. MySQL grant all privileges to database except one table
  3. I can not find my.cnf on my windows computer [duplicate]
  4. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  5. 1064 error in CREATE TABLE … TYPE=MYISAM
  6. MySQL DELETE FROM with subquery as condition
  7. Does adding ‘LIMIT 1’ to MySQL queries make them faster when you know there will only be 1 result?
  8. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  9. How to use LOAD_FILE to load a file into a MySQL blob?
  10. count(*) and count(column_name), what’s the diff?
  11. LOAD DATA INFILE easily convert YYYYMMDD to YYYY-MM-DD?
  12. When to use SELECT … FOR UPDATE?
  13. BULK INSERT in MYSQL
  14. Setting column values as column names in the SQL query result
  15. Count table rows
  16. MYSQL sum() for distinct rows
  17. How to lock a single row
  18. MySQL Cannot drop index needed in a foreign key constraint
  19. Laravel join with 3 Tables
  20. MySQL Insert & Joins
  21. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  22. How to join two tables using a comma-separated-list in the join field
  23. How to regex in a MySQL query
  24. How to remove duplicate entries from a mysql db?
  25. How do I write an SP in phpMyAdmin (MySQL)?
  26. Syntax error on MERGE statement
  27. MySQL throws Incorrect string value error
  28. ORDER BY alphabet first then follow by number
  29. mysql create table dynamically
  30. Errno 121, duplicate key on write or update?

Leave a Comment