• GoDaddy Community
  • Website Design & Development
  • Website Design & Development

    cancel
    Showing results for 
    Show  only  | Search instead for 
    Did you mean: 

    MySQL User PW with PHP (using godaddy cpanel)

    GD seemed to have changed their cpanel - especially for the DB section. I cannot seem to connect to it via php

    am I missing something here?

     

    PHP

    $database = array();
    $database['host'] = 'localhost';
    $database['port'] = '3306';
    $database['user'] = 'kzzsp4tpixtd';
    $database['userpw'] = 'topsecretcode';
    $database['databasename'] = 'mycooldb';
    $database['tableprefix'] = 'uni1_';
    $salt = 'TEh4xsFVdPaObGecgjSmRo'; // 22 digits from the

     

    This gives me the following error:

    Fatal error: Uncaught PDOException: SQLSTATE[42000] [1044] Access denied for user 'kzzsp4tpixtd'@'localhost' to database 'mycooldb'

     

    Also, how do i edit the phpmyadmin config file?

    2 REPLIES 2
    Super User IV

    @klyxmaster 

     

    That all looks fine - I would double check in cPanel that your user is assigned to the database

    I am a GoDaddy End User - Just Like You
    Check out my site! | I currently manage over 300 WordPress Websites
    * Please note that I offer free advice on this forum. Thank You Info If you would like personalized help, please contact me. Otherwise, please ask your question in the proper forum so the answer can assist EVERYONE in the community and not just you. Thanks! *

    Once your issue is resolved,
    please be sure to come back and click accept for the solution

    Get Better Support on the Community Boards!
    Etiquette When Asking for Help from the Community

    @PL281 agreed, did that a million times even changed the user name and pw just for the heck of it. it see's the name change, but for some reason I keep getting that error. I works locally on my server, but when I upload it, it gets goofy. I'll double check a few things and get back you 🙂 thanks again!