title: How to disable --skip-grant-tables in MySQL?
body: <p>I am trying to initialize the database for my OpenGTS installation. However, when I run the shell script that accomplishes this, I get the following error:</p>
  
  <pre><code>Version: 2.4.5
  Database created: gts
  [ERROR|DBAdmin.execCommands:843] ==&gt; SQLException: DB grant error [jdbc:mysql://localhost:3306/]
  [ERROR|DBAdmin.execCommands:843] Message:   The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
  [ERROR|DBAdmin.execCommands:843] SQLState:  HY000
  [ERROR|DBAdmin.execCommands:843] ErrorCode: 1290
  [DBAdmin.execCommands:843] java.sql.SQLException: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
  java.sql.SQLException: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)
          at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1647)
          at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1566)
          at org.opengts.dbtools.DBConnection._executeUpdate(DBConnection.java:961)
          at org.opengts.dbtools.DBConnection.executeUpdate(DBConnection.java:908)
          at org.opengts.dbtools.DBConnection.executeUpdate(DBConnection.java:889)
          at org.opengts.dbtools.DBProvider.grantDBUser(DBProvider.java:2132)
          at org.opengts.dbtools.DBAdmin.execCommands(DBAdmin.java:841)
          at org.opengts.db.DBConfig._main(DBConfig.java:1246)
          at org.opengts.db.DBConfig.main(DBConfig.java:1361)
  </code></pre>
  
  <p>I think it's pretty clear that I need to disable --skip-grant-tables, but I am new to MySQL and SQL in general. Recently, I followed a tutorial to reset the MySQL root password and I believe I enabled --skip-grant-tables through that. I've tried looking for solutions to disable this, but haven't come across anything. </p>
  
  <p>Anyone able to help?</p>