Access denied when trying to create my joomla dtb

Joomla version 1.5 is end-of-life and are no longer supported. Please use Joomla 3.x instead.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
Shouryuu
Joomla! Apprentice
Joomla! Apprentice
Posts: 38
Joined: Thu Jul 17, 2008 5:28 am

Access denied when trying to create my joomla dtb

Post by Shouryuu » Fri Oct 24, 2008 3:43 pm

I guess that this problem comes from my side, but when I try to install Joomla!, I get the following error when detailing my database information:
Access denied for user: 'XXX' to database 'YYY SQL=CREATE DATABASE `YYY`

I guess that this is an admin problem, but how would I solve it? My dtb is on 1&1.

User avatar
CptDecker
Joomla! Ace
Joomla! Ace
Posts: 1047
Joined: Mon Feb 27, 2006 3:00 am
Location: New York
Contact:

Re: Access denied when trying to create my joomla dtb

Post by CptDecker » Fri Oct 24, 2008 10:22 pm

Did you first verify that you have created the database and that your user name and password are correct?

Can you see the database in your webhosts admin panel or via phpMyAdmin?
CptDecker

Total Hosting -- Professional Joomla Web Hosting
http://www.totalhosting.com/Web-Hosting/Joomla.html

Shouryuu
Joomla! Apprentice
Joomla! Apprentice
Posts: 38
Joined: Thu Jul 17, 2008 5:28 am

Re: Access denied when trying to create my joomla dtb

Post by Shouryuu » Fri Oct 24, 2008 10:41 pm

Yup absolutely certain that it's there.

Should I go and try a manual instalation instead of a web one?

User avatar
CptDecker
Joomla! Ace
Joomla! Ace
Posts: 1047
Joined: Mon Feb 27, 2006 3:00 am
Location: New York
Contact:

Re: Access denied when trying to create my joomla dtb

Post by CptDecker » Sat Oct 25, 2008 1:52 am

It sure is worth a try :laugh:
CptDecker

Total Hosting -- Professional Joomla Web Hosting
http://www.totalhosting.com/Web-Hosting/Joomla.html

Shouryuu
Joomla! Apprentice
Joomla! Apprentice
Posts: 38
Joined: Thu Jul 17, 2008 5:28 am

Re: Access denied when trying to create my joomla dtb

Post by Shouryuu » Mon Oct 27, 2008 10:46 pm

Hummm I get an error but I can't seem to duplicate the one I have on a web based install... I simply get a "Could not connect to mysql database error".

I want to check I'm getting everything right:
Database name ====> var $db
Username ====> var $user
Password ====> var $password
Server name ====> var $host
Version = Mysql 4.0 ====> var $dbtype = 'mysql';

And I should leave:
var $dbprefix = 'jos_';

Is this right?

Shouryuu
Joomla! Apprentice
Joomla! Apprentice
Posts: 38
Joined: Thu Jul 17, 2008 5:28 am

Re: Access denied when trying to create my joomla dtb

Post by Shouryuu » Tue Oct 28, 2008 1:08 am

Pfffiiiou managed at last! Thanks a lot mate!

umbrella666
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Fri Jan 16, 2009 7:46 pm

Re: Access denied when trying to create my joomla dtb

Post by umbrella666 » Fri Jan 16, 2009 9:50 pm

Hi,
I have a problem that I have tried various fixes for:

Access denied for user 'xxxxx'@'localhost' to database 'xxxxxxx' SQL=CREATE DATABASE `xxxxxxxx` CHARACTER SET `utf8`

sorry about the xxs if that is not protocol, I saw it elsewhere. Basically I renamed the configuration file to remove the 'dist', created my mysql database, did add the user manually, did make sure the permissions were set correctly at I think 0777. All my local I.T guy could do was ask me to try the web browser installation rather than from my host. I have tried extracting the joomla files several times after I get the access denied message. If someone could point me in the right direction that would be great. I have tried several of the forum fixes for this problem but maybe I have missed one?

Please note I solved this problem but worth noting here that a very small discrepancy in the details you input at the mysql stage of installation will prevent you from getting any further. Mine was one letter that had accidentally been recorded as upper case when creating the database. When I corrected this at the mysql installation stage it was fine.
Last edited by umbrella666 on Sat Jan 17, 2009 11:56 am, edited 1 time in total.

umbrella666
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Fri Jan 16, 2009 7:46 pm

Re: Access denied when trying to create my joomla dtb

Post by umbrella666 » Fri Jan 16, 2009 9:51 pm

sorry I intended to say I have the 'same' problem...just to specify that it is the exact same access denied code. Problem solved now...read above.

hoangthinhnd
Joomla! Apprentice
Joomla! Apprentice
Posts: 24
Joined: Sun Aug 15, 2010 5:22 pm

Re: Access denied when trying to create my joomla dtb

Post by hoangthinhnd » Mon Jul 15, 2013 3:39 am

I try fix my database --> uf8 unicode but "An error occurred while trying to create the database"


Locked

Return to “Installation 1.5”