View Full Version : my sql connection prob

11-01-2011, 01:04 AM
I am using dreamweaver

installation help

on: Today at 10:10:08 AM


all i am doing is producing a database on my local machine

i have named my database in phpmyadmin

and linked (created) a user for it in the privaleges section also highlighting a password for the user

then i have a connect_to_mysql.php script


1: "die()" will exit the script and show an error statement if something goes wrong with the "connect" or "select" functions.
2: A "mysql_connect()" error usually means your username/password are wrong
3: A "mysql_select_db()" error usually means the database does not exist.
// Place db host name. Sometimes "localhost" but
// sometimes looks like this: >> ???mysql??.someserver.net
$db_host = "localhost";
// Place the username for the MySQL database here
$db_username = "talos342c";
// Place the password for the MySQL database here
$db_pass = "dollybrom1";
// Place the name for the MySQL database here
$db_name = "mydbstore";

// Run the actual connection here
mysql_connect("$db_host","$db_username","$db_pass") or die ("could not connect to mysql");
mysql_select_db("$db_name") or die ("no database");

then i have a mysql_quicktest.php

please help!

// Connect to the file above here
require "connect_to_mysql.php";

echo "<h1>Success in database connection! Happy Coding!</h1>";
// if no success the script would have died before this success message

and they are saved in a file called storescripts both of the above files

so i then proceed to try to seeif i can get a connection


! ) Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'talos342c'@'localhost' (using password: YES) in C:\wamp\www\myNewweb\storescripts\connect_to_mysql.php on line 19
Call Stack
# Time Memory Function Location
1 0.0021 666856 {main}( ) ..\mysql_quicktest.php:0
2 0.0037 672280 require( 'C:\wamp\www\myNewweb\storescripts\connect_to_mysql.php' ) ..\mysql_quicktest.php:3
3 0.0038 673248 mysql_connect ( ) ..\connect_to_mysql.php:19
could not connect to mysql

what i think is happening is that access is being denied due to the password well i have typed the password in time after time into phpmyadmin in the privaleges section, but something is wrong ..

I have had this working but reformatted my pc then went back and did it again and it does not work now, it is almost as if mysql remebers and how many mysql db can you run for free, do not know the inns and outs

Old Pedant
11-01-2011, 01:18 AM
Do this: Bring up a command window (DOS window). Then try the command line version of mysql, thus:

mysql -utalos342c -pdollybrom1 -Dmydbstore

See if that allows you to get into the DB.

If yes, the problem is in PHP.

If no, the problem is in the credentials.