I'm kinda new to mySQL and I set up a user (myself) and a database for myself on our webserver at work. I did the "insert into" into the User table and the Db table. However, when I try to log into the database I get errors. I go to my mysql path on the machine and do:
./mysql -u username -p database it asks me for my password and I type it in and I get : ERROR 1045: Access denied for user: 'tomr@localhost' (Using password: YES) Now I know the database works just fine, I can get into it if I log in as root and manage it just fine. In the User table I gave myself no privelages (as recommended) but in the Db table I gave myself full control. I'm guess this is some sort of user issue, but I can't put my finger on it. Anyone got any ideas? Otherwise I'll go in to work tomorrow and listen to my boss mock my mysql skill all day :) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
