如何在Windows的XAMPP上激活MySQL数据库 [英] How to Activate MySQL Database on XAMPP for Windows

问题描述

我无法在用于Windows的XAMPP 上访问 phpMyAdmin ，问题可能出在 MySQL ，因为在 XAMPP状态，它表示 MySQL数据库已已停用.但是在我的 XAMPP控制面板应用程序上，我已经启动了 MySQL ，并且显示了 Running ，尽管我没有检查 Svc 复选框(是否必要?). 如何激活MySQL数据库以便我可以运行phpMyAdmin?

I can't access phpMyAdmin on XAMPP for Windows and the problem must be with MySQL, because on the XAMPP Status, it says MySQL database is DEACTIVATED. But on my XAMPP Control Panel Application, I've already started MySQL and it says Running, although I didn't check the Svc tick box (Is that necessary?). How to activate MySQL database so that I can run phpMyAdmin?

此外，当我打开 phpMyAdmin 页面时，它显示:

Also, when I open phpMyAdmin page, it says :

* 错误

MySQL表示:文档

MySQL said: Documentation

您在配置中定义的controluser的连接失败.*

Connection for controluser as defined in your configuration failed.*

我已经对这个问题的答案进行了研究，但是没有一个对我有用.

I've already done a research for an answer to this question, but none of them works for me.

推荐答案

仅XAMPP摘要MySQL(数据库服务器)&在一种设置中，Apache(Web服务器)可以使用xampp启动器进行管理.

XAMPP only summarys MySQL (Database Server) & Apache (Webserver) in one setup and u can manage them with the xampp starter.

安装成功后，导航到xampp文件夹并执行xampp-control.exe

Aftet the successfully installation navigate to your xampp folder and execute the xampp-control.exe

在mysql行按下开始按钮.

Press the start Button at the mysql line.

现在，您已成功启动mysql.现在，有两种方法可以管理mysql服务器及其数据库.

Now u started successfully mysql. Now there are 2 different ways to administrate your mysql server and his databases.

但是首先，您必须设置/更改MySQL Root密码.启动Apache服务器，然后在浏览器localhost或127.0.0.1中打开.如果您没有从htdocs文件夹中删除任何内容，则会显示xampp状态页面.导航到安全设置并更改您的mysql根密码.

But at first u have to set/change the MySQL Root password. Start the Apache server and open at your browser localhost or 127.0.0.1. If you didn't deleted anything from the htdocs folder the xampp status page appears. Navigate to security settings and change your mysql root password.

现在，在此之后，您可以浏览到本地主机下的phpmyadmin或下载Windows mysql客户端，例如navicat lite或mysql workbench.安装它并使用新的root密码登录到mysql服务器.

Now after this, you can browse to your phpmyadmin under localhost or download a windows mysql client for example navicat lite or mysql workbench. Install it and log to your mysql server with your new root password.

这篇关于如何在Windows的XAMPP上激活MySQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！