Skip Authorization on MySQL DB

To skip authorizations and login without password to MySql server,

  1. sudo vi /etc/mysql/my.cnf
  2. Add the line skip-grant-tables after the linewhich reads skip-external-locking.
    1. Optionally comment the line bind-address = if the db has to be accessed from external devices via TCP.
  3. Save and quit vim.
  4. restart mysql server ( sudo /etc/init.d/mysql restart in ubuntu)
Kj [/.] Sreekumar programs computers as a hobby and profession. Into programming from his school days, Sree uses Codemarvels to key in facts and fixes he finds interesting while working on different projects. Some of the articles here give away a few shades of his philosophical leanings too.

Leave a Comment

Your email address will not be published. Required fields are marked *