Help needed in creating Database in Mysql

[Balajir]

Hi,

I am trying to create a Database in Mysql installed in RH 8. I did the following things
1. Started the mysqld service
2. create database zabbix ;

I got the error ERROR 1044: Access denied for user: '@localhost' to database 'zabbix'
Can you help me on creating the Database as a non-root user. Since i have to install an application as this particular user i need to create the database as normal user and not root.

Thanks for your time.

Rgds
Balaji R

[slant6]

Log into mysql as root and then issue the following statement,
replacing 'username' with the user's login name:

GRANT ALL ON zabbix.* TO username;

[Balajir]

Hi,

Thanks.. It worked.

Regards
Balaji R