mysql xampp MariaDB doesn't show all databases

Question

First, I want to say that i am a beginner of mysql. I installed xampp and i'm trying to work out with mysql and i started the mysqld which gives me some errors on Innodb. When I digit show databases; I get returned only 2 databases, the standard, while in phpmyadmin it shows much more databases, more of those was been created by me. Why?

Which databases can you see in phpmyadmin and which can you see with show databases;? — oschlueter
– oschlueter, Commented Dec 22, 2016 at 21:31
In command line i see Information_schema and Test, while in phpmyadmin i see these plus all the others i built before — lisarko8077
– lisarko8077, Commented Dec 23, 2016 at 4:12

Rick James · Accepted Answer · 2016-12-24 02:10:09Z

2

You are not logged into MySQL with sufficient privileges to see all the databases.

answered Dec 24, 2016 at 2:10

Rick James

144k15 gold badges144 silver badges255 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

lisarko8077 Over a year ago

Yes, i have just solved it with your solution. I was not logging in with my user but with generic mysql without -u USER -p. Thank you

Collectives™ on Stack Overflow

mysql xampp MariaDB doesn't show all databases

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related