Install Problems - Cannot connect to MySQL

By TristanR on 11 Oct 2007 at 12:35 UTC

Hi,

I am trying to install drupal and I am not getting on very well! I have downloaded the core files, unzipped and placed in my htdocs folder. When I point to my domain I get the Drupal instal page. When I fill in the data base configuration details I get the following error:

Database configuration
The following errors must be resolved before you can continue the installation process:
Database name field is required.
Database username field is required.
Failure to connect to your MySQL database server. MySQL reports the following message: Can't connect to MySQL server on 'localhost' (10061).
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 have checked and double checked with my hosting provider (streamline.net) and they assure me that my details are correct and that my database is active.

Any advice appreciated (I am a novice!).

Regards
Tristan

Comments

Should have added that I am

TristanR commented 11 October 2007 at 21:53

Should have added that I am running Vista!
Hopefuly someone out there can help as I have been going around in circles with this for two days now!

If I have posted this in the

TristanR commented 12 October 2007 at 15:36

If I have posted this in the wrong forum can someone please direct me to the section I am likely to get help with this problem.

Re: Mysql error

karna commented 12 October 2007 at 21:26

It seems that you didn't type in your database name and user name, given:

Database name field is required.
Database username field is required.

Just to understand it better, you are trying to install drupal at a hosting provider, and you have copied the files to the directory of your hosting provider? Or are you installing drupal on a local webserver with a database that is hosted somewhere else?

If you have ssh access to your host you can verify whether the database is accessible by loggin in to your host and

mysql -p -u the-database-username the-database-name

It will ask for the password. If you do not get into the database, ask your provider again.

--------
F.J. Jungen
www.boria.nl

Mysql Error

TristanR commented 13 October 2007 at 06:53

Hi,

I am using version 6.
I have copied the drupal core files onto the root file on my host server.
I do not have ssh access to mysql, I access it through phyadmin.
I have verified login details as accurate for mysql database with my host provider, but when I fill in the fields on the drupal install page I still get the same error message (outlined above).
My mysql database currently has no tables in it, should I upload something from the core files to link?

Thanks
Regards
Tristan

to verify what version of drupal u are installing

tm commented 12 October 2007 at 21:29

are you putting in version 5.2 (current stable production), or v6 (still in alpha testing)? the tag indicates v6...

It gets worse!

TristanR commented 13 October 2007 at 17:11

I have removed v6 and installed v5.2 - However now I get the folowing error message:

Notice: Undefined variable: redirect in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\form.inc on line 267

Notice: Undefined variable: base in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\form.inc on line 464

Notice: Undefined index: #value in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\form.inc on line 1044

Warning: Cannot modify header information - headers already sent by (output started at e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\form.inc:267) in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\common.inc on line 141

Notice: Undefined variable: no_module_preprocess in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\common.inc on line 1467

Notice: Undefined variable: no_theme_preprocess in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\common.inc on line 1488

Database configuration
The following error must be resolved before you can continue the installation process:
Failure to connect to your MySQL database server. MySQL reports the following message: Can't connect to MySQL server on 'localhost' (10061).
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

Somebody please help!

more information

tm commented 13 October 2007 at 17:57

first thing is to get you connecting to a database; the first point should tell us if you have something to connect to. the paths indicate this is a windows machine, so i am hoping they are not running mssql (not drupal compatible).

what does phpinfo tell you?
- does it tell you that mysql is installed and configured?
- what version of php are you using?
- version of operating system?
- web server version?
troubleshooting info...

mysql11.streamline.net Server

TristanR commented 13 October 2007 at 19:24

mysql11.streamline.net
Server version: 5.0.27
phpMyAdmin - 2.10.1
MySQL client version: 5.0.27

I have had difficulty with creating a PHPINFO file, though this will be due to my own ineptitude.

phpinfo

tm commented 13 October 2007 at 19:45

put the following code into a text file:

<?php
phpinfo();
?>

save it as something like "test.php" and upload it to your drupal folder as an text file (vs. binary). point at it with your browser.

