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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-05 05:36:17  来源:igfitidea点击:

Default MySQL database name

mysqllinux

提问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_dbafter the server is running to create a mysqldatabase, 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

  1. Do you have full database access? Then just add a database with a name of your choice:

    CREATE DATABSE rob_bb;
    
  2. If you only have a normal user access, the database name is often the same as the username.

  3. Or you can run the query

    SHOW DATABASES;
    
  1. 你有完整的数据库访问权限吗?然后只需添加一个具有您选择的名称的数据库:

    CREATE DATABSE rob_bb;
    
  2. 如果您只有普通用户访问权限,则数据库名称通常与用户名相同。

  3. 或者您可以运行查询

    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”,那就是它。