No user Root ?

[mrfisho]

Okay I have a weird problem which for the life of me I can't work out.. Thought I had lost theroot password but seems root user has gone.. I did install psa software for some testing .. (webhosting software) Thogh I did un-install it and ebverything seemed fine for a few weeks, now this !.. >> mysqladmin: unable to change password; error: 'Can't find any matching row in the user table' . I have followed the instuctions to change password for root user from the mysql documentation. any help would be much appeciated .

 

[ericbrunson]

grep root /etc/passwd /etc/shadow" to see if the account exists. If not, it's easy enough to add it back. Let us know.

 

[mrfisho]

I think you misunderstoof me.. root as in linux root is fine.. root user for mysql though is not.. the error is for mysql only .. so I am guessing mysql is missing the root user table >?

 

[rzs0502]

Start the database in standalone mode.
Then add the root user. (similar process to changing a forgotten root password)


"If you always do what you've always done, you will always be where you've always been."

 

[mrfisho]

I am using Linux not Windows .. mysqld --standalone does not start it.

 

[rzs0502]

Does "C:\> C:\mysql\bin\mysqld --standalone" for an example not work??
How about making a backup of the Data directory and running mysqld --install to recreate the mysql database and permissions?


"If you always do what you've always done, you will always be where you've always been."

 

[mrfisho]

C:\> C:\mysql\bin\mysqld --standalone"
is for Windows Box.. I use Linux.. I need to add a user root to the mysql user database.. where and how >? remember I can start mysql with>>>>>> mysqld_safe --skip-grant-tables & <<<<<<< But whats the command to add root user ?.

 

[mrfisho]

Okay so it goes to show they don't tell all when you install 3rd party programs.. seems like PSA removes root user from mysql and adds admin user.. once I realised this changing the password was simple.. all is fine now .. thanks for the replys..