Greetings, I'm a new user for MYSQL and I face problem adding mysql database.
After typing: SHOW DATABASES; I got this: +----------+ | Database | +----------+ | test | +----------+ 1 row in set (0.02 sec) which does not contain mysql and tmp as shown: +----------+ | Database | +----------+ | mysql | | test | | tmp | +----------+ How can I create mysql database? I have gone through the manual provided, but I don't really understand the way to create it. And, I'm facing these problems too: mysql> GRANT ALL ON menagerie.* TO 'lampp'@'localhost'; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'menagerie' mysql> create database menagerie; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'menagerie' May i know how to overcome these problems? Please guide me. I really need your help.THANK YOU! __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]