开发者

Listing MySQL databases on a local XAMPP install

开发者 https://www.devze.com 2023-02-10 10:25 出处:网络
I have a local MySQL install via XAMPP, running on OSX. PHPMyAdmin lists the databases that are running under the MySQL install, but when I run

I have a local MySQL install via XAMPP, running on OSX. PHPMyAdmin lists the databases that are running under the MySQL install, but when I run

mysql > show databases;

Only information_schema is listed. Wh开发者_Go百科at's the best way to go about troubleshooting this?


You are probably not connecting to MySQL with the right credentials.

Try supplying a username/password/host combination that actually has permissions to list databases through show databases command.

Something like this:

$ mysql -u root -h X.Y.Z.A -p

Then supply root's password. And I mean MySQL's root, not your OS X's root password.

0

精彩评论

暂无评论...
验证码 换一张
取 消