The Joomla! Forum ™

Download

Demo


Board index » Joomla! Older Version Support » Joomla! 1.5 » Installation 1.5

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.



Post new topic Reply to topic  Page 1 of 1
  [ 22 posts ] 
  Print view Previous topic | Next topic 
Author Message
ihjanjua
PostPosted: Fri Feb 25, 2011 7:19 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Feb 25, 2011 7:09 am
Posts: 8
hi,
this is my first time using the joomla and I am using WAMP Server 2.1 to run joomla in locally.
while installing joomla when i get to the Database Configuration screen and insert the required information it doesn't accept the following information which is pretty generic

Database type: MySQL
Host name: Localhost
user name: root
Database Name: Joomla
Table_Prefix: jos_

and gives me the following error

Could not connect to the database. Connector returned number: Unable to connect to the Database: Could not connect to MySQL.

can some one help me with this. i kow it is pretty basic but I am stuck with this.
Top
 Profile  
 
cogito
PostPosted: Sat Feb 26, 2011 6:02 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Feb 26, 2011 5:27 am
Posts: 10
Im having the same prblem! I am using XAMPP fo my localhost. When I left the password field empty I got a screen saying: You have an error in your SQL syntax;.....and so on.

If I use a password I get an error as the first poster!
Top
 Profile  
 
srijeet
PostPosted: Sat Feb 26, 2011 8:04 am 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Tue Nov 11, 2008 10:20 am
Posts: 142
Location: India
If you are running it in your local server i.e XAMPP then the password should remain blank ! Please see that you are not adding a password keep blank

_________________
Cell: 91-9974381442
Email: inquiry@miesterdisplay.com
Skype :miester.display
URL: www.miesterdisplay.com
Top
 Profile  
 
cogito
PostPosted: Sat Feb 26, 2011 9:53 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Feb 26, 2011 5:27 am
Posts: 10
Thanks sriject
Even with the blank password I still got error, saying that there is error in SQL syntax!
I guess there is modification to be made somewhere, but I dont know where or how!
Top
 Profile  
 
srijeet
PostPosted: Sat Feb 26, 2011 3:33 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Tue Nov 11, 2008 10:20 am
Posts: 142
Location: India
"Localhost" keep it as "localhost" keep "L" as lower case and check ! And yes please manually write all the credentials such as dbname , username , hostname , Try not to copy paste it , check now and tell me ?

_________________
Cell: 91-9974381442
Email: inquiry@miesterdisplay.com
Skype :miester.display
URL: www.miesterdisplay.com
Top
 Profile  
 
cogito
PostPosted: Sat Feb 26, 2011 4:49 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Feb 26, 2011 5:27 am
Posts: 10
All inputs were done in lower case! Yet prblm pasist.
Top
 Profile  
 
srijeet
PostPosted: Sat Feb 26, 2011 4:59 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Tue Nov 11, 2008 10:20 am
Posts: 142
Location: India
Have you created a database called "Joomla" in localhost/phpmyadmin/ ?

_________________
Cell: 91-9974381442
Email: inquiry@miesterdisplay.com
Skype :miester.display
URL: www.miesterdisplay.com
Top
 Profile  
 
dpacadmin
PostPosted: Sat Feb 26, 2011 5:02 pm 
User avatar
Joomla! Champion
Joomla! Champion

Joined: Sat Aug 16, 2008 1:46 pm
Posts: 5164
Location: the Bat Cave
You don't say what your connection error says but maybe this will help;
http://forum.joomla.org/viewtopic.php?p=2422354#p2422354
Top
 Profile  
 
cogito
PostPosted: Sat Feb 26, 2011 5:14 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Feb 26, 2011 5:27 am
Posts: 10
No srijeet, I have not! Please could u walk me through this, I hope u dont mind?
Top
 Profile  
 
cogito
PostPosted: Sat Feb 26, 2011 5:37 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Feb 26, 2011 5:27 am
Posts: 10
I just created the 'joomla' database in the phpMyAdmin of the localhost. When I tried to test it, I still got the same error saying:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM CHARACTER SET `utf8`' at line 29...

And it went on and on!
Top
 Profile  
 
cogito
PostPosted: Sat Feb 26, 2011 7:12 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Feb 26, 2011 5:27 am
Posts: 10
Thanks dpacadmin! I folowed the instruction on that forum, I changed all TYPE to ENGINE in 'joomla.sql' and the error message disapeared. Thanks a lot.
Top
 Profile  
 
