By druz99 on

Hey all, I am totally new to drupal but am willing to put in the effort to learn whatever is needed. Hope someone can help me get started:

I have downloaded drupal-5.1 and dropped the folder into the public_html directory of my webhost. I now need to create a database. I am using MAMP PRO, and can't seem to figure out how to get past this step! When I start MAMP PRO, it seems to connect to localhost. Am I correct in assuming that I need to somehow connect to my domain name instead?

Any advice will be greatly appreciated. Thanks!

Comments

fusion94’s picture

fusion94 commented

The issue here is how you're using drupal in conjunction with MAMP and/or MAMP Pro. MAMP/MAMP Pro are commercial, professional grade versions of the classic local server environment for OS X. i.e. it was designed to provide a local manageable installation of Mysql/Apache/PHP.

The key on this is local manageable installation.

The proper way to use MAMP and Drupal is to install Drupal into the MAMP htdocs directory which by default should be /Applications/MAMP/htdocs/ Then start up MAMP. Once MAMP is running you can connect to it via http://localhost:8888/MAMP/?language=English You can then use phpMyAdmin to create a new database to use with Drupal. Once the database is created make sure you edit the $db_url setting located in /Applications/MAMP/htdocs/sites/default/settings.php. Once you've set that properly all you need to do is connect to http://localhost:8888/install.php and Drupal will install/base configure itself.

If in fact you are trying to install Drupal on a remote host and are using MAMP Pro to configure a database on a remote host then you should look for another tool to use other than MAMP Pro as it was designed for the sole purpose of providing for a local server environment.

druz99’s picture

druz99 commented

fusion94, thanks very much for clarification. I would actually like to install drupal on my domain, and NOT do preliminary work on my local machine, so I was wrong to use MAMP from the start.

I have connected to www.xyz.com (hypothetical) via FTP and placed the drupal-5.1 directory in the public_html folder. I'm now stuck, as I am not quite sure how to create the databse required for the drupal installation. Any help would be greatly appreciated.

Thanks!

fusion94’s picture

fusion94 commented

druz99,
I'd check with support at your web hosting provider as they should be able to assist you in setting up and configuring a mysql database. As long as they provide mysql as an option that is. Not knowing who your provider is or what package you've purchased and what tools they provide will make it difficult for anyone in the Drupal forums to assist you properly.

Trust me, your web hosting provider should be able to provide you with the best support in regards to this issue.

druz99’s picture

druz99 commented

fusion94,

I know how to activate the mysql database on my web host, but it's using their internal portal. I'd like to learn how to use some web-standard tools such as myPhpAdmin to create the database, etc. What do you use?

fusion94’s picture

fusion94 commented

druz99,
I typically shell into whatever server I'm dealing with and from the terminal I logon to mysql using:

myql -u root -p

which then prompts me for password. I then use 'create database databasename;' to create the database.

Alternatively you can use 'mysqladmin create databasename'

druz99’s picture

druz99 commented

fusion94,

Could you teach me how to do this? Assuming that the site is www.xyz.com, and I know that mySQL is supported. I then access terminal on my mac, and type:

"mysql -u username -p -h www.xzy.com" ?

Please advise.

brettfromtibet’s picture

brettfromtibet commented

the first steps are the hardest steps, Druz99...

I'm just a couple of days ahead of you at this, but if you keep at it, this whole world of new acronyms and OS gets clearer....

I don't know how to work with MySQL from the shell... but keep digging and be patient and... we shall find our way!

brettfromtibet’s picture

brettfromtibet commented

the first steps are the hardest steps, Druz99...

I'm just a couple of days ahead of you at this, but if you keep at it, this whole world of new acronyms and OS gets clearer....

I don't know how to work with MySQL from the shell... but keep digging and be patient and... we shall find our way!

druz99’s picture

druz99 commented

brettfromtibet, no kidding! I've been fiddling for a few hours and still can't seem to install this properly, but it's alright...I guess this is all part of the learning process! Luckily, there are many people here willing to help - hopefully one day once we become proficient we can give back to the community just as they are.

I've managed to launch the installer but get the following error:

"We were able to connect to the MySQL database server (which means your username and password are valid) but not able to select your database. MySQL reports the following message: Access denied for user 'user1'@'localhost' to database 'names'."

Despite the fact that I *have* created a database called "names," I still have this error (I created it using my web hosts control panel).

Frustrations! Any tips?

tandonian’s picture

tandonian commented

I have been battling with a problem connecting to my database for a few weeks now
http://drupal.org/node/113369
I' getting this error

The MySQL error was: Access denied for user 'Nexusadmin'@'localhost' (using password: YES).

and I am using MAMP. I put the drupal files into my webserver sites folder, but it sounds like I should put them in the /Applications/MAMP/htdocs/ ? What if I don't use MAMP, and just use PHPmyadmin?
I am doing a local installation. any further thoughts would be hugely appreciated!

jfbelisle89’s picture

jfbelisle89 commented

create your database with phpmyadmin first! And then in Drupal use the name of your neewly creted database and as username use root...

LisaKCreative’s picture

LisaKCreative commented

I seem to be having the same problem with drupal connecting to my database that I've created using MAMP. What exactly should I edit in the db_url? I named my database db1. Thank you!

mcampasano’s picture

mcampasano commented

I set up my database with MAMP with all the information suggested. I created a database and user name. after i log in the page refreshed and I am stuck on the set up database portion of the drupal setup. The only warning I get is to change the 8m to 16m in the php. Am I missing something?

Thanks in advance,
Mike

ShortCurl’s picture

ShortCurl commented

Mike.

Having the exact same issue. I did manage to change my php to 16M. I attempt to setup the DB and when I hit submit the page simply refreshes! If you get anywhere with this would you post here? I'll do the same.

~Stina

astridman’s picture

astridman commented

Was having the same problem. Solution is here (the fact that it was a problem in the first place is REDONKYOOLUS):

you need to copy AND THEN rename the default.settings.php file...wtf?
http://drupal.org/node/384700