Sunday, August 14, 2011

MYSQL: logging with out userid and pwd

at times when u import the db it may erase ur userid and pwd. When the java tries to connect to the db it throws exception that this ip is not allowed to connect to the db; in such a case use the below fix. it removes the necessity to have userid and pwd to loginto the mysql

  1. skip-grant-tables under the section [mysqld]
  2. restart the mysql: /etc/init.d/mysqld restart

be careful that u dont do this on production dbs

No comments:

Post a Comment