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.