Access Denied Mysql error

mike_s · Post by **mike_s** » Mon Apr 04, 2005 11:04 pm

Hi,

I am having similar problems to other members with the "Error: Access denied for user:" mysql error during the install process. I created a db called 'faq' for the application on my server. I also created a user with proper permissions. When that failed I read the boards and tried again with the root user and that still doesn't work. Can I not use 'localhost' for my 'Database server:" field?

I am using OS X Server. This is the second machine I have been unable to install this software on. (the other was an IBM server running redhat 9, I attempted the install in early December '04)

Any advice greatly appreciated.

Thanks,
Mike

Post by **Thorsten** » Tue Apr 05, 2005 8:47 am

Hi,

did you do a "FLUSH PRIVILIGIES" to add the new user? Does the user have the correct rights to CREATE tables?

bye
Thorsten

mike_s · Post by **mike_s** » Tue Apr 05, 2005 3:16 pm

Hi Thorsten,

I am not exactly sure what you mean by "FLUSH PRIVILIGIES" to add the new user". If you could briefly explain I will try it.

Other attempts.
I have chowned the entire faq folder and all its contents to both the admin user (me) and the www user. I have also chmoded all the files to 777 and 7777 as recommended by other people on this board.

Before I changed permissions on the files I received the permission denied errors that other have mentioned. Once I do the change I get to the screen where you enter the mysql info. It is after I enter my mysql info that I get the aforementioned error.

Here is what I entered on the mysql screen:
server - localhost
user - root
password - password
database phpMyFAQ (I created it prior to running the installer)
prefix - left empty

Also I have both safe mode and register globals off.

I would really like to use phpMyFAQ, I have checked many of the references listed on your site and it seems to be a great piece of software.
I am just really confused as to why I am having so many install problems.

Thanks,
Mike

Post by **Thorsten** » Tue Apr 05, 2005 3:22 pm

Hi Mike,

the error Error: Access denied for user: comes directly from the MySQL database server. The problem can be a wrong database password. What version of phpMyFAQ do you use? Which version of PHP do you use?

bye
Thorsten

mike_s · Post by **mike_s** » Tue Apr 05, 2005 4:53 pm

Thorsten

Here is what I am using.

PHP version: PHP 5.0.3
MySQL client version: MySQL 4.0.18
phpMyFAQ - 1.4.7 (also tried the 1.5 beta version, same exact error)

The mysql user error makes no sense to me as I can connect to mysql using those same user/pass combinations on my server via php. I am able to successfully query a test table that I added to the db I created for this app.

all file permissions are set like this:
-rwxrwxrwx 1 admin admin 22292 5 Apr 10:50 installer.php

Still receiving this error:
"Error: Access denied for user: 'mike@localhost' (Using password: YES)"

If you can help me out with this i will definitely visit your wishlist. I am running out of time to get this working.

Thanks alot,
Mike