Solved

Can't Install Joomla

Posted on 2012-12-20
12
316 Views
Last Modified: 2012-12-21
I'm trying to Install Joomla on my local computer, Windows 7.

I bought a book called "Joomla for Dummies".

It doesn't work.

See attached.

I installed XAMPP on my computer & set up a user / password using phpMyAdmin & a database called joomladb.

Is there some way around this?
install-error1.jpg
0
Comment
Question by:Richard Korts
  • 6
  • 5
12 Comments
 
LVL 28

Expert Comment

by:Bill Bach
ID: 38711385
Either MySQL isn't set up properly and running, or you have the wrong password.  Can you confirm that you can sign onto the MySQL database with the username of root and the password you have provided?
0
 

Author Comment

by:Richard Korts
ID: 38711426
To BillBach,

Sure, but I have no clue how to do that.

Can I do that from XAMPP? How?
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 38711439
Whew.  It's been a REALLY long time.  You can go to the XAMPP control panel, find the line for MySQL, and click "Admin".  This should launch an admin console.  Login should be the credentials you were using.  If not, then you were using the wrong credentials.  

If you don't remember the credentials, then it is time to remove XAMPP and reinstall it.  Be sure to write down each user/password as you go.
0
 

Author Comment

by:Richard Korts
ID: 38711511
Doing what you suggested takes you to phpmyadmin.

The database is there.

I am TOTALLY confused on how to configure the UserID & password; there seems to be NO WAY to do that. I set up this database in the phpmyadmin db with a users & in the user table (of phpmyadmin) set the password. That appears to be unconnected to the db in question
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 38711539
Now I see your problem.  Do NOT create the database ahead of time!  The Joomla installation will create the database with the name you provide it on this screen.  The password is asks for is for the MySQL administrative access so that it can create the database.  

Because it is possible to have multiple web sites hosted on a single server, I would recommend creating a new database with the name of the site.  For example, if you are creating a Joomla install for SiteA, call the database SiteA.  That way, if you decide to add a new site, or if you decide to redeploy with a new set of templates and want to start fresh, you can create the next database as SiteB, SiteC, and so on.
0
 

Author Comment

by:Richard Korts
ID: 38711613
To BillBach,

OK, maybe that's a step. How do I find the MySQL admin password?

When I installed XAMPP, it did everything & didn't tell me about any passwords.

FYI, the Joomla for Dummies says I have to create the databse BEFORE I install Joomla. Page 27 in case you have it. They assume GoDaddy.

Installing Joomla is one of the most difficult things I've ever tried to do & I've been doing computers, databases, etc. for a LOOOOOOOOOOOG time.

All I'm try to do now is teach myself how to use Joomla on my own computer without having to do everything on a web server.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 28

Accepted Solution

by:
Bill Bach earned 500 total points
ID: 38711626
Actually, Joomla is the EASIEST thing -- copy up the install files, then launch the web browser, and click next/next through it, providing some basic into as you go.  I literally just did a Joomla v2.5 install on Tuesday as I added a new web site to my internal server -- it is a 5-minute task to get Joomla, JSN Epic Pro, and ImageShow installed & running.

As for your MySQL Admin password, this is set at install time, if I recall. Use "root" as the username, but you need to know your password.  Try the obvious ones, like "root", "admin", and anything else you use as a default password.  I know mine (which won't be yours), and it is one that is extra secure, because it houses a lot of data for 5 different web sites.  I did find this in a quick web search:  "The default password is "mysql", and I should read the Readme.txt file. Well, somebody could have said something... "

Again, if you don't have it, try starting over from scratch.
0
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 38711729
@BillBach, this is the second time for this question.  The original problem was that the version of Joomla would not install without a password for the MySQL user and the XAMPP install does not set a password for 'root' but phpMyAdmin does use 'root' without a password.  The sequence of setting a password for 'root' and getting phpMyAdmin to come back failed on @rkorts previous try and I wasn't able to walk him thru getting it to work.
0
 

Author Comment

by:Richard Korts
ID: 38713496
To BillBach,

OK, I've tried the following:

(1) went into mysql.ini & found a line called password = xxx commented out. I put in the password I wanted to use & uncommented it, saved the file.

(2) Made sure the database joomladb did NOT exist.

(3) Went through the Joomla install. It fails (as it always does) on step 4. See attached.

(4) I tried 3 with both "root" & "admin" as user. Same result.

(5) In looking at the text on the right, it is not clear if the database needs to have been created BEFORE or AFTER the Joomla install.

(5) Created a database in MySQL called joomladb.

(6) Tried it again; exact same result (as attached).

Any ideas?
install-error2.jpg
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 38713766
Did you restart MySQL (or the entire server) after you changed the INI file?  Honestly, I don't recall what I did to set this up originally.  I did my first XAMPP/Joomla 1.x install by following the directions provided.  I do seem to recall that there was a separate step for securing the database, now that you mention it, but I am not sure what that was.  A quick inquiry to Professor Google provided several useful hits, like this one:
    http://www.devshed.com/c/a/Administration/Install-XAMPP-on-Windows/1/

On my own server, I did find a batch file in the E:\xampp\mysql directory called resetroot.bat, which purports to reset the root password.  Not sure if that works until AFTER you go through the other steps, but both may be viable options for you.
0
 

Author Comment

by:Richard Korts
ID: 38713842
To All,

I found the solution. It is:

(1) Create a new mySQL database to use for joomla (I called it joomladb).

(2) Use "root" as the user name.

(3) Leave the password blank. This is apparently the key.

Doing this, it goes right through, I now have it installed.

Thanks,

rkorts
0
 

Author Closing Comment

by:Richard Korts
ID: 38713849
The points are awarded for EFFORT. Solution found using another method; I had to pay,
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Welcome Friends, This is the tutorial for how to create new simple module in joomla 1.5. In the module has two important files. One is XML file and another file is PHP controller file. First you need to create the XML file. (CODE) …
What you will need: Any version of Photoshop or similar product (examples in Photoshop) Internet Access FTP Access to your joomla install or ability to upload images within joomla administrator backend Create Image: Lets start off with cre…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now