Error when trying to create database

Joomla version 1.0 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
m100s2
Joomla! Apprentice
Joomla! Apprentice
Posts: 15
Joined: Tue Feb 09, 2010 3:59 pm

Error when trying to create database

Post by m100s2 » Wed Feb 10, 2010 10:53 am

I've recently inherited management of a site using an early version of php nuke and want to move significant content over, eventually to Joomla 1.5

Following the contents of post of sberla54 at http://forum.joomla.org/viewtopic.php?p ... 8#p1510948 I've installed xampp on a windows PC,then tried to install joomla 1.0.14 RC1
I get to MySQL database configuration, enter what I deem to be valid entries for the various user names and passwords etc.

When I submit them a dialog appears saying http://localhost
password and username are incorrect

This is a fresh install of xampp, after previously trialling joomla 1.5 without a problem.
(All files and directories from the 1.5 installation have been deleted)


I looked at the Joomla INSTALL.php and there are comments as follows
2. CREATE THE Joomla! DATABASE

Joomla! will currently only work with MySQL. In the following examples,
"db_user" is an example MySQL user which has the CREATE and GRANT
privileges. You will need to use the appropriate user name for your
system.

First, you must create a new database for your Joomla! site e.g.

$ mysqladmin -u db_user -p create Joomla

MySQL will prompt for the 'db_user' database password and then create
the initial database files. Next you must login and set the access
database rights e.g.
So I open a shell from xampp control panel change to the directory with mysqladmin

and enter the line as shown, it prompts for a password, I enter one and then I get the following error

mysqladmin: connect to server at '.' failed

could someone please point out where I'm going wrong?

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 28202
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: Error when trying to create database

Post by imanickam » Wed Feb 10, 2010 2:09 pm

(a) I do not know why you are using Joomla! 1.0.14 RC1. The latest version of Joomla! is 1.5.15. If it is a new development suggest using 1.5.15.

(b) Since you are using XAMPP on a local PC, there is not need to do use a command line to create a database in MySQL. Invoke phpMyAdmin and create a new database through that.

(c) Just for you to know, in XAMPP, the default user name for the database is user and there is no password for that and your host name for the database is localhost.


Review the following links to get a better understanding of Joomla! and how you can develop a website.

http://help.joomla.org/ghop/feb2008/tas ... kstart.pdf
http://docs.joomla.org/Beginners
http://docs.joomla.org/Developers
http://www.joomla.org/about-joomla/getting-started.html
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator
Former Joomla! Translations Coordination Team Lead
Eegan - Support the poor and underprivileged

m100s2
Joomla! Apprentice
Joomla! Apprentice
Posts: 15
Joined: Tue Feb 09, 2010 3:59 pm

Re: Error when trying to create database

Post by m100s2 » Wed Feb 10, 2010 4:36 pm

imanickam wrote:(a) I do not know why you are using Joomla! 1.0.14 RC1.
Because it is, as far as I can tell, the only easy migration path from php nuke TO Joomla 1.5

I've no intention of running 1.0 for any longer than necessary!

Thanks for the other tips, I'll give them a try.


Locked

Return to “Installation - 1.0.x”