Allright, I am going to presume that you can install an RPM, .deb, or build a tarball. If that is an issue, we have other problems than MySQL.
Allright, you just got it installed. Now we must make it usable. Note any distro, should have this done already. MY RH* install didnt need this step. In fact I could skip to starting the daemon.
Now the book I have wants to make all of the stuff in a mysql group. Its up to you, I personally think its a great idea.
And to start the server, use either RedHats service control (if you grabbed an RH RPM) or whatever method you like, or this command (as listed in my book)
useradd -g mysql mysql
chown -R root /usr/local/mysql
chgrp -R mysql /usr/local/mysql
chown -R mysql /usr/local/mysql/data
Okay. Cool beans we got it setup. Now we need to test thast you can connect to the DB, and manipulate data. Just like all good little databases should.
/usr/local/mysql/bin/safe_mysqld --user=mysql &
Lets connect. When it asks for a password, hit enter. All MySQL users are unique from the host. So root, bob, fuzzy, and fred in your unix box, are not the same as a root, bob, fuzzy, and fred in the MySQL DB. As of now, root is the only account, and has a null password.
You should have a few databases by default installed, and a will display them. Note the semicolon at the end. It matters ;D
Lets make a table and some data and retrieve it. The following should make sense, so I am not going to go apeshit getting inot detail.
Allright, we created a DB called "ljr".
create database ljr;
create table table1 (data1 int);
insert into table1 (data1) values (1);
insert into table1 (data1) values (2);
insert into table1 (data1) values (3);
insert into table1 (data1) values (4);
insert into table1 (data1) values (5);
select data1 from table1 where data1 > 0;
We switched to it.
Created a table
Queried the data (in a really haphazrd way, but simple enuf).
Now to delete the crap we created
drop table table1;
drop database ljr;
Inserted some data
Any questions ;D