Computer Forums - Setting up mysql on my home server

Computer Forums (http://www.geekboards.com/forums/index.php)

- Building Websites (http://www.geekboards.com/forums/forumdisplay.php?f=3)

- - Setting up mysql on my home server (http://www.geekboards.com/forums/showthread.php?t=800)

Setting up mysql on my home server

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

I believe this is it.
First update yum

Quote:

yum update

then try mysql-server-5.0

Quote:

yum install mysql-server-5.0

if that does not work use

Quote:

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

Quote:

~$ mysql -u root mysql

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

Quote:

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

you should see

Code:

Query OK, 2 rows affected (0.00 sec)

rows matched: 2 Changed: 2 warnings: 0

Then since its new do

Quote:

mysql>DELETE FROM user WHERE user = '';

Code:

mysql>FLUSH PRIVILEGES;

Quote:

mysql>DROP DATABASE test;

Quote:

mysql>exit

Thank you got it working whoo

Nathan

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.

Wow you did that before i got to finish.. :cool:

I never activated yum - lol

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

Thank you for your help, much appreciated. :)

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