Setting up mysql on my home server

[Nathan]

Hi all,

Im new to server setup and i was just wondering how i setup mysql on my server - im using centos.

I have setup apache httpd.conf to recognise my network and i have also got ssh working (which a friend done for me).

Reason being is that i would like it for developing my websites and a few other uni projects that i have.

Any help would be greatly appreciated

Nathan

[Chris]

I believe this is it.
First update yum

yum update

then try mysql-server-5.0

yum install mysql-server-5.0

if that does not work use

yum search mysql-server

thats should give you a list of packages that match mysql-server, mysql 5.0 is what i use.

I do not use CentOS But i have so i know a little. Mysql is the same on all OS's

~$ mysql -u root mysql

then
since it will be a new install you will need to do this first.
add password to root account

mysql> UPDATE user SET password=PASSWORD('desired_password')
->WHERE User='root';

you should see

Query OK, 2 rows affected (0.00 sec)
rows matched: 2 Changed: 2 warnings: 0

Then since its new do

mysql>DELETE FROM user WHERE user = '';

mysql>FLUSH PRIVILEGES;

mysql>DROP DATABASE test;

mysql>exit

[Nathan]

Thank you got it working whoo

Nathan

[Chris]

Paste a copy of you yum.conf file here lets have a look at it.

location: /etc/yum.conf

I am not a 100% sure if yum is even installed on the core system...

I am actually a Debian person myself that plays with all Linux distros and prefer Debian.

[Chris]

Wow you did that before i got to finish..

[Nathan]

I never activated yum - lol

went into the setup, activated it, started the daemon, done.

Thank you for your help, much appreciated.

[Chris]

Your welcome for any help i gave. If you have further questions stop by again..