Hi That's a problem about privileges. Try mysql -uroot. Please have a look at http://dev.mysql.com/doc/mysql/en/privilege-system.html and http://dev.mysql.com/doc/mysql/en/user-account-management.html
regards On 2005年08月20日 14时46分26秒, tai huijia wrote: > 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. > > Please guide me. 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] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]