Setting up Drupal 5(rc1) with Xampp and/or Apache2Triad.. access problem
I usually ran my testing through test sections on my live domain, but I've been digging more and would like to try my hand at porting some themes or working more with themes and I've been wanting more and more to setup a localhost server because it's just easier then uploading/downloading and refreshing.
Well, I downloaded Xampp 1.5.5(zip version) last night and I also just got Apache2Triad 1.4.4 like 20 minutes ago. The problem being I don't know these programs that well and have read the websites doc some on setup and installation but it's still so new and confusing.
I setup Xampp first and got everything installed and running and localhost showed the Xampp page. I put some files and drupal 5 rc1 into /htdocs and pointed to there. The database config page showed up after a bit. I punched in a descrip, user/password, kept it at localhost and one time I tried the port 3306 as its the MySQL port.
It ran about a minute then came back:
"Failure to connect to your MySQL database server. MySQL reports the following message: Access denied for user: 'drup@localhost' (Using password: YES).
* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct database hostname?
* Are you sure that the database server is running?
For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider."
I tried a few different times, I tried getting into phpMyAdmin to manually setup a database and couldn't because login was wrong or something. I read "root" has no password so I just tried root. Nothing.
I setup Apache2Triad because someone said its a bit easier to use and I still get the same error when trying to install the database.
I've bookmarked the Blackmountain Xampp pages and the Apache2Triad tutorial in the forum.
I haven't seen any in-depth laymans term tutorial on setting up this stuff because it looks to me you have to edit a *.conf file, set the root password, give *all permissions* to the first user and some other stuff.
http://drupal.org/node/75537 and also http://drupal.org/node/39745
I've looked at those but those don't address the current issue I'm having.
Any thoughts or advice is greatly appreciated. Thanks.
I have never used Xampp
I have never used Xampp pages or Apache2Triad but let's see where we can get with it.
Since you will need to us PHPMyAdmin before anything else anyway to create the database, we need to get you in there. Unfortunately, login was wrong or something is not specific enough to tell what went wrong.
One thing, if you will be using root with no password, the proper error would be
(Using password: NO)
You can't enter a password in the install screen. But that will come later, after you get into PHPMyAdmin and create the database. :)
I installed 5.0rc1 in XAMPP
I installed 5.0rc1 in XAMPP without any trouble. You should have already changed the default MySQL password, so at the settings.php file, you should complete "root" at username and the corresponding password.
--
Duplika | Web Hosting
Want to explain?
"I installed 5.0rc1 in XAMPP without any trouble. You should have already changed the default MySQL password, so at the settings.php file, you should complete "root" at username and the corresponding password."
I don't mean to be n00b, but do you care to explain a bit more what you mean?
Like what does "You should have already changed the default MySQL password, so at the settings.php file, you should complete "root" at username and the corresponding password" mean?
I unzipped, ran setup_xampp.bat(or whatever), got the ok. I then went to mysql dir and ran the install service thing. Went back to xampp_control, opened and installed all services and ran them. All came up with the "running" next to them. At which point I opened firefox punched in "localhost" and the Xampp localhost came up. Went to status(going off memory here out), everything showed up fine. Went to status, systems running.
Two things here. I could goto the CD thing on the main localhost page and it would give an error, "can't connect to mysql(or php) server, are you sure your running it?" Said something like that. I could also goto phpMyAdmin, get the login screen, put "root" as user, no pw(as I understand thats what the login is) and can't get inside.
I don't quite understand how to go about creating a new phpmyadmin login because its a command line and have to edit a file?
What all did you do to get yours up and running? How many files did you have to edit or was it more "out of the box" install after changing root? Also, did you create the database inside MyAdmin before installing drupal or did you go about it normal and let the script run itself?
Thanks for any help.
What I remember from my own
What I remember from my own XAMPP installation is that when the MySQL Config panel came up I just left it empty and closed it. Then, after starting Apache, MySQL and the FTP server, I opened phpmyadmin as "root" and no password and created the database (Drupal 5 can't create the database. It can only set up the tables in it).
Ok.
Well, I was HOPING to use Xampp because it seems to have a better interface, but I went and read http://drupal.org/node/81988 (the tutorial for setting up Drupal with Apache2Triad). I skimmed it and followed it as I set it up.
What I did wrong(at least for Drupal5) was I didn't make the database inside MyAdmin, then I thought you just made up a user/password when you actually use your root & password for root.
For Drupal 4.7 you also edit the settings.php under the $db_url = 'mysql://root:password@localhost/drupal-4.7.3' and $base_url = 'http://localhost/drupal-4.7.3'; // NO trailing slash! lines to appropriate stuff for your local settings.
I guess I'd still like to know for sure how to go about setting up a root & password for Xampp. I've deleted it all but am wondering if thats good enough to reinstall and have all the default settings back? I know the zip version is different for uninstalling then the exe version.
Anyone know how to create a new root & password for Xampp or have a link to somewhere that does?
Local Install of Xampp & Drupal
Roque_77 said:
I'm using Xampp 1.6.4, when you have Xampp's welcome page in your browser click 'Security' in the left nav menu. Xampp will display your security status. Approximately half way down the page your should see
=> http://localhost/security/xamppsecurity.php <= [allowed only for localhost]
Click the link and a page opens which allows you to set a password for MYSQL and XAMPP. After Xampp's passwords are set, return to Xampp's welcome page.
Before installing Drupal you need to create an empty database with user name and password. You can use phpMyAdmin in Xampp to easily create the database. Click on 'phpMyAdmin' in the Xampp left nav menu. You will be asked for the user name and password you just created for Xampp. Once phpMyAdmin opens you can create a database. Write down the database name and password as you will need them during the Drupal install. Once this database is successfully created you can continue with the Drupal install.
HTH,
Doug