[wplug] MySQL and phpBBS

[Wise, Jeremey]

Thanks for the help. Here is the latest steps I took. After I did the
install against the "test" DB and it worked I started looking at the
schema and setup of my database "mywebsite" and the user "mywebsite"
which was the account for that database I wanted updates to be done
as(ia not the god account msdba).

I also found that the 'test' database had tables added to them so I
coppied the "/var/lib/mysql/test" directory to
"/var/lib/mysql/mywebsite" and restarted engine. Still no change in the
install error.

Then I figured I would delete the 'mywebsite' db and start over with
import per your note below.
*************
[root at venus]# find . -name *.sql
./Members/BullitenBoard/phpBB2/install/schemas/mysql_schema.sql
./Members/BullitenBoard/phpBB2/install/schemas/mssql_schema.sql
./Members/BullitenBoard/phpBB2/install/schemas/postgres_basic.sql
./Members/BullitenBoard/phpBB2/install/schemas/mysql_basic.sql
./Members/BullitenBoard/phpBB2/install/schemas/postgres_schema.sql
./Members/BullitenBoard/phpBB2/install/schemas/mssql_basic.sql
[root at venus]# mysql -u mywebsite -p mywebsite <
/var/www/html/mywebsite/Members/BullitenBoard/phpBB2/install/schemas/mys
ql_schema.sql
Enter password:
ERROR 1045: Access denied for user: 'mywebsite at localhost' (Using
password: YES)
[root at venus mysql]# mysql -u msdba -p mywebsite <
/var/www/html/landofthevisigoths/Members/BullitenBoard/phpBB2/install/sc
hemas/mysql_schema.sql
Enter password:
[root at venus mysql]#

***** 
I must be missing something simple here. I checked user permissions in
mysql and user is listed with full rights and password has is same as
mydba which means their the same. Under database permissions user
'mywebsite' is listed with full rights for the database. 

My opinion is that this is a stupid setup error on the mysql side. 

Any thoughts?



-----Original Message-----
From: wplug-bounces+jeremey.wise=agilysys.com at wplug.org
[mailto:wplug-bounces+jeremey.wise=agilysys.com at wplug.org] On Behalf Of
Drew from Zhrodague
Sent: Monday, November 28, 2005 5:06 PM
To: General user list
Subject: RE: [wplug] MySQL and phpBBS

> Well update .. I just figured "what the heck" and tried to point to
the
> default "test" database and use the credentials of the master DBA
admin
> account (which I made as msdba ->old Microsoft sql habit:P ) and it
> succeded.
>
> Sooooo.... uh... now I have it up.. but done wrong. I will post once I
> monkey around to figure out how to correct apparently how I am
creating
> the database or phpBB installation.

 	Did you import the initial schema for phpBB into MySQL? Should 
have been a procedure in the installation instructions like this:

mysql -u user -p db-name < someschema.sql


-- 

Drew from Zhrodague
drew at zhrodague.net
http://www.WiFiMaps.com
http://moblog.zhrodague.net
_______________________________________________
wplug mailing list
wplug at wplug.org
http://www.wplug.org/mailman/listinfo/wplug