[Darryus]

hi what happen with MySQL ? i can't create table to my php myadmin?

the error said: Warning: mysql_query() [function.mysql-query]: Access denied for user 'a4334067'@'localhost' (using password: NO) in /home/a4334067/public_html/create_Table.php on line 14

my php script:

PHP Code:

<?php

include_once "teskonek.php";

print("Succesfully connect to server");



$result = "CREATE TABLE my_Members(
id int(11) NOT NULL auto_increment,
firstname varchar(255) NOT NULL,
middlename varchar(255) NULL,
lastname varchar(255) NOT NULL)";

if(mysql_query($result)){
    print "Success in table creation!";
}
else{
    print "no Table created";
}
exit();

?>

the connect server script below

PHP Code:

<?php
$server="mysql5.000webhost.com";
$user = "a4334067_tester";
$password = "xxxxx"; //my password hidden
$db_name = "a4334067_test";

$id_mysql= mysql_connect($server, $user, $password);


mysql_select_db($db_name,$id_mysql);



//Akhir pembacaan data 
mysql_close($id_mysql);


?>

[Passionless]

Hi,
If the connection script successfully connected with the DB may be the problem is that you close the connection at the end of the included script:

//Akhir pembacaan data
mysql_close($id_mysql);

I don't understand if you are trying to create tables with your own PHP scrips or with phpMyAdmin.

[Darryus]

i am creating with my own php script, please help me, i have deleted the mysql closing connection function but still not work

PHP Code:

<?php
$server="mysql5.000webhost.com";
$user = "a4334067_tester";
$password = "xxxxx";
$db_name = "a4334067_test";

$id_mysql= mysql_connect($server, $user, $password);


mysql_select_db($db_name,$id_mysql);




?>

[grace1004]

Were you able to enter into your phpmyadmin through control panel? If not, there's
something wrong with the server. Please check first if you can enter into your phpmyadmin
even if there's no table in your database.

[grace1004]

When I tested your code at my site in free hosting, I got "no Table created" message, not
"Access denied ..." message like you. With--id int(11) NOT NULL auto_increment--there should
be--primary key (id), otherwise table will not be created. After running the following code,
I got "Success in table creation!" message. So, please try this code.

PHP Code:

<?php
//Database connection script

$query = "CREATE TABLE my_Members(
id int(11) NOT NULL auto_increment,
firstname varchar(255) NOT NULL,
middlename varchar(255) NULL,
lastname varchar(255) NOT NULL,
primary key (id)
)";

$result = mysql_query($query);

if($result){
    print "Success in table creation!";
}
else{
    print "no Table created";
}
exit();
?>