Installing MySQL

[trixter]

I have already successfully installed the apache webserve and php using the command shown in Shallax's tutorial.

emerge apache mod_php php

Now I want to install MySQL. Is there any trick to doing this or can I just do an:

emerge mysql

to get it? Thanks.

[nobspangle]

Emerge mysql will work fine then run
rc-update add mysql default && /etc/init.d/mysql start

I think you may have to do something else to install the default database but if that is the case there will be a message somewhere.

[xstaci]

at least with the pc gentoo running the Init script the first time should isntall those tables, otherwise i think a "find * / | grep "mysql*install*" should list something like mysql_install_tables,

remember u gotta be root!

[kennelbound]

Immediately after the emerge type the following:

Code: Select all

/usr/bin/mysql_install_db

This adds the default database.

[nobspangle]

you can just type mysql_install_db as /usr/bin is in your path

[Trogdor]

If it doesn't work, BE SURE TO RUN THE INSTALLATION SCRIPT that it gives you during the emerge.

[tamz273]

ok i followed wat u guys told us to do, i ran the mysql_install_db
it setup the tables for me and then asked to change the root password, i tried to but i kept getting errors :S

and shouldnt there be some sort of GUI to setup all the rest of the tables and that stuff???

[tamz273]

and wenever i try to do any admin commands, i get an error stating:
mysqladmin: connecto to server at 'localhost' failed
error: 'Acess denied for user: 'root@localhost' (using password:NO)

any1 help?

[nobspangle]

you need to add the -p switch to the mysqladmin and mysql commands to make it prompt you for a password. Like this

Code: Select all

mysql -p 

or

Code: Select all

mysqladmin -p

Then enter your mysql root password and you are away.

I don't know about a gui client I always make dump files and create tables that way.

The mysql website is the best place for info, the manual is very detailed and explains everything you need to know

[tamz273]

i did it for the mysql and it was fine, but wen i tried for the mysqladmin, i got a list of commands i can use with it, and wen i try any of them, i end up with the same error, localhost bla bla bla


help?

[nobspangle]

as long as you use the -p flag it should work e.g if you want to create a database called newdb the command would be

Code: Select all

mysqladmin create newdb

You need to add a -p flag and maybe also -u and -h

Code: Select all

mysqladmin -u root -h localhost create newdb -p

you should then be prompted for the root@localhost password

If you can't get this to work forget about using mysqladmin and just use the mysql client which can do all the same stuff

[tamz273]

ok thx!!
it prompted a password, i entered it, and it created it i believe, but now, what are the username and password of THAT table when iw anna install a phpBB board or sumthing??

[nobspangle]

You need to do some reading on the mysql site.
What you have created is a database (not a table) tables exist inside databases. A mysql server can host several databases all with several tables.
You can just use the root username and password or you can create new users using the GRANT command.

[Trogdor]

Since MySQL is a relational database, you have >=1 table per db. Like this:

Code: Select all

+===============================+
| ------- A Database -----------|
+===============================+
|----+=====================+----|
|----| A table ------------|----|
|----+=====================+----|
|-------------------------------|
|----+=====================+----|
|----| Another Table ------|----|
|----+=====================+----|
|-------------------------------|
+===============================+

[tamz273]

i read all of the chapters for setting up a table, yet i dunno what the table for a forum or phpnuke or a gallery should contain...

it duznt specify about forums... so wat can i do?

is there a step-by-step guide of how to setup tables that work with phpBB, phpnuke, and/or gallery4???