Installing mysql on Fedora 13

Installing mysql Fedora 13 - Goddard

change user to root su -
yum install mysql
yum install mysql-server
yum install mysql-devel

after installation.. files will be available on /var/lib/mysql
and user group called mysql will be created.. change the group ownership and permissions

chgrp -R mysql /var/lib/mysql/
chmod -R 770 /var/lib/mysql/

the next step is not necessary.. add the service in desired runlevel

chkconfig | grep mysqld
chkconfig mysqld on

start the service service mysqld start

set the passwords. (note single quote is important)

mysqladmin -u root password 'new-password'
mysqladmin -u root -h hostname password 'new-password'

login to mysql mysql -u root -p

show databases;

use mysql;

show tables;

describe user;

select user, password, host from user;

update user set password = '******' where user = 'root' and host = '127.0.0.1';