chaoswarriors Posted November 11, 2006 Share Posted November 11, 2006 i cant get this stupid thing to work.. i just started getting into MYSQL:Lets say to start, my DB name is Johndoe_db, my pass is WoWrocksAm i just doing something wrong? ???[code]<?php$con = mysql_connect("localhost","johndoe","WoWrocks");if (!$con) { die('Could not connect: ' . mysql_error()); }// Create databaseif (mysql_query("CREATE DATABASE db",$con)) { echo "Database created"; }else { echo "Error creating database: " . mysql_error(); }// Create table in my_db databasemysql_select_db("db", $con);$sql = "CREATE TABLE Person (FirstName varchar(15),LastName varchar(15),Age int)";mysql_query($sql,$con);mysql_close($con);?> [/code][quote]Error creating database: Access denied for user 'johndoe'@'localhost' to database 'db' [/quote] Quote Link to comment Share on other sites More sharing options...
marcus Posted November 11, 2006 Share Posted November 11, 2006 Easy error.just make it all one line[code]$connection = mysql_connect(host,dbuser,dbpass);$db = mysql_select_db(dbname,$connection);[/code] Quote Link to comment Share on other sites More sharing options...
chaoswarriors Posted November 11, 2006 Author Share Posted November 11, 2006 thanks ;D 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.