Apache Friends Support Forum

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.

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.

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

btw. CPanel is the largest webhosting control panel http://www.cpanel.net

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.

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!!!!