CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.1 Release Testing »
  • beta 3 cannot connect to mysql
Pages: [1]

Author Topic: beta 3 cannot connect to mysql  (Read 2772 times)

Inc

  • Guest
beta 3 cannot connect to mysql
September 08, 2008, 09:47:04 pm
so I'm using beta 3 and for some reason my installation will not allow me to connect. I know my database settings are 100% correct they worked on my old civicrm install and are just now not working on the latest version 2.1 beta 3. Could be be because my database has an underscore under the database? let me know thanks.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: beta 3 cannot connect to mysql
September 08, 2008, 09:51:40 pm
i don't think anything is changed in beta3 with regard to database connection settings. Can you paste error message here.

Kurund
Found this reply helpful? Support CiviCRM

Inc

  • Guest
Re: beta 3 cannot connect to mysql
September 08, 2008, 09:56:30 pm
No error message, just
Are the access credentials correct   That username/password doesn't work: Access denied for user 'inc'@'localhost' (using password: YES)
Can I access/create the database   I can't create new databases and the database 'inc_calimesafd_com' doesn't exist (user 'inc' doesn't have CREATE DATABASE permissions.)
Can I access/create InnoDB tables in the database   Unable to create InnoDB tables. MySQL InnoDB support is required for CiviCRM but is either not available or not enabled in this MySQL database server. Could not determine if mysql has innodb support. Assuming no
Drupal Database Details
Does the server exist   OK (localhost)
Are the access credentials correct   That username/password doesn't work: Access denied for user 'inc'@'localhost' (using password: YES)
Can I access/create the database   The database does not exist
but I know all that stuff is legit.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: beta 3 cannot connect to mysql
September 08, 2008, 10:19:59 pm
Quote
I can't create new databases and the database 'inc_calimesafd_com' doesn't exist (user 'inc' doesn't have CREATE DATABASE permissions.)

Can you confirm that "inc" user has privilege to "create datatbase"?

Kurund

Found this reply helpful? Support CiviCRM

Inc

  • Guest
Re: beta 3 cannot connect to mysql
September 08, 2008, 10:25:16 pm
no, user inc does not have the ability to create a database, however the database does exist....

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: beta 3 cannot connect to mysql
September 08, 2008, 10:51:15 pm
"Inc" user need to have all permission for database that you created.

For eg:
Quote
GRANT ALL PRIVILEGES ON `inc_calimesafd_com` . * TO 'inc'@'localhost' WITH GRANT OPTION ;

HTH

Kurund
Found this reply helpful? Support CiviCRM
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.1 Release Testing »
  • beta 3 cannot connect to mysql

This forum was archived on 2017-11-26.