where is my database

Problems with the Linux version of XAMPP, questions, comments, and anything related.

where is my database

Postby sunriseast » 14. April 2009 08:59

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?
sunriseast
 
Posts: 2
Joined: 14. April 2009 08:44

Re: where is my database

Postby Wiedmann » 14. April 2009 09:49

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.
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: where is my database

Postby sunriseast » 14. April 2009 09:51

/opt/lampp/bin/mysql --user=urID --password=itPassword

try and ok

thank u
sunriseast
 
Posts: 2
Joined: 14. April 2009 08:44


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 18 guests