Access Denied!

acraggs

I have recently begun experimenting with PHP and MySQL. I have put together a sample database and the following PHP in my web page. I have removed the actual user name and password as my host uses the main log in username/password for database management. When I run the page on line I get an "access denied" message but I know the password and username are correct and I have set the permissions to 777. Can anyone suggest what I am doing wrong or any alternative methods of connecting to the localhost.

<html>

<body>
<?php

$vusername = "*****"; //your username for you local system
$pwd ="*****"; //password to accecss mySQL
$host = "localhost"; //host is localhost - even for most web hosts
$dbname = "Pets"; //db name to be accessed

//connect to db
//$conn=mysql_connect($host, $username, $pwd) or die ("Unable to connect to database");

if (!($conn=mysql_connect($host, $vusername, $pwd)))  {
    printf("error connecting to DB by user = $username and pwd=$pwd");
    exit;
}
   $db=mysql_select_db($dbname,$conn) or die("Unable to connect to database1");

</body>

</html>
😕

statrat

do you have to add that user to that particular db? i know in my system, i use my main logon/pass for "database management", but then create and assign users access rights to each db.

acraggs

Thanks for the response. I am using the online table creation tool and do not know how to assign individual passwords or users. Could you offer any advice. I also don't know how to asign permissions.

Thank you.

statrat

which tool is that? phpMyAdmin? or is that separate from your database management interface? my host has a screen to create databases and assign users. then you can also go into phpmyadmin to diddle with the databases and tables. actually, i bet users and permissions are probably not your problem, but just in case.

Adding Users

acraggs

Thank you for your response.

The system I use is provided by qawebhosting.com and appears to use an interface called MySQL Admintrator. When you access this software the only options presented to you are list tables and create tables. When you access create tables the only options presented are table name and number of fields. Once you enter this information and submit you get a table giving you the option to set the various field parameters but no way of adding users/passwords that I can see. Do you think this is a limitation of my provider? They tell me they have plenty of people using PHP but if I cannot get past the access issue I will not be able to learn more about the coding.

I am very frustrated as you can tell and would appreciate any further advice you can provide.

statrat

i just ran your code (from the first post, with my user/pass/etc. substituted) and it worked fine. If you're getting the "Access Denied" message, it means your connecting to the db (otherwise you would see "error connecting to DB by user = username and pwd=pwd"), but denied permission to read. i can only tell you to contact your host about what your user/pass/hostname should be. make sure that "localhost" is correct (it usually is, but not 100% of the time). also, make sure you don't have to specify a different port than the default (3306). lastly, i would get a different host (judging by their webpage, lack of support, broken FAQ links). good luck, keep at it, and let me know if you have more ?s.