mySQL connection (phpMyAdmin)

[jebbeler]

Hello,
I am very new to mySQL and have setup a new database using myPHPAdmin. The name of the database is calendar. I enter the following in the escalDB.php file and get an error every time.

$dbHost = "localhost";
$dbUserLogin = "root";
$dbPassword = "********"; Actual pasword is here in the file.
$dbName = "calendar";

I get the following error when I run escalInstall.php

* There was an error connecting to the database.

Please check the settings in the 'escalDB.php' file and try again.

The error was reported as:
Access denied for user: 'root@localhost' (Using password: YES)
Access denied for user: 'root@localhost' (Using password: YES)

Any help would be greatly appreciated.

Joe.

[pseudomega]

.....................

[tifosi]

If you're hosted remotely - i.e at a webhosting company, it's pretty uinlikely that the host would be calle 'localhost'.

And your user name certainly won't be root!

The host should have a admin panel which gives all of these variables explicitly. Also check for capitalisation *nix is sensitive to this.

The set up you have sounds like a local (PC based) setup??? :(

[jebbeler]

I went back and checked the things suggested. I also tried creating a new user, then reloaded MySQL. Still get the same error.

I tried localhost, which according to another post I found regarding phpMyAdmin should be fine. There is also 2 other hosts setup in the mySQL database one that is my URL and and one that is my IP address. When I try those I get an error like this:

Can't connect to MySQL server on 'myIP' (111)

I would appreciate any other suggestions as I really don't have much of a clue about how to use MySQL and I was hoping this calendar program would be an easy thing to setup.


Thanks, jOE

[pseudomega]

...................

[revoemag]

If your phpMyAdmin is working properly, verify that the host, user, and password in the config.inc.php file are the same as what you're entering in the escalDB.php script.

If they are not, either change the escalDB.php file to be the same, or verify that you have created a user in mysql with the apropriate permissions to read/write the calendar database.

Also, can you get to mysql from the command-line. Some-times it is useful to be able to look directly at the info. Is this a new installation of mysql, or have you used it on other projects before?

rev

[jebbeler]

Thanks for everyones help but... so far nothing is working. I don't have a button that says "add user" like I have seen on some sites documentation of phpMyAdmin. I am using version 2.1.0 which was provided by my web host.

This is a first time install of mySQL, and if there is a way to get to a command line interface I'm not sure I know where it is, or for that matter what to enter.

I checked the config.inc.php file and it seems list things pretty much the way I started. This is what the main part of the config file looks like.

// You can disable a server config entry by setting host to ''.
$cfgServers[1]['host'] = 'localhost'; // MySQL hostname
$cfgServers[1]['port'] = ''; // MySQL port - leave blank for default port
$cfgServers[1]['adv_auth'] = false; // Use advanced authentication?
$cfgServers[1]['stduser'] = 'root'; // MySQL standard user (only needed with advanced auth)
$cfgServers[1]['stdpass'] = ''; // MySQL standard password (only needed with advanced auth)
$cfgServers[1]['user'] = 'root'; // MySQL user (only needed with basic auth)

$cfgServers[1]['password'] ="$get_pass"; // MySQL password (only needed with basic auth)
$cfgServers[1]['only_db'] = ''; // If set to a db-name, only this db is accessible
$cfgServers[1]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname

I can see the password settings in the user listing for mySQL. I have tried all kinds of combinations and whenevr I have what seems to be a valid host, username and password I always get an acccess denied error when I run escalInstall.php.

If anyone has any other thoughts, please let me know. Thanks again.

jOE

[revoemag]

This might be a question better asked to your web hosting company's tech support. They should be familiar with any nuances in connecting to their mysql server.

Have you tried accessing it through the command line? If you can telnet (or ssh) to your web site, then you might be able to access mysql from the back-end (command-line).

I would first make sure with the tech support that everything is as it should be.

rev

[jebbeler]

Okay I finally got it. Turns out that I needed to change the password from the default one that was installed with MySQL. Thanks to everyone for your input. I'm sure I'll have more questions as I try to incorporate the calendar into my site.

:D

jOE.