Find the answer to your Linux question:
Results 1 to 3 of 3
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Apr 2003
    Location
    India
    Posts
    10

    Help needed in creating Database in Mysql


    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

  2. #2
    Just Joined!
    Join Date
    Nov 2002
    Location
    USA
    Posts
    99
    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;

  3. #3
    Just Joined!
    Join Date
    Apr 2003
    Location
    India
    Posts
    10
    Hi,

    Thanks.. It worked.

    Regards
    Balaji R

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •