php phpmyadmin 看不到新创建的数据库
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/13328867/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
phpmyadmin don't see new created databases
提问by user123321
I create db via mysql:
我通过 mysql 创建数据库:
CREATE DATABASE `my_db` CHARACTER SET utf8 COLLATE utf8_general_ci;
mysql>show databases - my_db is shown,
mysql>show databases - 显示 my_db,
then i'm login to phpmyadmin and don't see this db, only - information_schema, phpmyadmin, test
然后我登录到 phpmyadmin 并没有看到这个数据库,只有 - information_schema, phpmyadmin, test
p.s. ubuntu 12.04, mysql 5, phpmyadmin 3.4.10.1deb1
ps ubuntu 12.04,mysql 5,phpmyadmin 3.4.10.1deb1
采纳答案by functionvoid
You need to give your user access to that database, log into phpMyAdmin as the mysql administrator, go to the database in question and click on "permissions", then proceed to add your desired users to the database. Alternatively you can use the mysql client and issue the commands as SQL such as:
您需要授予您的用户访问该数据库的权限,以 mysql 管理员身份登录 phpMyAdmin,转到相关数据库并单击“权限”,然后继续将您想要的用户添加到数据库中。或者,您可以使用 mysql 客户端并以 SQL 形式发出命令,例如:
GRANT ALL ON db1.* TO 'finn'@'localhost';
授予所有 db1.* 到 'finn'@'localhost';
回答by HymanSparrow
If you Still don't see it, Try to logout from cpanel and then log in again to cPanel or PHPMyAdmin. It worked for me.
如果您仍然没有看到它,请尝试从 cPanel 注销,然后再次登录到 cPanel 或 PHPMyAdmin。它对我有用。
回答by Maneet
Clearing the browser cache, logging out and then logging in again worked. Originally found the solution here: https://www.godaddy.com/community/cPanel-Hosting/Database-not-showing-up-in-phpmyadmin/td-p/112397
清除浏览器缓存,注销然后重新登录即可。最初在这里找到解决方案:https: //www.godaddy.com/community/cPanel-Hosting/Database-not-showing-up-in-phpmyadmin/td-p/112397

