[Typo3-linux] some rather major Typo3 problems

[Doug Gough]

Re: database problems

> > 2. Just take the database.sql (or similair) from your typo3conf
> > directory and create the database manually via command line. Search
> > google or whatever to learn how to import a database from .sql-file into
> > mysql via shell.
> > Otherwise use phpmyadmin (see sf.net) to import the file.
>
> Okay, thank you.

Here's what I do.

1. I use the MySQL module in Webmin, but you could use phpmyadmin or the
command line, to create a database called typo3, or whatever you like.
2. Create a user called typo3 at localhost with no rights at the root level of
MySQL
3. Create database permissions on the typo3 database, for user
typo3 at localhost, giving them all permissions. Now user typo3 can do anything
to the typo3 database, but nothing anywhere else.
4. Install typo3 as instructed in the install text file that comes with the
package.
5. Run the install tool, and when it gets to the database info, enter the
user info and then save localconf.php before trying to select a database.
6. Restart the typo3 install tool, go down to the database info part again,
and now all the available databases are listed, so I select typo3, and save
my localconf.php again.
7. Select the "database analyzer" menu entry, from the top of the page, and
follow the instructions to IMPORT "typo3conf/freesite_dummy_database.sql" or
whatever package you are using.
8. Occasionally, I have gotten errors at this point, but the import works
anyway, and I can logon to the backend and get to work.

Hope that helps.

Doug Gough