vb.org Archive - Can't connect to database

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Can't connect to database (https://vborg.vbsupport.ru/showthread.php?t=71484)

Caravan

11-08-2004 02:02 PM

Can't connect to database

Say "hi" to my good buddies at the TLK

filburt1

11-08-2004 02:14 PM

If it's a test server, the default username is "root" and there is no password.

A user in Windows has no relation to a user in MySQL (unlike MS SQL Server). Look at http://www.mysql.com/doc and the syntax for granting (GRANT) all permissions for a given user.

Zachery

11-08-2004 02:40 PM

Quote:

Originally Posted by Belicoso_Fino

I'm having problems connecting to the MySQL database (4.1) on Win 2003 server and PHP 4.3.9 from the install.php script. I get the following message:

I have tried creating a few test databases (from the command line) and no matter what combination of username, passwords, etc, I use I get this error.

I performed all grants on the db but I'm unsure if I've crerated the users properly (or at all as far as the DB is concerned). Being a newbie to MySQL I'm not sure if a Win user is the same as a DB user in MySQL.

I even tried using the root username and pw and still no luck.

Any sugegstions?

You also need to make sure you have an OLD_PASSWORD :)

Zachery

11-08-2004 09:27 PM

Quote:

Originally Posted by Belicoso_Fino

Filburt1,

Thanks, I will try to follow the docs to troubleshoot.

I did give my root account a password, and I've tried configuring that to the config.php file, but still no luck.

Now sure what on "old_password" is...

You are running MySQL 4.1.X and it uses a new connection client, you need to use the old client.

http://dev.mysql.com/doc/mysql/en/Password_hashing.html

All times are GMT. The time now is 02:09 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01297 seconds Memory Usage 1,717KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: