title: SQLSTATE[HY000] [1045] Access denied for user 'root'@'127.0.0.1' (using password: NO) SYMFONY2
body: <p>So I'be been working on a symfony2 project and it was all good, then i wanted to host it on godaddy but now I get this error. I don't understand it neither do I know how to fix it. thanks so much.</p>
  
  <blockquote>
    <p>SQLSTATE[HY000] [1045] Access denied for user 'root'@'127.0.0.1' (using password: NO)</p>
  </blockquote>
  
  <p>This is my <strong>paramaters.yml</strong> file</p>
  
  <pre><code># This file is auto-generated during the composer install
  parameters:
      database_driver: pdo_mysql
      database_host: 127.0.0.1
      database_port: null
      database_name: symfony
      database_user: root
      database_password: 
      mailer_transport: smtp
      mailer_host: 127.0.0.1
      mailer_user: null
      mailer_password: null
      locale: en
      secret: 14bcde878eda1c3f56a59b62b13e820b7f94563d
  </code></pre>
  
  <p>This is my <strong>config.yml</strong> file </p>
  
  <pre><code>imports:
      - { resource: parameters.yml }
      - { resource: security.yml }
  
  framework:
      #esi:             ~
      #translator:      { fallback: "%locale%" }
      translator: ~
      secret:          "%secret%"
      router:
          resource: "%kernel.root_dir%/config/routing.yml"
          strict_requirements: ~
      form:            ~
      csrf_protection: ~
      validation:      { enable_annotations: true }
      templating:
          engines: ['twig']
          #assets_version: SomeVersionScheme
      default_locale:  "%locale%"
      trusted_hosts:   ~
      trusted_proxies: ~
      session:
          # handler_id set to null will use default session handler from php.ini
          handler_id:  ~
      fragments:       ~
      http_method_override: true
  
  # Twig Configuration
  twig:
      debug:            "%kernel.debug%"
      strict_variables: "%kernel.debug%"
  
  # Assetic Configuration
  assetic:
      debug:          "%kernel.debug%"
      use_controller: false
      bundles:        [ ]
      #java: /usr/bin/java
      filters:
          cssrewrite: ~
          #closure:
          #    jar: "%kernel.root_dir%/Resources/java/compiler.jar"
          #yui_css:
          #    jar: "%kernel.root_dir%/Resources/java/yuicompressor-2.4.7.jar"
  
  # Doctrine Configuration
  doctrine:
      dbal:
          driver:   "%database_driver%"
          host:     "%database_host%"
          port:     "%database_port%"
          dbname:   "%database_name%"
          user:     "%database_user%"
          password: "%database_password%"
          charset:  UTF8
          # if using pdo_sqlite as your database driver, add the path in parameters.yml
          # e.g. database_path: "%kernel.root_dir%/data/data.db3"
          # path:     "%database_path%"
  
      orm:
          auto_generate_proxy_classes: "%kernel.debug%"
          auto_mapping: true
  
  # Swiftmailer Configuration
  swiftmailer:
      transport: "%mailer_transport%"
      host:      "%mailer_host%"
      username:  "%mailer_user%"
      password:  "%mailer_password%"
      spool:     { type: memory }
  
  fos_user:
      db_driver: orm # other valid values are 'mongodb', 'couchdb' and 'propel'
      firewall_name: main
      user_class: CurrencyConverter\ConverterBundle\Entity\User1
  sensio_framework_extra:
      view:
          annotations: false
  fos_rest:
      param_fetcher_listener: true
      body_listener: true
      format_listener: true
      view:
          view_response_listener: 'force'
  </code></pre>
  
  <p>I got the password and username now I get:</p>
  
  <blockquote>
    <p>SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known</p>
  </blockquote>