如何通过 XAMPP 使用 MySQL? [英] How do I use MySQL through XAMPP?

问题描述

我安装了 XAMPP v3.2.1 是因为我想学习如何在 MySQL 中创建数据库并了解有关 TOMCAT 的更多信息.但是，我对现在该做什么有点困惑.我已经阅读了许多博客和此页面上的文档 http://dev.mysql.com/doc/refman/5.0/en/creating-database.html.

I installed XAMPP v3.2.1 because I wanted to learn how to create database in MySQL and learn more about TOMCAT. However, I am a little confused about what to do now. I have read many blogs and the documentation on this page http://dev.mysql.com/doc/refman/5.0/en/creating-database.html.

按照指示，我发现:我无法访问我的本地主机.

While following the directions I found that: I can't access my local host.

尝试的解决方案:我关闭了Skype，因为我读到这可能是一个问题.我的计算机上没有任何旧版本的 XAMPP，而且我不相信我连接到任何其他服务器.所以，我无权做任何事情.

Attempted Solution: I shut down skype because I read that might be an issue. I don't have any older versions of XAMPP on my computer and I don't believe I am connected to any other servers. So, I don't have permission to do anything.

或

我是否试图通过错误的命令提示符访问 mysql?我正在尝试从 XAMPP shell 使用 MySQL.我不知道为什么我不能让一切正常.我是不是走错了路?

Am I trying to access mysql through the wrong command prompt? I am trying to use MySQL from the XAMPP shell. I am not sure why I cannot get everything working. Am I going about this the wrong way?

感谢您的帮助

推荐答案

XAMPP 只提供 MySQL (Database Server) &Apache(Webserver)在一个设置中，您可以使用 xampp starter 管理它们.

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

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

After the successful installation navigate to your xampp folder and execute the xampp-control.exe

按mysql行的开始按钮.

Press the start Button at the mysql row.

现在你已经成功启动了 mysql.现在有 2 种不同的方式来管理您的 mysql 服务器及其数据库.

Now you've successfully started mysql. Now there are 2 different ways to administrate your mysql server and its databases.

但首先您必须设置/更改 MySQL 根密码.启动 Apache 服务器并在浏览器的地址栏中键入 localhost 或 127.0.0.1.如果您尚未从 htdocs 文件夹中删除任何内容，则会出现 xampp 状态页面.导航到安全设置并更改您的 mysql root 密码.

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

现在，您可以在 http://localhost/phpmyadmin 下浏览到您的 phpmyadmin，或者下载一个 windows mysql 客户端，例如 navicat lite 或 mysql workbench.安装它并使用新的 root 密码登录到您的 mysql 服务器.

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

这篇关于如何通过 XAMPP 使用 MySQL?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！