Linux - NewbieThis 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!
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Introduction to Linux - A Hands on Guide
This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter.
For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own.
Click Here to receive this Complete Guide absolutely free.
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.
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.
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.
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 if you'd like:
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).