Install failure on OSX

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

AIVAS
Posts: 11
Joined: Tue Nov 30, 2004 8:42 pm

Hmmm.

Post by AIVAS »

I installed it on a Fedora Core 2 system. Had the exact same error.

1st problem noted. Installer does NOT create database. I had to create it manually. Once I did the error re: "Database doesn't exist" went away. This really should be part of the installation. :idea:

I created a user phpmyfaq and gave them FULL rights to ONLY the phpmyfaq database I created.

I used that user name & password as the database user & password in the installer and received the exact same error as OSX.

Off the cuff, I tried using the MySQL ROOT user and password for the database user & password and the install completed successfully. :shock:

I have to admit I'm not all that comfortable with having to use the ROOT user & password on a system that may go live to the enitire internet. Shouldn't a properly configured MySQL user (full rights to ONLY the phpMyFAQ database) be enough? :?
Thorsten
Posts: 15741
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

most of the users do not have root access to the database. You're right, there might have been a function to try to create a database.
You do not need root access to your MySQL server to install phpMyFAQ. A user with the right to create, select, update and delete is enough.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
AIVAS
Posts: 11
Joined: Tue Nov 30, 2004 8:42 pm

OSX too

Post by AIVAS »

I've successfully installed phpMyFAQ on both OSX systems. The resolution was the same as the Fedora Core 2 system. I had to create the database manually and then specify the ROOT MySQL user & password in order for it to create the tables (even though there is a user that has FULL rights to that table I created - it fails with the "can't connect" error)
Thorsten
Posts: 15741
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

curios problem. I'll talk about that with my Mac friend.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply