FRIHOST • FORUMS • SEARCH • FAQ • TOS • BLOGS • DIRECTORY
You are invited to Log in or Register a Frihost Account!

Database error during install of drupal

   Frihost Forum Index -> Scripting -> Website Software
 


inphurno
I was not able to use a table for testing on the mysql database i set up. I tried using a table with the command LOCK TABLES drupal_install_test WRITE and mysql reported the following error: Access denied for user 'inphurno_testing'@'localhost' to database 'inphurno_testing'.

This is the error that I get when I tried to run an install of the tables in the mysql database. I made the user and the database today so I don't know how long this takes to activate. I have the mysql host set as localhost and I have a table prefix set up as inphurno. I don't know if this is ok or if there are other setting to add, also I have not set up a database port.
rvec
you shouldn't put anything in the database, drupal should fill the database itself (or like you did use a prefix other than what the other tables have).

Quote:
I don't know how long this takes to activate

Shouldn't take a second.

If you get an access denied error, you have something wrong in your database settings.
inphurno
rvec wrote:
you shouldn't put anything in the database, drupal should fill the database itself (or like you did use a prefix other than what the other tables have).

Quote:
I don't know how long this takes to activate

Shouldn't take a second.

If you get an access denied error, you have something wrong in your database settings.


ok thats good to know i'm on the right track rvec Smile so what do you think i should change in my settings then?
rvec
well I think either the database doesn't exist, or the user/password combination wasn't right. There is also a possibility that the user doesn't have rights to access the database, but if you set up a database in directadmin the normal way that shouldn't be possible.
inphurno
rvec wrote:
well I think either the database doesn't exist, or the user/password combination wasn't right. There is also a possibility that the user doesn't have rights to access the database, but if you set up a database in directadmin the normal way that shouldn't be possible.


ok thanks for the heads up rvec I'm not sure what i did wrong exactly amongst those things but i guess i can try to just delete everything and start from scratch... its easier like that Smile so I'll give that a try and let you know
inphurno
inphurno wrote:
rvec wrote:
well I think either the database doesn't exist, or the user/password combination wasn't right. There is also a possibility that the user doesn't have rights to access the database, but if you set up a database in directadmin the normal way that shouldn't be possible.


ok thanks for the heads up rvec I'm not sure what i did wrong exactly amongst those things but i guess i can try to just delete everything and start from scratch... its easier like that Smile so I'll give that a try and let you know


I'm trying to get Drupal set up for one of my domains but I get this message when trying to connect:

"If you still have to install Drupal, proceed to the installation page."

I've uploaded the files, created the mySQL, and modified the 'settings.php' file with the correct info but when I go to view the website, i get the following:

'unable to select database'

what does that mean? is that a privileges problem?

I also have this: "If you have already finished installing Drupal, this either means that the username and password information in your settings.php file is incorrect or that we can't connect to the MySQL database server. This could mean your hosting provider's database server is down. The MySQL error was: Too many connections."
rvec
Quote:
modified the 'settings.php' file

It's easier to just follow the installation wizard Wink

Quote:
unable to select database

Maybe you mistyped the database name or user/password?

Quote:
The MySQL error was: Too many connections.

This is a temporary error on the server side, it should go away in a couple of seconds or minutes most of the time.
Related topics

Database Error: Unable to connect to the database HELP
Install Drupal 5.1?
Database error on my Blog
Database Error: Unable to connect to the database:Could not
Database Error and Internal Server Error
Critical Database Error (Or something else)
setting up a drupal 6.2 site
How do we install Invision Board manually through cpanel?
Mysql error!
setting up a drupal 5.7 site
URGENT: Please help - site down due to database error
Joomla! won't install
Help with Drupal and Fantastico
[RESOLVED] php-nuke error?
An Example to mySQL class
Reply to topic    Frihost Forum Index -> Scripting -> Website Software

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2007 Frihost, forums powered by phpBB.