we want to be sure that you have "mysql" or "mysqli" as a configured option in php, or drupal will not see your database. i hope your service is aware of the mysql 5.0.27 php connector issue, if they are using windows as an operating system; it appears that streamline.net has a windows option.

Thanks - Here is some of the

TristanR commented 13 October 2007 at 20:06

Thanks - Here is some of the output:

PHP Version 4.4.4

System Windows NT IIS6100 5.2 build 3790
Build Date Aug 16 2006 01:13:15
Server API ISAPI
Virtual Directory Support enabled
Configuration File (php.ini) Path C:\WINDOWS\php.ini
PHP API 20020918
PHP Extension 20020429
Zend Extension 20050606
Debug Build no
Zend Memory Manager enabled
Thread Safety enabled
Registered PHP Streams php, http, ftp, compress.zlib
mysql
MySQL Support enabled
Active Persistent Links 2
Active Links 2
Client API version 3.23.49

MSSQL Support enabled
Active Persistent Links 0
Active Links 0
Library version 7.0

Directive Local Value Master Value
mssql.allow_persistent On On
mssql.batchsize 0 0
mssql.compatability_mode Off Off
mssql.connect_timeout 5 5
mssql.datetimeconvert On On
mssql.max_links Unlimited Unlimited
mssql.max_persistent Unlimited Unlimited
mssql.max_procs Unlimited Unlimited
mssql.min_error_severity 10 10
mssql.min_message_severity 10 10
mssql.secure_connection Off Off
mssql.textlimit Server default Server default
mssql.textsize Server default Server default
mssql.timeout 60 60

mysql
MySQL Support enabled
Active Persistent Links 2
Active Links 2
Client API version 3.23.49

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

I do have the option to change to a linux server, but as I am using windows on my own pc I thought there would be a conflict

hmm...

tm commented 13 October 2007 at 21:16

it appears that mysql support is enabled.

went looking for "mysql11.streamline.net" in google;l seems the database may be on a separate host. can you verify if the connection is for "localhost" or for "mysql11.streamline.net" (or separate ip address)?

revisited your original post; the error is that it can't find it on the localhost... if you have it available to you, see if you can connect via phpmyadmin. if you can, that would verify connectivity via php/web. if not, ask the host if this database is available/started. seems silly, but we should not assume anything.

mysql11.streamline.net

TristanR commented 13 October 2007 at 22:00

Hi,

Thanks for your help so far - very much appreciated.

I can connect to the database through phpmyadmin. So far there are no tables within the database.
The server info for the database is mysql11.streamline.net

hey!

tm commented 13 October 2007 at 22:12

when you are in the drupal installation screen, is there an "advanced" or "options"-type thingy? open that up and see if you need to make some changes. the default installation seems to assume the database is on "localhost" (performance reasons), but yours is not.

we are still doing the v5.2 install, yes?

Now past the install screen..................but

TristanR commented 13 October 2007 at 22:42

Yes, still doing the v5.2 install.

I made the adjustment on the advanced section to let it know where the database is and finally got past the config/install page.
However I just have a white screen with the following errors:

Notice: Undefined index: comment in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\install.inc on line 207

Notice: Undefined index: comment in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\install.inc on line 207

Warning: Cannot modify header information - headers already sent by (output started at e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\install.inc:207) in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\install.inc on line 573

Line 207 of includes/install.inc is copied below:
$buffer .= '$'. $variable[1] ." = '". $setting['value'] ."';". ($setting['comment'] ? ' // '. $setting['comment'] ."\n" : "\n");

getting there...

tm commented 13 October 2007 at 22:46

see if this applies to you: http://drupal.org/node/1424. hopefully, it is the first case and we can move on.

the white screen is an issue, some references: http://drupal.org/node/158043 (which leads to http://drupal.org/node/147534). you can use your phpinfo script to check for memory_limit; the last one you posted indicates php.ini is in the windows folder, so i do not know if you can do anything with that (ask your host for options on increasing php's memory_limit to at least 32mb, to make room for the good stuff).

