notes/technology

Skip Authorization on MySQL DB

Posted on by Sreekumar Kj

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 = 127.0.0.1 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)
,
Sreekumar Kj
Sreekumar (KJ) has been a hobby programmer from school days. Codemarvels is his personal blog from the year 2010, where he writes about technology, philosophy, society and a bit about physics. He now runs a conversational AI company - DheeYantra - focusing his efforts to help businesses improve operational efficiency using digital employees powered by AI.