Please Help with MySql setup

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Please Help with MySql setup

Postby expo » 15. August 2007 22:49

I installed Xampp to see if my sites will be compatible with PHP5.

I exported all of my MySQL databases from my server and imported them into the xampp install.

I copied all my files and went at it. Discovered I needed mod_rewrite activated so I did that. but here is my error

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'name_name'@'localhost' (using password: YES) in D:\xampp\htdocs\site\include\flap-mysql.inc.php on line 190

so here is my question:

Am i missing something? Also, how do I set up users and passwords for databases? I am used to using CPanel.

If this is pointed out in a faq please shoot me a link but I have not been able to find it.
expo
 
Posts: 5
Joined: 15. August 2007 22:19

Postby Wiedmann » 15. August 2007 22:56

Code: Select all
Access denied for user 'name_name'@'localhost' (using password: YES)

Am i missing something?

Your script is configured to use this user and password for the MySQL connect. But you don't have this user in your local (XAMPP) MySQL installation.

Also, how do I set up users and passwords for databases?

http://dev.mysql.com/doc/refman/5.0/en/ ... ement.html

I am used to using CPanel.

I don't know this program... In XAMPP, phpMyAdmin can help you to manage MySQL.

If this is pointed out in a faq please shoot me a link

Just look at the top of this forum for a link to the FAQ. The XAMPP demopages (and readme) can also help you.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby expo » 15. August 2007 23:00

Thanks! That looks like exactly what I was looking for.

btw. CPanel is the largest webhosting control panel http://www.cpanel.net
expo
 
Posts: 5
Joined: 15. August 2007 22:19

Postby expo » 16. August 2007 04:01

hey, i just actually looked at that page. Are you saying that I have to use shell access to create a user for a mysql database in xampp? Just importing the database is not enough?

yikes! I don't even know how to access mysql through shell access in xampp.
expo
 
Posts: 5
Joined: 15. August 2007 22:19

Postby expo » 16. August 2007 04:28

I know this is not secure but for a test environment:

On this document

http://www.apachefriends.org/winxampp/readme_en.txt

* PASSWORDS:

1) MySQL:

User: root
Password:
(means no password!)



lots easier!!!!
expo
 
Posts: 5
Joined: 15. August 2007 22:19


Return to XAMPP for Windows

Who is online

Users browsing this forum: hthnightwolf and 67 guests