More errors

TristanR commented 13 October 2007 at 22:55

I am not getting the 'headers already sent' errors anymore! Hoerver I am getting a whole lot more:

Warning: Table 'atricilla1.access' doesn't exist query: SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'host' AND LOWER('86.141.159.239') LIKE LOWER(mask) ORDER BY status DESC LIMIT 0, 1 in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc:172) in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\bootstrap.inc on line 862

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc:172) in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\bootstrap.inc on line 862

Warning: Table 'atricilla1.cache' doesn't exist query: SELECT data, created, headers, expire FROM cache WHERE cid = 'variables' in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

Warning: Table 'atricilla1.variable' doesn't exist query: SELECT * FROM variable in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

Notice: Undefined variable: variables in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\bootstrap.inc on line 392

Warning: Table 'atricilla1.cache' doesn't exist query: LOCK TABLES cache WRITE in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

Warning: Table 'atricilla1.cache' doesn't exist query: UPDATE cache SET data = 'N;', created = 1192315850, expire = 0, headers = '' WHERE cid = 'variables' in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

Notice: Undefined variable: variables in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\bootstrap.inc on line 399

Warning: Table 'atricilla1.cache_page' doesn't exist query: SELECT data, created, headers, expire FROM cache_page WHERE cid = 'http://www.atricillaimages.co.uk/index.php' in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

Warning: Cannot modify header information - headers already sent by (output started at e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc:172) in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\bootstrap.inc on line 531

Warning: Table 'atricilla1.url_alias' doesn't exist query: SELECT COUNT(pid) FROM url_alias in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

Warning: Table 'atricilla1.system' doesn't exist query: SELECT * FROM system WHERE type = 'theme' in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

Notice: Undefined property: theme in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\theme.inc on line 45

Notice: Undefined index: garland in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\theme.inc on line 58

Notice: Undefined index: garland in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\theme.inc on line 67

Notice: Undefined index: garland in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\theme.inc on line 72

Notice: Undefined index: garland in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\theme.inc on line 76

Warning: Table 'atricilla1.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Cannot modify header information - headers already sent by (output started at e:\\domains\\a\\atricillaimages.co.uk\\user\\htdocs\\includes\\database.mysql.inc:172) in e:\\domains\\a\\atricillaimages.co.uk\\user\\htdocs\\includes\\common.inc on line 141.', 2, '', 'http://www.atricillaimages.co.uk/index.php', '', '86.141.159.239', 1192315850) in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

Warning: Table 'atricilla1.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'atricilla1.system' doesn't exist\nquery: SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC in e:\\domains\\a\\atricillaimages.co.uk\\user\\htdocs\\includes\\database.mysql.inc on line 172.', 2, '', 'http://www.atricillaimages.co.uk/index.php', '', '86.141.159.239', 1192315850) in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

Warning: Table 'atricilla1.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'atricilla1.cache_menu' doesn't exist\nquery: SELECT data, created, headers, expire FROM cache_menu WHERE cid = '0:en' in e:\\domains\\a\\atricillaimages.co.uk\\user\\htdocs\\includes\\database.mysql.inc on line 172.', 2, '', 'http://www.atricillaimages.co.uk/index.php', '', '86.141.159.239', 1192315850) in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

Warning: Table 'atricilla1.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'atricilla1.cache_menu' doesn't exist\nquery: LOCK TABLES cache_menu WRITE in e:\\domains\\a\\atricillaimages.co.uk\\user\\htdocs\\includes\\database.mysql.inc on line 172.', 2, '', 'http://www.atricillaimages.co.uk/index.php', '', '86.141.159.239', 1192315850) in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

Warning: Table 'atricilla1.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'atricilla1.cache_menu' doesn't exist\nquery: UPDATE cache_menu SET data = 'a:4:{s:10:\\"path index\\";a:0:{}s:5:\\"items\\";a:2:{i:0;a:5:{s:4:\\"path\\";s:0:\\"\\";s:5:\\"title\\";s:0:\\"\\";s:4:\\"type\\";i:1;s:3:\\"pid\\";i:1;s:8:\\"children\\";a:1:{i:0;i:1;}}i:1;a:6:{s:3:\\"pid\\";i:0;s:4:\\"path\\";s:0:\\"\\";s:5:\\"title\\";s:10:\\"Navigation\\";s:6:\\"weight\\" in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

