LinuxQuestions.org
Visit Jeremy's Blog.
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 03-12-2003, 12:39 PM   #1
brandog
LQ Newbie
 
Registered: Mar 2003
Location: Winnipeg
Distribution: RedHat 8.0
Posts: 28

Rep: Reputation: 15
How do you setup a mysql database


hello everybody! I have installed linux redhat 8.0 and plan on using it as a server only! I have installed all the 3 disks and I do have access to mysql from the terminal. What I want to do is set up a mysql database, 1) a database name
2) a database username
3) a database password

I will be using the database only for the phpBB2 forum that I will be setting up!

What is the first step to take followed by the rest! I have seen many posts about this subject and none of them are clear at all! REMEMBER you are talking to somebody who doesent know every term you maybe talking about so please try to explain in a little more detail if you can. ( ) Hopefully this will turn out to be a good help topic for beginners!

The floor is now yours!
 
Old 03-12-2003, 02:06 PM   #2
brandog
LQ Newbie
 
Registered: Mar 2003
Location: Winnipeg
Distribution: RedHat 8.0
Posts: 28

Original Poster
Rep: Reputation: 15
Dont tell me nobody here doesent know the full steps!
 
Old 03-12-2003, 02:46 PM   #3
jglen490
Member
 
Registered: Apr 2002
Location: The next brick house on the right.
Distribution: Kubuntu 8.04
Posts: 668

Rep: Reputation: 31
Which thread would like answered, the one here or the identical one in General .
 
Old 03-12-2003, 03:33 PM   #4
brandog
LQ Newbie
 
Registered: Mar 2003
Location: Winnipeg
Distribution: RedHat 8.0
Posts: 28

Original Poster
Rep: Reputation: 15
I wasent sure where to put it, but this one would be good!
 
Old 03-12-2003, 08:54 PM   #5
brandog
LQ Newbie
 
Registered: Mar 2003
Location: Winnipeg
Distribution: RedHat 8.0
Posts: 28

Original Poster
Rep: Reputation: 15
OK, I am up to the tables part. I have created a database of:

FORUMDB

now when I create the tables in that database (FORUMDB) I created 3 fields (user)-(password)-(host) I set the user name, password and the hostname. I tried to 'FLUSH PRIVILEGES' but it came back as Query ok, 0 rows affected. What do I do to get them flushed properly?
 
Old 03-13-2003, 06:41 AM   #6
Burke
Member
 
Registered: Dec 2002
Location: Virginia, USA
Distribution: Fedora Core 3
Posts: 131

Rep: Reputation: 15
I haven't played with phpBB in a while ( I prefer using Postnuke/Envolution with a Forum module )... but, according to the quick install, it looks like the db and tables all get created automatically when you go through the web-based install.
phpBB2/docs/INSTALL.html

-- Oh yeah, the 0 rows affected -- that's normal for flushing. Basically, you're just reloading the permissions that are set in the db.. no rows get changed during flushing.... I think...

Last edited by Burke; 03-13-2003 at 06:42 AM.
 
Old 03-13-2003, 08:13 AM   #7
brandog
LQ Newbie
 
Registered: Mar 2003
Location: Winnipeg
Distribution: RedHat 8.0
Posts: 28

Original Poster
Rep: Reputation: 15
I thought I needed to create the tables to have access to a password and username! If PhpBB2 installs the tables for me how would I set a password for the FORUMDB so I can enter the info into the selected feilds that is called for in the setup of phpBB2? ie: database, database username and database password!
 
Old 03-13-2003, 09:01 AM   #8
Burke
Member
 
Registered: Dec 2002
Location: Virginia, USA
Distribution: Fedora Core 3
Posts: 131

Rep: Reputation: 15
Ah, yes.. A lot of these web applications assume username 'root' with no password by default .. Obviously, press enter after each of the example commands after customizing each to your environment.

Here's what you need to do:
1. Login to mysql as root:
"mysql --user=root mysql"

2. Create the database you plan to store phpBB2 data in:
create database phpBB2;

3. Now, in this next step you are granting a username with a specific password full access to the specified database:
GRANT ALL ON phpBB2.* TO phpBB2User@localhost IDENTIFIED BY 'phpBB2password';

4. Step 3 created the username, password, and specified how much access to have to the phpBB2 database.
flush privileges;

5. chmod 666 config.php in your phpBB2 directory.

6. Open web browser to http://yourhost/phpBB2/install/install.php

7. Fill out form according to the database, username, password you have selected.. etc...
 
Old 03-13-2003, 10:20 AM   #9
brandog
LQ Newbie
 
Registered: Mar 2003
Location: Winnipeg
Distribution: RedHat 8.0
Posts: 28

Original Poster
Rep: Reputation: 15
I will try this as soon as I get home. I think I get the idea! I will post my progress in 3 hours
 
Old 03-13-2003, 02:02 PM   #10
brandog
LQ Newbie
 
Registered: Mar 2003
Location: Winnipeg
Distribution: RedHat 8.0
Posts: 28

Original Poster
Rep: Reputation: 15
That did it! I got it up and working without any headaches at all! Thank you, now this is how you show somebody the proper detailed way to do it! I spent 2 whole days trying to figure this out with other posts!

SOLVED!!!!!
 
Old 03-13-2003, 02:04 PM   #11
Burke
Member
 
Registered: Dec 2002
Location: Virginia, USA
Distribution: Fedora Core 3
Posts: 131

Rep: Reputation: 15
Glad to be of assistance
 
Old 03-22-2003, 11:03 AM   #12
dkc_ace
Member
 
Registered: Dec 2002
Distribution: freeBSD 4.9/6.0
Posts: 194

