I'm trying to run phpBB2 software on Apache2, all was fine with setups except I had no password protecting my database.

After researching how to do it, I attempted to set password "freddy" to root (for obvious reasons "freddy" isn't the actual pw I used).

I now can't login to MYSQL4 using root at all, I have to use "mysql -u freddy". Then I'm logged in as "freddy@localhost" but still with no password.

Logging is as root I get:-

# mysql -u root

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Logging in as "Freddy" I get:-

# mysql -u Freddy

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 4.1.14-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

I've tried reinstalling MYSQL4, but the config data remains.

Could anyone help me remove the user "freddy" and add a password to protect the root login?

I'd be happy to delete all & start again as the db currently contains no data at all.

Many thanks,

Mark.

Solved my own problem so thought I'd post solution.

#mysql -uroot =p" mysql

Then enter a password and all is fine again.

I found this solution in one of the replies to This Thread

Mark.