Just a brief status update:
I was able to create a database (I think), though I'm not exactly sure how to check to make sure it's running.
I used the following line to create the database:
mysqladmin -u username -p create database
It prompted me for a password and I entered the password for the username and all seemed well.
When I type the following:
mysql -u username -p database
It takes me to a password screen where my passord gets me access to the following prompt:
mysql>
If I type "status" there, I get the following:
mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (x86_64)
Connection id: 34
Current database: database
Current user: username@localhost
Current pager: stdout
Using outfile: ''
Server version: 3.23.58
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 50 min 12 sec
Threads: 1 Questions: 39 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.013
Note: I didn't use the database name "database" nor username "username".
Anyways, this looks like I set the database up OK to me. When I edited the config.php, I entered the following:
// ****** DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$dbusername = 'username';
$dbpassword = 'password';
// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$dbname = 'database';
Everything is entered the same as what gives me access to the prompt. When I try to run the install program, I still get an "unable to connect to database" error.
