Re: No Root User
I have the same problem and the proposed solution doesnt work, simply because the root user does not exist on the mysql.user table.
I have verified this by doing:
/etc/init.d/mysql stop
mysqld --skip-grant-tables &
mysql -u root mysql
mysql> select user,host from user where user='root' \G
...and there's no output.
The only way I found to make it work is inserting the root user into the table by doing:
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);
mysql> INSERT INTO user VALUES ('127.0.0.1','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);
...however I dont like this method and I would like to find a different solution.
I am using Ubuntu Jaunty and I install mysql by doing: apt-get install mysql-server
Any ideas?