[prev in list] [next in list] [prev in thread] [next in thread] 

List:       phorum
Subject:    Re: [phorum] Need MySql Help
From:       hernan () turas ! com
Date:       1999-10-28 13:53:03
[Download RAW message or body]


Hi, I've been wrestling with this the last week or so and I've been getting
the same kind of errors, it seems like the readme is not clear enough. I
did the following:

- After compiling and installing mysql
- as root: run the ./mysql_install_db
- set the root password with ./mysqladmin -u root password 'new_password',
I run: ./mysqladmin -u root password 'password'
- create the database: ./mysqladmin -uroot -ppassword create mydb
- create some user for php3. I used nobody just to test it, note you should
use other user, read security.txt
- create a nobody user for the db. I did ./mysqladmin -u nobody password
'password'. This sets a new user nobody with the password:password.
Again, this is just for testing purposes, read security.txt. For more
information on how to do this check in the mysql distribution
/Docs/manual_toc.html section 6.12 and around, that's what I read to do
this
- now grant the rights stated in the readme.
./mysql -p password    (remember password is the password I set for root,
change for whatever you used)
grant select, insert, update, create, alter, delete, drop on mydb.* to
nobody@localhost identified by 'password';  (again change password to
whatever you set before)
- now go ahead and edit the file forums.inf inserting the correct values,
for our example it would be:
...
$dbName='mydb';
$dbUser='nobody';
$dbPass='password';
$dbServer='localhost';
....

That done it should be working. Don't forget to rename the *.inf-dist to
*.inf (as the readme instructs). I am sure there are other ways to do this,
but this one worked for me. Hope this helps.
Bye, Hernan


After setting up mysql and running the mysql_install_db script as the
documentation states


                                                                                      \
                
                    "Andreas                                                          \
                
                    Banze"               To:     "Mike" <webmaster@kornkrib.com>, \
                "phorum@phorum.org"              
                    <aba@ivm.net>        <phorum@phorum.org>                          \
                
                                         cc:                                          \
                
                    10/27/99             Subject:     Re: [phorum] Need MySql Help    \
                
                    06:09 PM                                                          \
                
                    Please                                                            \
                
                    respond to                                                        \
                
                    "Andreas                                                          \
                
                    Banze"                                                            \
                
                                                                                      \
                
                                                                                      \




On Wed, 27 Oct 1999 15:57:50 -0500, Mike wrote:

> Now I am getting an other weird error telling me my password wasn't
> accepted.

did you use the correct one and does it work with mysql?

> I don't think this is ever going to end this on going trouble. Stupid
> servers

Try it another way: First set up MySQL following the readme (it isn't that
bad), then setup phorum.
If MySQL is configured incorrectly phorum will not work.

MfG
Andreas Banze

--
IVM Gesellschaft fuer Internet, Vernetzung und Mehrwertdienste mbH
Zissener Str. 8 D-53498 Waldorf Fon 02636-97690 Fax 02636-9769-999
               Andreas Banze (aba@ivm.net) http://www.ivm.net/



---------------------------------------------------------------------
To unsubscribe, e-mail: phorum-unsubscribe@phorum.org
For additional commands, e-mail: phorum-help@phorum.org







---------------------------------------------------------------------
To unsubscribe, e-mail: phorum-unsubscribe@phorum.org
For additional commands, e-mail: phorum-help@phorum.org


[prev in list] [next in list] [prev in thread] [next in thread]