Rep: Reputation: 30
Quote:
Originally posted by Burke
Ah, yes.. A lot of these web applications assume username 'root' with no password by default .. Obviously, press enter after each of the example commands after customizing each to your environment.

Here's what you need to do:
1. Login to mysql as root:
"mysql --user=root mysql"

2. Create the database you plan to store phpBB2 data in:
create database phpBB2;

3. Now, in this next step you are granting a username with a specific password full access to the specified database:
GRANT ALL ON phpBB2.* TO phpBB2User@localhost IDENTIFIED BY 'phpBB2password';

4. Step 3 created the username, password, and specified how much access to have to the phpBB2 database.
flush privileges;

5. chmod 666 config.php in your phpBB2 directory.

6. Open web browser to http://yourhost/phpBB2/install/install.php

7. Fill out form according to the database, username, password you have selected.. etc...
well sense u know so much about it i am still having trouble. it gives me this error:
An error has occurred during installation
An error occurred trying to update the database

Could not insert board_startdate :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_startdate', 1048353209) :: 871 :: /hdb1/hdb1/web/aland/install/install.php

Could not insert default_lang :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_lang', 'english') :: 878 :: /hdb1/hdb1/web/aland/install/install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = 'dkc_ace@hotmail.com' WHERE config_name = 'board_email' :: 895 :: /hdb1/hdb1/web/aland/install/install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = '/aland/' WHERE config_name = 'script_path' :: 895 :: /hdb1/hdb1/web/aland/install/install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = '80' WHERE config_name = 'server_port' :: 895 :: /hdb1/hdb1/web/aland/install/install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = 'dkc1.dnsq.org' WHERE config_name = 'server_name' :: 895 :: /hdb1/hdb1/web/aland/install/install.php

Could not update admin info :: UPDATE phpbb_users SET username = 'ace', user_password='5118ac3b916381e2fc9c6c9c122e322d', user_lang = 'english', user_email='dkc_ace@hotmail.com' WHERE username = 'Admin' :: 906 :: /hdb1/hdb1/web/aland/install/install.php

Could not update user_regdate :: UPDATE phpbb_users SET user_regdate = 1048353209 :: 913 :: /hdb1/hdb1/web/aland/install/install.php
 
Old 03-23-2003, 07:20 PM   #13
Burke
Member
 
Registered: Dec 2002
Location: Virginia, USA
Distribution: Fedora Core 3
Posts: 131

Rep: Reputation: 15
Hmmm... Have you confirmed that the tables have been made?
Use the command prompt, webmin, or phpMyAdmin to take a look at your phpBB2 database. Make sure that all the tables exist. That's really all that comes to mind right now..

You may want to check their support forums to get more experienced help with this. As I mentioned above, I don't even use phpBB
 
Old 03-24-2003, 02:08 PM   #14
dkc_ace
Member
 
Registered: Dec 2002
Distribution: freeBSD 4.9/6.0
Posts: 194

Rep: Reputation: 30
Quote:
Originally posted by Burke
Hmmm... Have you confirmed that the tables have been made?
Use the command prompt, webmin, or phpMyAdmin to take a look at your phpBB2 database. Make sure that all the tables exist. That's really all that comes to mind right now..

You may want to check their support forums to get more experienced help with this. As I mentioned above, I don't even use phpBB

i checked and no tables where made in the database.

I have been trying to figure out this problem for the past 2 days and no luck. I have posted several times on there forums and no one knows how to fix it. well the people that have been posting dont know how to fix it. there are like 3 or 4 people on that forum right now trying to figure out the SAME EXACT problem i am having but none of us have gotten any good help. im about to say screw phpBB and find another one. i do understand that im not the best with mysql or databases or anything but it would be nice to recive some help or some type of lead to figure out the problem.
 
Old 03-24-2003, 02:28 PM   #15
Burke
Member
 
Registered: Dec 2002
Location: Virginia, USA
Distribution: Fedora Core 3
Posts: 131

Rep: Reputation: 15
No tables, huh... Okay, looks like your username & password are not working for mysql.. You'll need to test that from the command prompt..
I just went through these steps on my Mandrake 9.0 workstation:

assuming the following:
phpBB2 database name = 'phpBB2'
phpBB2 username = 'phpBB2User'
phpBB2User password = 'password'

Now, type the following:
mysql --user=phpBB2User --password=password

Does this let you into MySQL?
If so, type "use phpBB2" to switch to the database.

If it lets you switch to phpBB2 database, then try creating a table:
create table test_table (test_id mediumint(8) default '0' not null);

Did it let you create one or were you even able to get this far?.. Maybe not.. You may need to try Granting the user id it's permissions (Did you forget to do this?)..

For example (using the assumption placed above):

GRANT ALL ON phpBB2.* TO phpBB2User@localhost IDENTIFIED BY 'password';

Should return "Query OK, 0 rows affected"

Now, try the previous steps again. If you are able to create the test table, then "drop test_table;" to get rid of it and try your phpBB2 install again.

From what you've described, it just looks like the user you're trying to use doesn't have the permission to create the database/tables or you're not using the right password.
Good Luck, I hope this helped.
 
  


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
mythtv mysql database setup help carmat06 Debian 3 09-27-2005 05:41 PM
Writing an app that uses a mysql database without installing mysql server? QtCoder Programming 4 08-09-2004 02:43 PM
MYSQL help - mysql database missing eloviyandhi Linux - Software 1 03-20-2004 09:20 PM
Mysql database from cd JHuizingh Linux - Software 0 02-22-2003 02:08 PM
mysql database huno Linux - General 8 02-11-2003 08:15 PM


All times are GMT -5. The time now is 08:11 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration