Well, the thread title is wrong now - this is a MySQL question... > shell> mysql -e "GRANT ALL ON mwforum.* TO mwfo...@localhost IDENTIFIED BY > 'password'" > > I have named my database msn so I assume mwforum.* should be msn.*
Yes. > mwfo...@localhost I think should be m...@localhost Could be. In this context, "mwforum" and "msn" are MySQL usernames; use whatever will remind you of their function in three years' time... > password is the password for mysql database?? It's the password for *that user*. > The error I am getting is > > Error 1045 (28000) Access denied for user 'root'@'localhost' (using > passowrd: NO) Try adding "-p" to your mysql command. Make sure you know the root MySQL password. > The stupid thing is I have setup the forum on a test machine and did not > have a problem but doing it again on the server is causing me problems. Your test machine probably had no root MySQL password set. Your production machine definitely should... Vic. -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --------------------------------------------------------------
