re: ADDING MYSQL DATABASE

2005-08-22 Thread Gu Lei
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

re: ADDING MYSQL DATABASE

2005-08-22 Thread Ehrwin Mina
HI, If you want i can send you the help file so you dont need to browse anytime you need a command in mysql. Thank you, ehrwin At 03:13 PM 8/22/2005, Gu Lei wrote: Hi That's a problem about privileges. Try mysql -uroot. Please have a look at

Re: ADDING MYSQL DATABASE

2005-08-20 Thread Jasper Bryant-Greene
tai huijia wrote: SHOW DATABASES; I got this: +--+ | Database | +--+ | test | +--+ 1 row in set (0.02 sec) which does not contain mysql and tmp as shown: You need to log in (to MySQL) as root if you want to see the mysql database. It contains sensitive information

Re: ADDING MYSQL DATABASE

2005-08-20 Thread Enrique Sanchez Vela
--- Jasper Bryant-Greene [EMAIL PROTECTED] wrote: tai huijia wrote: You need to log in (to MySQL) as root if you want to see the mysql database. It contains sensitive information which will only appear to root. check your my.cnf or ini file and check for this parameter: