Setting up a database in MYSQL

  • hgruber
  • Beginner
  • Beginner
  • User avatar
  • Posts: 58
  • Loc: Vero Beach Florida

Post 3+ Months Ago

I didn't see anything in the forum which contained the mySQL item
So, I hope this location is okay for the question.

I want to know where mySQL is located in the directory structure on my linux box.
I would like to set up an account user name and password for a database.

Can anyone help me with this?

Thanx,

haans :)
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • webmasterbrain
  • Beginner
  • Beginner
  • webmasterbrain
  • Posts: 51

Post 3+ Months Ago

Try this (from your shell):
Code: [ Select ]
which mysql

This works for anything, for example you could also do:
Code: [ Select ]
which perl

and that would tell you the location of perl
  • hgruber
  • Beginner
  • Beginner
  • User avatar
  • Posts: 58
  • Loc: Vero Beach Florida

Post 3+ Months Ago

Here is the return on those two commands:

/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/usr/games:/home/haans/bin)

/usr/bin/perl

I was reading about installation:

because there is the new option of using MySQL to store your Movable Type database, I wrote up a short tutorial for how to get MySQL ready for the conversion. This is particularly for people who are using CPanel (I’m using version 4) as their control panel on their server.

Get into your CPanel. (usually by going to http://yourdomain.com/cpanel)

Click Manage MySQL (from Databases box at the bottom of the screen) Scroll down to where it says
Db: _____________ [add]

I entered “mt” (without the quotes). This created me a database called love_mt - yours will add your username onto the front of mt.
Click Add.

Now scroll down to where it says Users.
I entered “username” and a password. This created me a user called love_username.
Click Add User.

Now scroll back up to where it has two drop down boxes with a button that says [Add User to Db]
Drop down the select boxes to select your database and username - mine shows love_mt and love_username.
Click Add User to Db.

Now your MySQL database is set up and ready to use for MT.
You should download your mt.cfg from your mt directory (see step 9 of upgrading instructions) and here’s what my additional lines look like:


ObjectDriver DBI::mysql
Database love_mt
DBUser love_username

You’ll also edit the mt-db-pass.cgi file and put ONLY your password in it - you don’t need the words database_password in the file. (I did that wrong the first few times in the beta and couldn’t figure out why it didn’t work.

However I tried to run the cpanel and I am guessing it is not installed.
The GUI to control the mySQL database?
Just another guess.

Any help?

Thanx,

haans :)
  • webmasterbrain
  • Beginner
  • Beginner
  • webmasterbrain
  • Posts: 51

Post 3+ Months Ago

hgruber wrote:
Here is the return on those two commands:

/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/usr/games:/home/haans/bin)



Our you sure that is the complete output from 'which mysql'?

I'm guessing the complete output was something like this:

Quote:
/usr/bin/which: no mysql in (/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/usr/games:/home/haans/bin)


In which case MYSQL is not installed
  • hgruber
  • Beginner
  • Beginner
  • User avatar
  • Posts: 58
  • Loc: Vero Beach Florida

Post 3+ Months Ago

This output was exactly what I copied and pasted from the CLI.

code: /usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/usr/games:/home/haans/bin

There was nothing more.

thanx,

haans
  • webmasterbrain
  • Beginner
  • Beginner
  • webmasterbrain
  • Posts: 51

Post 3+ Months Ago

Sorry to be patronizing, but are you absolutely sure? The reason I ask, is because of the closing bracket:
Quote:
/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/usr/games:/home/haans/bin)

That would explain that being there.
  • hgruber
  • Beginner
  • Beginner
  • User avatar
  • Posts: 58
  • Loc: Vero Beach Florida

Post 3+ Months Ago

I have always learned when you are asking for someone's help.
They are not patronizing you.
They are questioning you because they are puzzled by your response, which can usually be attributed to the fact you are the novice.

I am going over to the server location to install mySQL in a few minutes.

I will run the command(s) from the CLI again.

I SSH'd into my box last night, I was tired.
Therefore, I cannot guarantee anything.
But, today I will make certain of it and respond once I have the correct details.

I am also wondering if I should wait to do all this since next weekend I am changing the HD and upgrading (clean install) Mandrake 10. It almost seems a shame to do all this work to only have to redo it in a week.
But, I am the kind of person who is anxious to learn this. So, doing it twice would only serve to make me learn it more thoroughly.

see you in a few minutes.

haans 8)
  • webmasterbrain
  • Beginner
  • Beginner
  • webmasterbrain
  • Posts: 51

Post 3+ Months Ago

Also; 'whereis mysql' will give you some more information
  • hgruber
  • Beginner
  • Beginner
  • User avatar
  • Posts: 58
  • Loc: Vero Beach Florida

Post 3+ Months Ago

Okay I have mySQL installed and have verified it is running.
When I attempt to install phpBB2 it says :
The php configuration on your server doesn't support the database type that you chose.

any help?
  • hgruber
  • Beginner
  • Beginner
  • User avatar
  • Posts: 58
  • Loc: Vero Beach Florida

Post 3+ Months Ago

Okay I have mySQL installed and have verified it is running.

version mySQL 3.23.58

When I attempt to install phpBB2 error :
The PHP configuration on your server doesn't support the database type that you chose.

any help?

haans
  • Carnix
  • Guru
  • Guru
  • User avatar
  • Posts: 1098

Post 3+ Months Ago

Try installing the current stable release version: 4.0.20

http://dev.mysql.com/downloads/mysql/4.0.html

.c

Post Information

  • Total Posts in this topic: 11 posts
  • Users browsing this forum: No registered users and 158 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.