Warning: Table 'atricilla1.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Cannot modify header information - headers already sent by (output started at e:\\domains\\a\\atricillaimages.co.uk\\user\\htdocs\\includes\\database.mysql.inc:172) in e:\\domains\\a\\atricillaimages.co.uk\\user\\htdocs\\includes\\common.inc on line 141.', 2, '', 'http://www.atricillaimages.co.uk/index.php', '', '86.141.159.239', 1192315850) in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

Warning: Table 'atricilla1.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'atricilla1.watchdog' doesn't exist\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'page not found', 'node', 1, '', 'http://www.atricillaimages.co.uk/index.php', '', '86.141.159.239', 1192315850) in e:\\domains\\a\\atricillaimages.co.uk\\user\\htdocs\\includes\\database.mysql.inc on line 172.', 2, '', 'http://www.atricillaimages.co.uk/index.php', '', '86.141.159.239', 1192315850) in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

Fatal error: Call to undefined function: block_list() in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\theme.inc on line 1018

Warning: Table 'atricilla1.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'atricilla1.sessions' doesn't exist\nquery: SELECT sid FROM sessions WHERE sid = 'f6f1820e57fdfbccf950963e0dbd5ab1' in e:\\domains\\a\\atricillaimages.co.uk\\user\\htdocs\\includes\\database.mysql.inc on line 172.', 2, '', 'http://www.atricillaimages.co.uk/index.php', '', '86.141.159.239', 1192315850) in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

Warning: Table 'atricilla1.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'atricilla1.sessions' doesn't exist\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES ('f6f1820e57fdfbccf950963e0dbd5ab1', 0, 0, '86.141.159.239', 'messages|a:1:{s:5:\\"error\\";a:7:{i:0;s:249:\\"warning: Cannot modify header information - headers already sent by (output started at e:\\\\domains\\\\a\\\\atricillaimages.co.uk\\\\user\\\\htdocs\\\\includes\\\\database.mysql.inc:172) in e:\\\\domains\\\\a\\\\atricillaimages.co.uk\\\\user\\\\htdocs\\\\includes\\\\common.inc on line 141.\\";i:1;s:291:\\"user warning: Table &#039;atricilla1.system&#039; doesn&#039;t exist\ in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172

okay...

tm commented 13 October 2007 at 23:10

don't know what the tables are; is there a prefix (atricilla1) being added during the setup? do you need table prefixes for later use?

considering where we are, do we have the option to "start over?" it may be cleaner. i am wondering if the start/stop thing messed us up.

taking what you now know, if you were to truncate (empty) the database, and upload a fresh drupal file set (delete the old one), think you can run through the installation?

since you have phpmyadmin access, you should be able to delete all the tables (not the database!).

waiting for a positive response.

Re-install

TristanR commented 13 October 2007 at 23:11

I have carried out a complete re-install, got past the initial install page again.
I am now on a white screen with the following error messages:

Notice: Undefined index: comment in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\install.inc on line 207

Notice: Undefined index: comment in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\install.inc on line 207

poop!

tm commented 13 October 2007 at 23:36

i am officially stuck. other than verifying that your database user has sufficient rights (SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES), i don't know. it is in that first error message...

well, maybe not quite. the lines in the error point to settings.php (in sites/default); can you see if 1) the file is writable, and 2) if any changes were made to the file (you would see your $db_url written in there).

(sorry, you are not experiencing memory errors; wrong kind of white screen. my mis-read.)

edit added: you have the option of use the irc channel for immediate help. the howto is on the support tab.

settings.php

TristanR commented 13 October 2007 at 23:40

If by writable you mean can I alter the file, then the answer is yes.
There have been some changes made to the file (my $db_url etc is written in).

