Page 1 of 1

where is my database

PostPosted: 14. April 2009 08:59
by sunriseast
I creat a database 'mytestbase' by phpmyadmin and it works well.
But I can't see 'mytestbase' afert I used commands in terminal as follow:

sudo /opt/lampp/lampp startmysql
/opt/lampp/bin/mysql

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.00 sec)

mysql>

Only show information_schema and test ,Why?

Re: where is my database

PostPosted: 14. April 2009 09:49
by Wiedmann
Only show information_schema and test ,Why?

Because as anonymous user (no user/pass used while invoking the mysql command) you don't have privileges to see more.

Re: where is my database

PostPosted: 14. April 2009 09:51
by sunriseast
/opt/lampp/bin/mysql --user=urID --password=itPassword

try and ok

thank u