Jump to content

installation help


zeusthegreat

Recommended Posts

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

 

<?php  

/*  
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


<?php   
// 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

 

http//localhost/myNewweb/storescripts/mysql_quicktest.php

 

! ) 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

Link to comment
Share on other sites

In your connect_to_mysql.php script change these lines:

mysql_connect("$db_host","$db_username","$db_pass") or die ("could not connect to mysql");
mysql_select_db("$db_name") or die ("no database");

 

to:

$link = mysql_connect("$db_host","$db_username","$db_pass") or die ("could not connect to mysql");
$link = mysql_select_db("$db_name") or die ("no database");

Link to comment
Share on other sites

have tryed it but it gives the same result

 

 

 

( ! ) 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.0052 666856 {main}( ) ..\mysql_quicktest.php:0

2 0.0060 672552 require( 'C:\wamp\www\myNewweb\storescripts\connect_to_mysql.php' ) ..\mysql_quicktest.php:6

3 0.0060 673520 mysql_connect ( ) ..\connect_to_mysql.php:19

 

could not connect to mysql

 

 

have looked into this error and it saya that it is usually username or password errors

Link to comment
Share on other sites

sorry for being ignorant

 

download wamp server stack

install it

after installation

 

name db

add new user

 

is this where i am going wrong adding a new user

 

 

what section of wamp server do you put your username and password in

 

as i cannot see where you put your db credentials in phpmyadmin

 

as i am doing this database on my local machine

 

i will carry on with what i do

 

 

add a new user

 

username and password  written down

 

 

create user

 

then after that i try to recieve my connection message through my browser

 

and i get the message that indicates that my password is incorrect.

 

tryed uninstalling and reinstalling to  no resolve

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.