Couldn t creat new database through phpmyadmin or through php file

Discussion in 'Site & Server Administration' started by wisam74us, Mar 6, 2006.

  1. #1
    HI
    I have a dedicated server (linux freepsd) with Ensim control panel but
    Couldn t creat new database through phpmyadmin or through php file
    I should use Ensim control panel to create it
    Can I through some changes (I have root access) enble this feature
     
    wisam74us, Mar 6, 2006 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    What exactly is the error message you get when you try to do it?
     
    digitalpoint, Mar 6, 2006 IP
  3. Nintendo

    Nintendo ♬ King of da Wackos ♬

    Messages:
    12,890
    Likes Received:
    1,064
    Best Answers:
    0
    Trophy Points:
    430
    #3
    If you get

    ERROR 1006: Can't create database 'dbname'. (errno: 13)

    when creating database through phpmyadmin. Do.....

    chmod 775 /var/lib/mysql

    as root.
     
    Nintendo, Mar 6, 2006 IP
  4. wisam74us

    wisam74us Well-Known Member

    Messages:
    1,059
    Likes Received:
    47
    Best Answers:
    0
    Trophy Points:
    168
    #4
    Thanks guys .
    the error message is :
    SQL-query:

    CREATE DATABASE `ddf` ;


    MySQL said:

    #1044 - Access denied for user: 'user@localhost' to database 'ddf'
    __________________________

    User is the username I am using to login to Ensim

    I don t know if I should put the root credentials to do this
    but actually I intend to use php files to create new database and I don t want to put the root access password in php file
     
    wisam74us, Mar 6, 2006 IP