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

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.

How to re-take control of the root user in MySQL.

DANGER: RISKY OPERATTION

• Start session ssh (using root if possible).

• Edit my.cnf file using.

  sudo vi /etc/my.cnf
  

• Add line to mysqld block.*

  skip-grant-tables
  

• Save and exit.

• Restart MySQL service.

  service mysql restart
  

• Check service status.

  service mysql status
  

• Connect to mysql.

  mysql
  

• Using main database.

  use mysql;
  

• Redefine user root password.

  UPDATE user SET `authentication_string` = PASSWORD('myNuevoPassword') WHERE `User` = 'root'; 
  

• Edit file my.cnf.

  sudo vi /etc/my.cnf
  

• Erase line.

  skip-grant-tables
  

• Save and exit.

• Restart MySQL service.

  service mysqld restart
  

• Check service status.

  service mysql status
  

• Connect to database.

  mysql -u root -p
  

• Type new password when prompted.

This action is very dangerous, it allows anyone to connect to all databases with no restriction without a user and password. It must be used carefully and must be reverted quickly to avoid risks.

After trying lots of things, this is what worked for me:

sudo mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newpassword'; 

So first we use sudo to log in mysql as root without needing a password. Then we just update root's password.

After that, I restarted mysqld:

sudo service mysql restart

And the newpassword logged root in!

On the Linux system you can do following (Should be similar for other OS)

Check if mysql process is running:

sudo service mysql status

If runnning then stop the process: (Make sure you close all mysql tool)

sudo service mysql stop

If you have issue stopping then do following

Search for process: ps aux | grep mysqld Kill the process: kill -9 process_id

Now start mysql in safe mode with skip grant

sudo mysqld_safe --skip-grant-tables &

I'm in windows 10, using WAMP64 server. Searched for my.cnf and my.ini. Found my.ini in C:\wamp64\bin\mariadb\mariadb10.2.14.

Following the instructions from the colleagues:

1. Opened the quick start menu from Wampserver, selected 'Stop All Services'
2. Opened my.ini in a text editor, searched for [mysqld]
3. Added 'skip-grant-tables' at the end of the [mysqld] section (but within it)
4. Save the file, leave the editor open
5. In the Wampserver menu, select "Restart Services'. There will be a warning about the skip-grant-tables option
6. In the Wampserver menu select MySQL to open the prompt
7. It asked for a password, just press enter
8. Paste the command ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newpassword';
9. It must report that the operation was successful (no tables affected)
10. In the my.ini file, erase the 'skip-grant-tables' line, save the file
11. In the WampServer menu, select once more Restart Service

Now you can enter with the new password. Thanks to all answers here.