cogito
PostPosted: Sat Feb 26, 2011 9:31 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Feb 26, 2011 5:27 am
Posts: 10
Well as I said, the database issue was resolved! But following the Quick Start instruction manual, I deleted the 'installation' folder and I tried to create a site, but on clicking next I got a screen full of error lines, instead of a blank screen, according to the manual! One of the error lines read:
Strict Standards: Non-static method JLoader::import() should not be called statically in C:\xampp\htdocs\joomla15\libraries\joomla\import.php on line 29
Top
 Profile  
 
dpacadmin
PostPosted: Sun Feb 27, 2011 4:23 pm 
User avatar
Joomla! Champion
Joomla! Champion

Joined: Sat Aug 16, 2008 1:46 pm
Posts: 5164
Location: the Bat Cave
You need to edit your php.ini file and then restart Apache;
http://forum.joomla.org/viewtopic.php?p=2412671#p2412671
Also set Display_errors to off in the php.ini file.
Top
 Profile  
 
ihjanjua
PostPosted: Mon Feb 28, 2011 5:04 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Feb 25, 2011 7:09 am
Posts: 8
i logged in localhost/phpmyadmin and gave root password to mysql and joomla started working properly. now i can login to localhost/administrator and can access the back end of my website.

now the problem is that i can't access localhost/phpmyadmin. it says:

Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

It doesn't prompt me for password to login. I checked "php.ini" file but couldn't find where i need to make changes in order to access the phpmyadmin page.
Top
 Profile  
 
ihjanjua
PostPosted: Mon Feb 28, 2011 8:23 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Feb 25, 2011 7:09 am
Posts: 8
System's OS is Windows XP.

WAMPSERVER version 2
Top
 Profile  
 
cogito
PostPosted: Mon Feb 28, 2011 9:52 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Feb 26, 2011 5:27 am
Posts: 10
Thanks dpacadmin and everyother person, everything is now working beautifuly fine. I can now start exploring. Thanks again!
Top
 Profile  
 
reebo
PostPosted: Mon Feb 28, 2011 10:04 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Thu Oct 21, 2010 12:58 am
Posts: 27
ihjanjua wrote:
i logged in localhost/phpmyadmin and gave root password to mysql and joomla started working properly. now i can login to localhost/administrator and can access the back end of my website.

now the problem is that i can't access localhost/phpmyadmin. it says:

Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

It doesn't prompt me for password to login. I checked "php.ini" file but couldn't find where i need to make changes in order to access the phpmyadmin page.


"i logged in localhost/phpmyadmin and gave root password to mysql and joomla started working properly"

You said you had given a password for mysql in phpmyadmin. Then you have to use that password. If you use password, then you will never get the message - "#1045 - Access denied for user 'root'@'localhost' (using password: NO)".

You don't need to edit the php.ini file for this problem.

Thanks.
Top
 Profile  
 
ihjanjua
PostPosted: Mon Feb 28, 2011 10:14 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Feb 25, 2011 7:09 am
Posts: 8
but it doesn't prompt me for the password.
when i enter the localhost/phpmyadmin it simply gives me the error without prompting me for the password
Top
 Profile  
 
reebo
PostPosted: Mon Feb 28, 2011 11:06 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Thu Oct 21, 2010 12:58 am
Posts: 27
ihjanjua wrote:
but it doesn't prompt me for the password.
when i enter the localhost/phpmyadmin it simply gives me the error without prompting me for the password


You can solve this problem in command prompt. PM me for futher details or get me on skype for further help.

Thanks.
Top
 Profile  
 
wilsonroy983
PostPosted: Mon Feb 28, 2011 11:21 am 
I've been banned!

Joined: Mon Feb 28, 2011 11:17 am
Posts: 4
I just created the 'joomla' database in the phpMyAdmin of the localhost. When I tried to test it, I still got the same error saying:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM CHARACTER SET `utf8`' at line 29...

And it went on and on!
Top
 Profile  
 
dpacadmin
PostPosted: Mon Feb 28, 2011 11:58 am 
User avatar
Joomla! Champion
Joomla! Champion

Joined: Sat Aug 16, 2008 1:46 pm
Posts: 5164
Location: the Bat Cave
http://forum.joomla.org/viewtopic.php?p=2422354#p2422354
Top
 Profile  
 
josazee
PostPosted: Fri Sep 14, 2012 8:48 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Jan 12, 2010 12:29 pm
Posts: 9
If you are having problem connecting to phpmyadmin due to change of password follow this procedure:

use mysql console found in wamp tray icon, then change password for root or leave it blank.

mysql> SET PASSWORD FOR ‘root’@'localhost’=PASSWORD(’new_password’);
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 22 posts ] 


Board index » Joomla! Older Version Support » Joomla! 1.5 » Installation 1.5

Who is online

Users browsing this forum: No registered users and 11 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group