It's me again!

I installed the mySQL 4.1 RPM on my RH9. It installed fine with just one command and I also started mysql, which seems to be running without any errors.

I've been looking in the mysql documents but I can't find a newbie answer, so I'll ask here.

I want to install Invision Power Board, I already have the files on the server but how do I create a database and create and assign a user to that database so that I can use it in IPB installation screen.

Just to let you know I used the visual tool called MySQL Administrator, which is worthless as it doesn't create the user for me, so I need help in shell.

Thanks a lot.

Generalizing:

If you log into mysql as root:
mysql -u root -p
(Unless you didn't assign a root password, in which case, do that before you finish reading this line.. right now, no right now... no right... now. )

And then to create the db:
create database MYNEWDATabAse
To create a user and give that user permissions (look at the mysql docs for more info on what perms you want to actually give):
GRANT ALL on NYNEWDATabAse to mamajama@localhost idenified by 'IamaGoodPassword';

And there you go. Hopefully you can figure out my "not so cryptic" parts that are variables.

Cool

yes I did create a password for root right after installation. I followed the above instructions, still got errors from IPB installation, I'll quit for tonight, if you have any suggestions about IPB, here's the error and submitting.

Fatal error: Call to undefined function: mysql_connect() in /home/amirp/www/html/ipb/ips_kernel/class_db_mysql.php on line 117

You have another rpm, something along the lines of php_mod or mysql_php (I really don't know the exact name as I don't use RH) but the basic idea is that you don't have php compiled with mysql support, or in other terms (since you didn't compile) RH will have included another RPM for those needing to use PHP with DB support.

Cool

php-mysql is what you may be referring to, I can't find where to download it. I found some articles at http://ca3.php.net/mysql but have no clue how to proceed.

One place to get it:
http://rpmfind.net//linux/RPM/redhat...17.2.i386.html

Cool

Should also be on any install CD's.

Cool

installed it, installed the glibc package as well, still no go.

Same error?

Restarting mysql each time you install a related package? Did you get any errors while creating or adjusting the perms (adding a user) on the DB?

Are there any tables being created?

Log in as root to mysql again:
mysql -u root -p
And then:
use MyWhateverDB
Then:
show tables;
And if you'd like:
describe tableX;

If there are no tables, maybe you need to allow more permissions (for troubleshooting you could try grant all if you haven't already) or check the docs for the Invision Power Board to see if you have to create the tables using a script they supply, or if it's part of the 'install' package you are trying to use (not familiar with that board type, so I can't give you specifics).

Cool

I don't think mysql is compiled with php still, and I don't know how to go around that. Even on the mysql download page I installed all RPMs, yes I got frustrated