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] Link to comment https://forums.phpfreaks.com/topic/26893-lf-help-noob-stuff/ 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] Link to comment https://forums.phpfreaks.com/topic/26893-lf-help-noob-stuff/#findComment-122968 Share on other sites More sharing options...
chaoswarriors Posted November 11, 2006 Author Share Posted November 11, 2006 thanks ;D Link to comment https://forums.phpfreaks.com/topic/26893-lf-help-noob-stuff/#findComment-122973 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.