Getting access to the mysql database.

[Mike55]

Hi all

I am just after installing the Sugar CRM software, so far it looks quite interesting. The only problem that I can see is that there is no support for the Euro currency. So I was hoping to access to the database and manually add the currency. The set-up file installed mysql in the folder: C;/programfiles/sugarcrm/mysql; using the command prompt, I navigated to that location, however I am unable to gain access to the database, what command should I be using...If I use mysql, I get a message saying that access denied, if I use mysql -h host -u user -p and then enter my password, I get an invalid user error.

Any suggestions

Michael.

[Mike55]

Problem solved. Found the option for local system settings.

Michael.

[Mike55]

I would still like to be able to access to mysql database, can anyone point me to where I can get more information on accessing the database, and the username password combination I should be using. I know the combination for phpMyAdmin, however I am unable to access the php interface.

Michael.

[pblag]

HI Mike!

I think that you have to look in file config.php in sugarCRM root directory.

there is section
'dbconfig' =>
array (
'db_host_name' => 'localhost',
'db_host_instance' => '',
'db_user_name' => 'root',
'db_password' => '',
'db_name' => 'paul',
'db_type' => 'mysql',
),

hope it will be interested for you

[roblaus]

Re. accessing phpmyadmin: Depends on where you installed it. Let's assume you installed it underneath your current web directory (e.g. home/web/phpmyadmin) and your server address is www.example.com then it would be www.example.com/phpmyadmin.
But: it's case sensitive and normally written as phpMyAdmin

rgds
rl