Try mysql -uroot
On 2005年08月23日 12时09分25秒, 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. > > 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] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
