86
Quote:You have to use the values from this example file to fill in the installation screens or you can adapt your mainfile.php with it.
In screen database connection:
Database: MySQL
Server hostname: MY SQL SERVER
User name: USERNAME
Password: PASSWORD
In screen database configuration:
Database name: family
Table prefix: as proposed
charset and collation as your db is
In mainfile.php this will become:
Of course MY SQL SERVER, USERNAME, PASSWORD, family have to be substituted.
This is what dbtest.php contains:
mysql_connect("MY SQL SERVER", "USERNAME", "PASSWORD") or die(mysql_error());
echo "Connected to MySQL
";
mysql_select_db("family") or die(mysql_error());
echo "Connected to Database";
?>
In screen database connection:
Database: MySQL
Server hostname: MY SQL SERVER
User name: USERNAME
Password: PASSWORD
In screen database configuration:
Database name: family
Table prefix: as proposed
charset and collation as your db is
In mainfile.php this will become:
// Database
// Choose the database to be used
define( 'XOOPS_DB_TYPE', 'mysql' );
// Set the database charset if applicable
if (defined("XOOPS_DB_CHARSET")) die();
define( 'XOOPS_DB_CHARSET', 'utf8' );
// Table Prefix
// This prefix will be added to all new tables created to avoid name conflict in the database. If you are unsure, just use the default "xoops".
define( 'XOOPS_DB_PREFIX', 'x1234' );
// Database Hostname
// Hostname of the database server. If you are unsure, "localhost" works in most cases.
define( 'XOOPS_DB_HOST', 'MY SQL SERVER' );
// Database Username
// Your database user account on the host
define( 'XOOPS_DB_USER', 'USERNAME' );
// Database Password
// Password for your database user account
define( 'XOOPS_DB_PASS', 'PASSWORD' );
// Database Name
// The name of database on the host. The installer will attempt to create the database if not exist
define( 'XOOPS_DB_NAME', 'family' ); 
