Linux 默认 MySQL 数据库名称
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/7002100/
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
Default MySQL database name
提问by Rob
I'm trying to install mybb on a server but the admin is taking too long to respond. I have all the information I need except the database name. Is there a default name for mysql on a linux server?
我正在尝试在服务器上安装 mybb,但管理员响应时间过长。除了数据库名称之外,我拥有所需的所有信息。Linux 服务器上是否有 mysql 的默认名称?
采纳答案by Dan Grossman
There is no default database.
没有默认数据库。
A fresh MySQL server install will have 0 databases. The install script will run mysql_install_db
after the server is running to create a mysql
database, which MySQL uses to store users and privileges. Don't put your data there.
新的 MySQL 服务器安装将有 0 个数据库。安装脚本将mysql_install_db
在服务器运行后运行以创建mysql
数据库,MySQL 使用该数据库存储用户和权限。不要把你的数据放在那里。
You can create your own databases by issuing CREATE DATABASE [name]
queries if your user has permission.
CREATE DATABASE [name]
如果您的用户有权限,您可以通过发出查询来创建自己的数据库。
回答by Mchl
No there is not...............
不,那里没有...............
回答by Puggan Se
Do you have full database access? Then just add a database with a name of your choice:
CREATE DATABSE rob_bb;
If you only have a normal user access, the database name is often the same as the username.
Or you can run the query
SHOW DATABASES;
你有完整的数据库访问权限吗?然后只需添加一个具有您选择的名称的数据库:
CREATE DATABSE rob_bb;
如果您只有普通用户访问权限,则数据库名称通常与用户名相同。
或者您可以运行查询
SHOW DATABASES;
to see what databases exist (which you are allowed to see).
查看存在哪些数据库(您可以查看)。
回答by Falcata
There are no default databases. If you were asking about default users 'root' would be it.
没有默认数据库。如果您问的是默认用户“root”,那就是它。