well...

tm commented 13 October 2007 at 23:48

per http://drupal.org/node/120216;

since you already have $db_url set, try running http://yoursite/install.php manually.

sorry, not helping much here.

running manual install

TristanR commented 13 October 2007 at 23:52

Ok, I have done this and I get the following error message:

user warning: Access denied for user 'atricilla1'@'%' to database 'atricilla1' query: CREATE TEMPORARY TABLE missing_nids SELECT n.nid, n.changed, n.uid FROM node n LEFT JOIN node_comment_statistics c ON n.nid = c.nid WHERE c.comment_count IS NULL in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172.
user warning: Table 'atricilla1.missing_nids' doesn't exist query: INSERT INTO node_comment_statistics (nid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) SELECT n.nid, n.changed, NULL, n.uid, 0 FROM missing_nids n in e:\domains\a\atricillaimages.co.uk\user\htdocs\includes\database.mysql.inc on line 172.

DB Collation Language

TristanR commented 13 October 2007 at 23:58

Can I just check what collation language the database should be in?

not sure, but

tm commented 14 October 2007 at 00:07

http://drupal.org/node/55794 indicates "utf8_general_ci" and charset is utf8.

let's verify that your

tm commented 14 October 2007 at 00:01

let's verify that your database user has the required rights (in the poop! comment). clear the database again, then run the installer from install.php (since settings.php is already set).

the critical thing we are looking for here is the "CREATE TEMPORARY TABLE" permission for your database user.

I have cleared the database

TristanR commented 14 October 2007 at 00:13

I have cleared the database and run the install.php (www.mysite.co.uk/install.php) and have the same error message as before:

permissions

tm commented 14 October 2007 at 00:27

did you verify the permissions for the database user? CREATE TEMPORARY TABLE needs to be there.

you verify this in phpmyadmin; when you are in your database, go to the "privileges" tab. next to your user's name, it should list the privileges. they should be "SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES". if you do not have all of them, have your provider update your permissions for you.

when that is done, clear your database and run install.php again. we can do this!

Permissions Tab

TristanR commented 14 October 2007 at 00:34

I don't seem to have a permissions tab!
I have sent a support ticket to my provider asking for verification - I guess I will not hear from them until tomorrow morning now.

not a bad thing...

tm commented 14 October 2007 at 00:39

making progress, but been on it for awhile. a fresh mind might be a good thing.

Agreed!

TristanR commented 14 October 2007 at 00:42

Thanks for your help so far - Hopefully be back on it tomorrow!

Still waiting to hear from my provider

TristanR commented 14 October 2007 at 20:14

I am still waiting to hear back from my provider regarding the Mysql database permissions. They are looking at my query, but it has been raised to a level 2 query due to the complexity. Hopefully will know more tomorrow!

complexity?

tm commented 14 October 2007 at 20:23

it may be that they don't allow the "create temporary tables" privilege... have to look at what others have done in this case.

suggestion: when you get an answer, start this thread over again from your original posting ("add comment"), before it totally disappears into the right margin(!). :D

Streamline.net - Cannot create temporary table in Mysql db

TristanR commented 15 October 2007 at 09:03

Hi,

I have heard back from my provider and they have allowed me all permissions in mysql database except 'Create Temporary Tables'

Drupal is GO!

TristanR commented 15 October 2007 at 12:26

Drupal is now on my server and working - All I have to do now is work out how to use it ;-)

Thanks very, very, very, very much for all your help on this!

Yay!

tm commented 15 October 2007 at 17:56

Good job!

What is up with the "create temporary tables" thing? Hope it does not bite you later.

"create temporary tables"

TristanR commented 15 October 2007 at 21:22

Not sure about the "create temporary tables" thing. Once the other missing permissions had been enabled, the install seemed to go smoothly. Fingers crossed it won't cause any problems later! I am currently working my way through the installation of Gallery2 as I have over 2000 images to go on my website!

Install Problems - Cannot connect to MySQL

Comments

New forum topics