![]() |
|
| |||||||
| Notices |
| mySQL & PHP Discussions, information and help with mySQL and PHP. |
![]() |
| | LinkBack | Thread Tools |
|
#1
| |||
| |||
| When I tried to create a simple table for testing purposes I've got the following message : Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'fgnzvvaa_peet'@'voda20.voda20.com' (using password: YES) in /home/fgnzvvaa/public_html/phpdbase/skep1.php on line 3 Access denied for user 'fgnzvvaa_peet'@'voda20.voda20.com' (using password: YES) I did follow the instructions clearly on how to create database and user. Plus I did connect the user to the database. The password is correct . password = klub2008 I also put in the IP address of a possible remote server because I have not transfer everything to vodahost yet. Please help me |
|
#2
| ||||
| ||||
| Where ever you have "voda20.voda20.com" set, change it to be "localhost" instead
__________________ Register/Login Script Do you use a Password Protected Directory? Need a way to allow users to make their own account, try my .htaccess Login Script |
|
#4
| |||
| |||
| For me is also a starting point. I learned that in the connection statement you must include the DATABASE USER, DATABASE PASSWORD and DATABASE HOST (last one is "localhost") but need to create first the DATABASE NAME. If you have not created the database, that error will occur. |
|
#5
| ||||
| ||||
| You must look in your connection script or in your configuration file. You have mistaken the host
__________________ Navaldesign Logger Lite: Low Cost, Customizable, multifeatured Login script Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more.... Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA! |
|
#6
| |||
| |||
| My script is : <?php // Connects to your Database mysql_connect("www.offventure.com", "fgnzvvaa_peet", "klub2008") or die(mysql_error()); mysql_select_db("fgnzvvaa_club") or die(mysql_error()); mysql_query("CREATE TABLE toets ( name VARCHAR(30), age INT, car VARCHAR(30))"); Print "Your table has been created"; ?> |
|
#7
| ||||
| ||||
| As watdaflip said your problem is that you have provided your domain name as host, whilst it should be "localhost". The third line should be: mysql_connect("localhost", "fgnzvvaa_peet", "klub2008") or die(mysql_error());
__________________ Navaldesign Logger Lite: Low Cost, Customizable, multifeatured Login script Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more.... Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA! |