phpMyAdmin and mySQL question.?

Question

Hi there,

I'm new to these technologies (phpMyAdmin and mySQL). Basically, I installed phpMyAdmin in my host directory (where my website resides) and configured the config file, etc. However, once I try to login to phpMyAdmin I get the following error:

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

1.) Do I need to create a mySQL database connection in Dreamweaver for me to successfully login to phpMyAdmin?

2.) I'm having problems creating a mySQL connection in Dreamweaver, where I get the following error message:

1045 Access denied for user "[e-mail]' (using password: YES)

3.) Once I have phpMyAdmin login window, how do I know my username and password? Where do I create this? Or are they the same as my host username and password?

Thanks for all your help!

-Rafael

Answer 1

Here are the answers to your questions :

1) Do I need to create a mySQL database connection in Dreamweaver for me to successfully login to phpMyAdmin?
-------- Dreamweaver and phpMyAdmin are not related in any sense.
2) I'm having problems creating a mySQL connection in Dreamweaver, where I get the following error message:
-------- Are you sure that you have given permissions to the above said user(vistaris), for the above said host name(ahp.affinity.com) to the databases u want to access through dreamweaver. If not try this :
grant *perms* on *dbs*.*tables* to *user*@*host* identified by *pass*

(replace *XXX* with respective values)

3.) Once I have phpMyAdmin login window, how do I know my username and password? Where do I create this? Or are they the same as my host username and password?
---------This login & password is set in config.inc.php. Please read Documentation.txt or Documentation.html for further details.

Answer 2

that means in your config file for phpmyadmin, you have your server settings/password/port/etc information wrong.

Make sure you have each field filled out correctly

Your MySQL user name
The password
the Port/server name/ip


If you dont know your username password for your Mysql Database, and you have a Control Panel on your website, see if you can set up a user for your database through it.

Otherwise, call your webhost.

Answer 3

in the file config.inc.php there are some variables that phpMyAdmin needs to connect to the MySQL database:


$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port

$cfg['Servers'][$i]['user'] = 'username'; // MySQL user
$cfg['Servers'][$i]['password'] = 'password'; // MySQL password (only needed



You need to alter these variables for your environment.

Dreamweaver has absolutely nothing to do with phpMyAdmin... it's not even part of the equation.

Answer 4

MySQL needs to run on the same domain (not necessarily the same computer, just the same network domain) as the code accessing it. It's a security issue.