Joomla and MySQL

[jtaah]

I am trying to set up joomla and i am on th mysql part but it keeps telling me this

Unable to connect to the database:Could not connect to MySQL

this is a copy of the settings i am trying to use

Basic Settings

Database Type
Select Type mysql mysqli This is probably MySQL Host Name
This is usually localhost or a host name provided by the hoster User Name
This can be the default MySQL username root or a username provided by the hoster, or one that you have created whilst setting up your database server. Password
For site security using a password for the MySQL account is mandatory. This is the same password used to access your database. This may again be preset by your hoster. Database Name
Some hosts allow only a certain DB name per account. If this is the case use the table prefix option in the following Advanced Parameters section to distinguish more than one Joomla! site.


Advanced Settings

Drop Existing Tables Backup Old Tables Any existing backup tables from former Joomla! installations will be replaced Table Prefix
Do not use 'bak_' since this is used for backup tables


rgds
jtaah

 

[orthiac]

First you need to verify your database name and user. This is most often where the trouble lies.

when you create a database (or user) the system will prepend your username and "_" to the beginning.
jtaah_database jtaah_user

Database Type: mysql
Hostname: localhost

Where this information is actually sent with the CRM information whenever the site is used, you should not use the default account user but should create a NEW user and assign all privileges to your Joomla database.

Hope that helps.

 

[jtaah]

i am not locally hosting it joomla i am using x10 to host

 

[orthiac]

So am I http://orthiac.x10hosting.com
and "localhost" is really local to YOUR x10 host. (it's a sql thing) :biggrin:

 

[Aero~]

Hmm... you've gotton that far? maybe if you could help me get where you are I could help you... when I am installing Joomla it tells me:

Joomla

The installation can not be completed:

- You chose to install in the main directory of the domain psstation.x10hosting.com, but there are conflicting filenames, therefore we can not proceed. Following filenames already exist in the main directory of the domain psstation.x10hosting.com (path="/home/aero/public_html/").You must manually remove these files before proceeding with auto-installation:
robots.txt

Click on the browser's Back button to fix reported errors.

any help?

 

[jtaah]

Aero try installing it into a folder called joomla thats what i did and it worked for me.

rgds
jtaah

 

[orthiac]

Aero try installing it into a folder called joomla thats what i did and it worked for me.

rgds
jtaah

That will work well if you already have a site going and will be linking to the Joomla site.
If Joomla will be the main page, then you should see about moving the existing files to a subdirectory.

Edit: jtaah - did you resolve your issue with connecting to the database with installer?

 

[Aero~]

Now that I have done that this what I end up with...

Fatal error: SUHOSIN - Use of eval is forbidden by configuration

any help?
Edit:
Like my signature and avatar

 

[jtaah]

yes aero i like them both its a shame i am not that artistic what site address are you typing to get there

rgds
jtaah

 

[orthiac]

If you log into your account manager at x10hosting.com, are you running at a minimum the "Intermediate PHP Configuration" (V2) ?
Are you running this through Fantastico or are you running this manually from a download at Joomla.org (which ver?)

 

[jtaah]

its ok all I finally got it to work but thank you all any way for your help

rgds
jtaah

 

[mikeyp]

How did you get it to work?

I have the same connection problem
Thanks
Mike