尽管以 root 用户身份登录，phpMyAdmin 表示没有创建数据库的权限 [英] phpMyAdmin says no privilege to create database, despite logged in as root user

问题描述

我需要使用 root 用户登录到 mysql 并创建一个数据库.但是，当我以 root 用户身份登录 PhpMyAdmin 时，它告诉我它没有权限"，因此无法创建数据库.

I need to login to mysql using root user and create a database. However, when I login to PhpMyAdmin as root user, it tells me that it has "no privileges", therefore cannot create a database.

我在安装 phpMyAdmin 时没想到会发生这种情况.有没有办法解决这个问题?请帮忙，谢谢！

I did not expect this to happen when I installed phpMyAdmin. Is there a way to fix this? Please help, thank you!

版本信息:

操作系统:OpenSUSE 12.1

OS: OpenSUSE 12.1

MySQL: mysql Ver 14.14 Distrib 5.5.25, for Linux (x86_64) using readline 6.2

MySQL: mysql Ver 14.14 Distrib 5.5.25, for Linux (x86_64) using readline 6.2

PhpMyAdmin:3.4.10.2

PhpMyAdmin: 3.4.10.2

推荐答案

这似乎是一个暂时性的问题，后来自行修复.谢谢大家的关注.

It appears to be a transient issue and fixed itself afterwards. Thanks for everyone's attention.

这篇关于尽管以 root 用户身份登录，phpMyAdmin 表示没有创建数据库的权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！