Forums

Installation with two mysql accounts?

Permalink 1 user found helpful
I have a test instance setup in my company network... issue is the DBA policy requires separate accounts to work on the database for the site. Can concrete still be installed?

How can I edit the required install scripts for concrete?

Currently I keep getting the error "Unable to connect to database" with the read/write account. I can access the database via MySQL admin tools fine on port 3306.

Suggestions?
 
Mnkras replied on at Permalink Reply
Mnkras
just to clarify

you have 1 database,

2 users for that database

1 has read/write
the other has something else

you tell c5 about the read write one, yea it should work fine,
grobm replied on at Permalink Reply
Yup.

I can access the database fine via the MySQL database admin tools but it is not found by the install script for C5.

Does the database have to be localhost?
Mnkras replied on at Permalink Reply
Mnkras
no the db does not have to be localhost, i have multiple users on 1 db and it workss fine, make sure that the server isn't blocking the connection
grobm replied on at Permalink Reply
Is there away to test to see if it is blocking connections? I have checked with my DBs and all the privileges are now correct and it still is not working.

It appears to start to run the install... then after about 20-30 seconds it comes back with the error, unable to connect to database.

Suggestions?
Mnkras replied on at Permalink Reply
Mnkras
make a php file, doesn't matter about the name, and put this in it,

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');


obviously change the host user and pass