如何在Windows 8上使用Wamp或Xampp安装pimcore? [英] how can i install pimcore using wamp or xampp on windows 8?

问题描述

我同时安装了XAMPP和WAMP.我正在安装Pimcore，但是出现错误消息"Couldn't establish connection to MYSQL: Access denied for user 'sadegh'@'localhost' (using password: YES)". 我阅读了安装手册，上面写着我必须手动创建数据库.我应该如何创建数据库?我应该放在哪里? 有人可以帮忙吗?这真杀了我.

I have both XAMPP and WAMP installed .I am installing Pimcore but there is an error which says "Couldn't establish connection to MYSQL: Access denied for user 'sadegh'@'localhost' (using password: YES)". I read the installation manual it says i have to create a database manually . how should i create a database? and where should i put it? can anybody please help?this is killing me.

推荐答案

正如错误所说，您必须自己在MySQL中创建数据库.这是在XAMPP(WAMP的非常相似)中的操作方法:

As the error say, you have to create the database in MySQL yourself. Here is how to do it in XAMPP (very similair for WAMP):

1. 打开XAMPP控制面板，然后单击外壳"按钮

1. Open XAMPP Control Panel and click the "Shell" button

在外壳程序窗口中，首先使用以下命令连接到数据库:

In the shell window, first connect to the database using the following command:

mysql -h localhost -u root

使用以下命令创建一个新数据库，我将其命名为"pimcore_sample"，并将其设置为使用UTF8:

Create a new database with the following command, I named mine "pimcore_sample", also set it to use UTF8:

CREATE DATABASE pimcore_sample CHARACTER SET utf8 COLLATE utf8_general_ci;

如果一切成功，那么您的输出应该是这样的:

If all is successful, your output should be something like this:

现在将信息输入到Pimcore设置中，如下所示:

Now enter the information into the Pimcore setup, like this:

不建议使用root用户，但是可以用于开发.确保创建另一个用于生产的用户(请参见 http ://dev.mysql.com/doc/refman/5.1/zh-CN/user-account-management.html ).

Using the root user is not recommended, but works for development. Make sure to create another user for production use (see http://dev.mysql.com/doc/refman/5.1/en/user-account-management.html).

这篇关于如何在Windows 8上使用Wamp或Xampp安装pimcore?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！