NEWBIE-How do you create a database or even log in?????HELP!!!!!!

kaycee_1900 - December 19, 2007 - 23:00
Project:Database Administration
Version:5.x-1.x-dev
Component:MySQL Support
Category:support request
Priority:normal
Assigned:Unassigned
Status:closed
Description

I've looking everwhere.

How do you create a database 1st?

I'm using the xampp and it looks nothing like mysql.......
I made a database on my site i'm using godaddy....but I don't know how to change the INSTALL.mysql.txt
What do I need to use with my host to login.....and it seems to be using PHP not mysql?????

// $Id: INSTALL.mysql.txt,v 1.7 2006/09/08 16:29:35 dries Exp $

CREATE THE MySQL DATABASE
--------------------------

This step is only necessary if you don't already have a database set-up (e.g. by
your host).

In the following examples, 'username' is an example MySQL user which
has the CREATE and GRANT privileges.

Use the appropriate user name for your
system.

First, you must create a new database for your Drupal site (here, 'databasename'
is the name of the new database):

mysqladmin -u username -p create databasename

MySQL will prompt for the 'username' database password and then create the
initial database files.

Next you must login and set the access database rights:

mysql -u username -p

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

At the MySQL
prompt, enter following command:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE
TEMPORARY TABLES, LOCK TABLES
ON databasename.*
TO 'username'@'localhost' IDENTIFIED BY 'password';

where

'databasename' is the name of your database
'username@localhost' is the username of your MySQL account
'password' is the password required for that username

Note:
Unless your database user has all of the privileges listed above, you will
not be able to run Drupal.

If successful, MySQL will reply with:

Query OK, 0 rows affected

To activate the new permissions, enter the following command:

FLUSH PRIVILEGES;

#1

kaycee_1900 - December 19, 2007 - 23:01

#2

VM - December 19, 2007 - 23:05

It doesn't look to me like your question has anything to do with the DB administration module and everything to do with installing drupal on your localhost.
PHP is the programming language MySQL is the Database backend. Xampp is packaged with both. XAMPP = Apache, MySQL, PHP & Perl all in one package.
questions about Xampp woud be better served on the Xammp forums, or by reading the documentation packaged with XAMPP.
Marking this as closed, if your question is specific to this module feel free to reopen, if not, create a forum thread.

#3

VM - December 19, 2007 - 23:07
Priority:critical» normal
Status:active» closed
 
 

Drupal is a registered trademark of Dries Buytaert.