Saturday, August 25, 2007

Mysql config


After installing mysql on your linux box there is some configuration that you should make;

1-> Assign a password for "root" account.Give mysql that commands:

mysql> UPDATE user
-> SET password=password("newpassword")
-> WHERE user="root";

The new root passwd is now "newpassword"

2-> Create a new database and assign all options on specific user:
imagine that you need to create a new database for your holy music player amarok, and you wanna use mysql as database..

mysql> create database amarok;
mysql> create user amarokuser;
mysql> GRANT ALL PRIVILEGES ON amarok.* TO 'amarokuser'@'localhost'
>IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> flush privileges;

That's all.You can use amarok database with amarokuser in amarok application.. cool ha?

No comments:

Registred Linux User

Registred Linux User

HitCounter