1. Create a database ( ej: xoops2 ):
root# mysqladmin create xoops2 (intro)
2. Verify that you have created it:
>mysql ( intro )
then you will be in line commandos of mysql
mysql>
mysql> show databases; ( ";" is very important )
3. Create a user and permissions: ( ej: kaokao

)
mysql> grant all on xoops2.* to kaokao identified by 'pw'; ( ";" is very important, pw is the password )