UBB.Developers Forums Community Development Programming MySQL and Server Configuration mysql newbie

hi all
right, i'm trying to install ubbthreads to my server.
It's running apache, and already has mysql installed.
I've looked around various documentation but it's all double-dutch tbh.
I've just re-installed mysql using the command %vinstall mysql as told to do here .
no-where in this process did it ask for a database name.
do i have to create a database? if so, how?
the address to the database server i cant seem to figure out either.
I'm a bit stumped tbh!
I downloaded apache, mysql and php onto myhome computer last night and had it all up and running, but cant seem to figure it out for my webserver.

you may find it easier to work with mysql using phpmyadmin available at www.phpmyadmin.net I had some issues with version 2.5(case sensitivity on a windows 2K/IIS server) but I think that the version 2.3 is what I am using on a hosted apache server that I am using with no issues that I am aware of. it makes it easy to work with you databases and create tables(and databases if you are doing this on your own server) etc. I think the command for creating the database is "CREATE DATABASE databasename" this is assuming you are logged in to administer the MYSQL Server.

i've discovered this is where my problem is, i'm not logged in as an administrator. i have access to the mysql server, i tried to create a database.

this is what i did:

mysql> create database ubbthreads;
ERROR 1044: Access denied for user: '@localhost' to database 'ubbthreads'
mysql>


Also, I tried to use phpmyadmin, but was getting the same problem
is there a config file or something?

How did you run mysql? It looks like you didn't specify a MySQL user.

This shell command runs mysql as MySQL user "root", and prompts you for that user's password:

$ mysql -uroot -p

After you get the database created, I recommend adding another MySQL user for UBB.threads to use, e.g., "ubbthreads_user". Make sure you give the user a password. That user should only have access to the UBB.threads database. I don't remember the command for creating a user, but here's an example of assigning the appropriate grants to the user "ubbthread_user" for the database "ubbthreads_db":

mysql> GRANT Select, Insert, Update, Delete, Create, Drop, Alter ON `ubbthreads_db` TO 'ubbthreads_user'@'localhost'

aha, i never knew that!
thanks david.
right, i've managed to log-in as a root user now, and have created the database ubbthreads.
what i'd like to do is use phpmyadmin for simplicity!
afaik, the only lines to edit on congif.inc.php are these two:

$cfgServers[$i]['user'] = '********'; // MySQL user
$cfgServers[$i]['password'] = '***********'; // MySQL password (only needed
// with 'config' auth_type)


but then when i go to phpmyadmin on my site, i get a pafe full of errors with this at the bottom.
MySQL said:


Access denied for user: 'nickjenk@localhost' (Using password: YES)

wow!
i think i've just solved my problem!
i used the wrong username, should have had 'root' in there instead.
heres hoping. lol.

The only other line of phpMyAdmin's config.inc.php file that I changed was:

$cfgPmaAbsoluteUri = '';

all fixed.
cheers all.