LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 12-25-2004, 02:48 AM   #1
deWin
Member
 
Registered: Feb 2004
Distribution: Red Hat 9
Posts: 113

Rep: Reputation: 15
mySQL installation


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.
 
Old 12-25-2004, 03:55 AM   #2
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

Rep: Reputation: 64
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
 
Old 12-25-2004, 04:13 AM   #3
deWin
Member
 
Registered: Feb 2004
Distribution: Red Hat 9
Posts: 113

Original Poster
Rep: Reputation: 15
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
 
Old 12-25-2004, 05:15 AM   #4
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

Rep: Reputation: 64
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
 
Old 12-25-2004, 05:20 AM   #5
deWin
Member
 
Registered: Feb 2004
Distribution: Red Hat 9
Posts: 113

Original Poster
Rep: Reputation: 15
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.
 
Old 12-25-2004, 05:25 AM   #6
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

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

Cool
 
Old 12-25-2004, 05:26 AM   #7
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

Rep: Reputation: 64
Should also be on any install CD's.

Cool
 
Old 12-25-2004, 05:34 AM   #8
deWin
Member
 
Registered: Feb 2004
Distribution: Red Hat 9
Posts: 113

Original Poster
Rep: Reputation: 15
installed it, installed the glibc package as well, still no go.
 
Old 12-25-2004, 06:11 AM   #9
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

Rep: Reputation: 64
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
 
Old 12-25-2004, 03:01 PM   #10
deWin
Member
 
Registered: Feb 2004
Distribution: Red Hat 9
Posts: 113

Original Poster
Rep: Reputation: 15
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql-installation: Not enough space in /var/lib/mysql/ linus123 Linux - Software 8 11-10-2006 03:19 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
Mysql installation yussef Linux - Software 1 06-13-2005 12:49 PM
MySQL 3.23.58-14 installation prolem - mysql.sock not found lightcom Linux - Software 4 02-23-2005 01:46 AM
php4 mysql, installation, php-pages with mysql info stay empty dnla Linux - Software 2 03-14-2004 03:54 PM


All times are GMT -5. The time now is 10:24 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration