By kosherjellyfish on

I'm new to CMS and mySQL, having never worked with anything other than static webpages.

I've followed instructions in the documentations in the installation chapter, and have uploaded Drupal's files into my web server via a free FTP software.

Now, I'm not too sure when it comes to installation of the database - mySQL database. I'm not too sure whether one's supposed to download and install mySQL on one's local machine, or have to upload it into my server space.

Anyone can give me specific, step-by-step details on which version of mySQL to download (perhaps point to the site's URL), and how do I continue with installation?

⋅ Categories: Drupal 4.7.x

Comments

huw’s picture

huw commented

Certainly MySQL 4.1 is stable. Version 5 has just been released but I have had stability issues on windows and I don't know if drupal is 5 compatible yet.

Download at: http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.16-win32.zip/from...

Huw.org.uk

Geary’s picture

Geary commented

Drupal is a program with certain requirements, such as PHP and MySQL. Those programs need to be available on the machine where Drupal runs. They do not need to be available on machines that Drupal is *not* running on.

Are you going to run Drupal on your Windows machine, or on a web server? It sounds like you will run it on a server. That being the case, there is no special software you need to install on your Windows machine, because Drupal is not running on your machine.

Your server probably has MySQL already. Do you have shell access? Type "mysql --version" (without the quotes) at the shell prompt to find out if you have MySQL and what version it is.

Geary’s picture

Geary commented

In my reply above, I meant that you should type "mysql --version" at the shell prompt of your web server, not a command prompt on your local XP machine.

Also, BTW, it can be useful to install and run Drupal on your local machine for testing. If you do want to do that, the easiest way by far is to use XAMPP, which installs Apache, PHP, MySQL, and various other goodies all ready to run. Search this site for XAMPP to see some examples and tips. (Disregard this if you just want to get Drupal running on your web server.)

kosherjellyfish’s picture

kosherjellyfish commented

Heya, thanks for the recommendation of XAMPP - I supposed testing will be needed when it comes to development of my webspace.

I'll still need to run mySQL on my webserver though. Have looked through the folders of my server through FTP and I couldn't see any database folder except the one which belongs to drupal.

Which version of mySQL do I download for server, and how do I go about installing it?

heine’s picture

heine commented

I'm not aware of the exact hosting situation your in, but usually MySQL is offered by the hoster, sometimes in 'premium' packages. Most do not allow installation by website owners. So, you may want to contact your hosting company, unless you're the owner/admin of a dedicated server..

Do you have CPanel/Plesk to administer your sites? If you do, search for phpmyadmin or mysql databases.

--
Tips for posting to the forums

kosherjellyfish’s picture

kosherjellyfish commented

Ohh. Thanks for the information.

My webhost's http://www.carbonblock.net (somebody else registered it for me), and there are mentions about the hosting plan coming with unlimited mySQL server.

Now, anyone know how to use shell prompt? I tried connecting to my webserver via MS DOS but I don't know what exactly to type in. Was taught by a pal but didn't recall how to.

bonobo’s picture

bonobo commented

and, a good client to use is putty

http://www.chiark.greenend.org.uk/~sgtatham/putty/

This client will give you command line access to your server.

However, from a quick look at this page from your web host, you will probably be able to do everything you need through the Plesk 7.5 control panel -- Plesk gives you a graphical front end that should let you do all of what you need to do -- including create MySQL databases, etc.

Hope this helps.

Cheers,

bonobo

-------
http://www.funnymonkey.com
Tools for Teachers

-------
http://www.funnymonkey.com

kosherjellyfish’s picture

kosherjellyfish commented

Yes, thanks very much! Plesk has allowed me to install a database easily. Now, the problem is I don't quite understand this particular instruction given in Drupal's installation tips (http://drupal.org/node/260), and I don't know how to load the drupal database scheme as SQL commands in Plesk.

I have already uploaded all drupal's files into my server's htmldocs directory, including the folder "database" that includes the database scheme.

Anyone who've used Plesk before when configuring Drupal and the database can give any advice on this?

heine’s picture

heine commented

One of my sites is configured via plesk. Don't like it very much...

Go to databases and click on the name of your database. Now you should see a heading TOOLS and a heading USERS. Just below tools you can see the DB WebAdmin icon (picture is a blue stack with a monkey wrench). Click it. This opens a popup (!) with PHPMyAdmin.

In the left pane of phpmyadmin you'll see a small icon (windowlike) with SQL in it. Click it, select the tab 'import files'. Here you can upload the sql file with the database scheme.

Good luck.
--
Tips for posting to the forums

kosherjellyfish’s picture

kosherjellyfish commented

Plesk was driving me nuts by the end of the day, thus I tried downloading PuTTY. (cute name)

The weird thing is, the window closes after I enter my password. So I don't know how to carry on with using PuTTY. Any suggestions to that?

kosherjellyfish’s picture

kosherjellyfish commented

I'm lost. Thanks for the recommendation of Plesk, but I've been pretty confused so far.

Following the instructions of Drupal Installation (http://drupal.org/node/260), I have trouble with creating a database using Plesk, since the instruction's command-lines.

Starting with the instruction:

First, you must create a new database for your Drupal site
(here, 'drupal' is the name of the new database):
mysqladmin -u dba_user -p create drupal

And instead of doing this, I used Plesk's functions and created a database called drupal. I added a database user called jiayuan and set my password there as well. (jiayuan's my name)

Next step:

MySQL will prompt for the 'dba_user' database password and then create the initial database files. Next you must login and set the access database rights:
mysql -u dba_user -p

I accessed myPHPAdmin for this. I used the SQLQuery for this - typed in mysql -u jiayuan -p but there seems to be an error. They mentioned about a syntax error. This doesn't allow me to carry on setting priviledges rights to the database then. The question is: is there a difference between the 'database user' created in plesk, and the database user in mySQL?

Because the following instruction got me puzzled:

Again, you will be asked for the 'dba_user' database password.

At the MySQL prompt, enter following command:

GRANT ALL PRIVILEGES ON drupal.*TO nobody@localhost IDENTIFIED BY 'password';

where

'drupal' is the name of your database
'nobody@localhost' is the username of your webserver MySQL account' password' is the password required to log in as the MySQL user

Because in phpAdmin, it says that I'm jiayuan@localhost. Have I created a username for my webserver MySQL instead of a database user for drupal?
If that's the case, how do we create a database user via phpMyAdmin? Or is there a better way to do this instead of using phpMyAdmin or Plesk?

I heard only the installation part for Drupal's slightly difficult. I hope this would be a smoothier journey for noobs like myself.

kosherjellyfish’s picture

kosherjellyfish commented

Is there anyone that can help me here? It's kind of urgent!

sepeck’s picture

sepeck commented

Note, I have never used plesk but if it;s a GUI interface then these cPanel instructions may help you some

http://drupal.org/node/25310

-sp
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide

heine’s picture

heine commented

One of my sites is configured via plesk. Don't like it very much...

Using PLESK, go to databases and click on the name of your database. Now you should see a heading TOOLS and a heading USERS. Just below tools you can see the DB WebAdmin icon (picture is a blue stack with a monkey wrench). Click it. This opens a popup (!) with PHPMyAdmin (disable pop-up blocking).

You already set a username (jiayuan@localhost) in Plesk. A note about setting privileges; it can be disabled, try anyway.

First make sure the relevant database is selected in phpmyadmin. If you have only one database, it is usually selected. If necessary however click 'Databases' in the phpmyadmin start screen and then the database name.

In the left pane of phpmyadmin you'll see a small icon (windowlike) with the word SQL in it. Click it, select the tab 'import files'. Here you can give the command GRANT ALL PRIVILEGES ON drupal.* TO jiayuan@localhost IDENTIFIED BY 'password';
Here you can upload the sql file with the database scheme.

If you went to your database with the Databases->dbname route, an SQL tab where you can upload a file is also available.

Good luck.
--
Tips for posting to the forums

kosherjellyfish’s picture

kosherjellyfish commented

Oh no. I keep having the recurring error message that says "SQL query:

GRANT ALL PRIVILEGES ON drupal . * TO drupal_user@localhostIDENTIFIED BY 'mypassword'

Error Message...
#1044 - Access denied for user: 'drupal_user@localhost' to database 'drupal'

heine’s picture

heine commented

You already set a username (jiayuan@localhost) in Plesk. A note about setting privileges; it can be disabled, try anyway.

You did fill in the correct values, right? Apparantly you can't GRANT and you need to trust the priviliges given to your user by Plesk. Just continue the installation...

--
Tips for posting to the forums

bonobo’s picture

bonobo commented

will be completed through Plesk.

From step 2 of install.txt:

mysqladmin -u dba_user -p create drupal

a. This step creates the db you will use, and you have created this db using the Plesk GUI.

mysql -u dba_user -p

b. This step creates a user for the database you created in a. From what you have described, you will also be creating this user via the Plesk GUI.

GRANT ALL PRIVILEGES ON drupal.* TO nobody@localhost IDENTIFIED BY 'password';

c. You will (in all likelihood) assign rights to your db user (created in step b) via the Plesk GUI. If you have the "assign all" option, choose that. Otherwise, assign as many rights to your db user as allowed. Make sure you can assign "Lock Tables" privileges. If you can't, you might need to switch ISP's.

Note: It has been a while since I have used Plesk, but this covers it to the best of my memory.

From step 3 of the install.txt:

mysql -u nobody -p drupal < database/database.mysql

a. Complete this step via phpMyAdmin. Click the SQL tab, then browse to the database.mysql file. This process is pretty similar to attaching a file to an email using a webmail interface.

You can also contact customer support for your ISP. They will also be able to help with this.

I hope this helps.

Cheers,

bonobo

-------
http://www.funnymonkey.com
Tools for Teachers

-------
http://www.funnymonkey.com

heine’s picture

heine commented

Many hosters with plesk do not allow granting privileges via plesk (or phpmyadmin). Instead they use a set of privileges for every created user. In this case, I hope these defaults contain the lock tables permission.
--
Tips for posting to the forums

bonobo’s picture

bonobo commented

contact customer support for your ISP -- Unfortunately, not all ISP's are drupal-friendly.

Cheers,

bonobo

-------
http://www.funnymonkey.com
Tools for Teachers

-------
http://www.funnymonkey.com

kosherjellyfish’s picture

kosherjellyfish commented

Unfortunately, it seems that I cannot do anything else in Plesk, other than change my passwork for my database user.

Is there an alternative way to install my database? I'll need guidance in using CMD line though.... any to recommend? I've downloaded PuTTY but then after I type in my password, the window closes...

bonobo’s picture

bonobo commented

is done through phpMyAdmin -- you should be able to access that via Plesk -- look for an icon labelled either phpMyAdmin or Administer databases or something like that -- I don't have access to a plesk GUI, so I'm working from memory here with regards to how they label it.

Cheers,

bonobo
-------
http://www.funnymonkey.com
Tools for Teachers

-------
http://www.funnymonkey.com

heine’s picture

heine commented

One of my sites is configured via plesk. Don't like it very much...

Using PLESK, go to databases and click on the name of your database. Now you should see a heading TOOLS and a heading USERS. Just below tools you can see the DB WebAdmin icon (picture is a blue stack with a monkey wrench). Click it. This opens a popup (!) with PHPMyAdmin (disable pop-up blocking).

You already set a username (jiayuan@localhost) in Plesk.

First make sure the relevant database is selected in phpmyadmin. If you have only one database, it is usually selected. If necessary however click 'Databases' in the phpmyadmin start screen and then the database name.

In the left pane of phpmyadmin you'll see a small icon (windowlike) with the word SQL in it. Click it, select the tab 'import files'. Here you can upload the sql file with the database scheme.

If you went to your database with the Databases->dbname route, an SQL tab where you can upload a file is also available.

Good luck.

PS This is the third and last time I write this in this thread. If something isn't clear, please ask.
--
Tips for posting to the forums