Friday, May 21, 2010

No root user created for mysql in Ubuntu Hardy


/etc/init.d/mysql stop
mysqld --skip-grant-tables &
mysql -u root mysql
mysql> INSERT INTO user VALUES ('localhost','root',password('newpassword'),'Y','Y ','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y', 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','' ,'','','',0,0,0,0); 

No comments: