zeusthegreat Posted October 31, 2011 Share Posted October 31, 2011 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 Quote Link to comment Share on other sites More sharing options...
sunfighter Posted October 31, 2011 Share Posted October 31, 2011 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"); Quote Link to comment Share on other sites More sharing options...
zeusthegreat Posted October 31, 2011 Author Share Posted October 31, 2011 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted November 1, 2011 Share Posted November 1, 2011 Then you don't have the right password. Quote Link to comment Share on other sites More sharing options...
zeusthegreat Posted November 1, 2011 Author Share Posted November 1, 2011 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 Quote Link to comment Share on other sites More sharing options...
zeusthegreat Posted November 1, 2011 Author Share Posted November 1, 2011 just created another database and applied username and password to it and it worked, so does this mean that your username and password are stored on a mysql server. Quote Link to comment Share on other sites More sharing options...
fenway Posted November 2, 2011 Share Posted November 2, 2011 just created another database and applied username and password to it and it worked, so does this mean that your username and password are stored on a mysql server. I don't understand what that means. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.