Hi,

I've somehow lost the root user for mysql i installed from a pkg at pkg.nl.cobalt.com. Now ive run uninstall and tried to re-install and when i do it says something about data found in /home/mysql (i think). This is stopping it redoing the root user right?

How can i solve this? would deleteing all data saved in /home/mysql once the PKG is unstalled solve this problem?

This is on a brand new server so there is no user databases created on it.

Thanks For your Time.

i had the same problem when i first got my 4i. fresh pkg of mysql, problem with root user.

i had to restart in safe_mysql with --skip -grant -tables, then i added the root user to the user list.

it is extremely easy if you have phpMyAdmin installed. in case you don't know many of the mysql commands.



here's all the bookmarks i have left from when i was doing that. hope they help.

http://www.mysql.com/doc/A/c/Access_denied.html
http://www.mysql.com/doc/R/e/Resetting_permissions.html
http://www.mysql.com/doc/G/R/GRANT.html


i remember searching around WHT and the cobalt users list and getting this done fairly quickly.

sorry i couldn't have been more helpful.

Thanks for the reply.

So i stop my current pid and start it with the command you said.

Then make a user called root and give it a password.

Stop Mysql and start it normally ?

I got it sorted thanks to those links.

Thanks Skylab.